hive累计求和

需求：part为地区，amount为消费金额，按amount降序排列并对amount累计求和。

造一批数据，

SELECT '1' AS part, 11 AS amount
UNION ALL
SELECT '2' AS part, 33 AS amount
UNION ALL
SELECT '3' AS part, 22 AS amount
UNION ALL
SELECT '4' AS part, 55 AS amount
UNION ALL
SELECT '5' AS part, 44 AS amount

part	amount
1	11
2