hive 的开窗函数sum() over() 函数_hive sum over

窗口分析函数 sum() over() :可以实现在窗口中进行逐行累加
测试数据:
这个是网上比较经典的案例了

2: jdbc:hive2://hadoop-03:10000> select * from t_access_amount;
+----------------------+------------------------+-------------------------+--+
| t_access_amount.uid  | t_access_amount.month  | t_access_amount.amount  |
+----------------------+------------------------+-------------------------+--+
| A                    | 2015-01                | 33                      |
| A                    | 2015-02                | 10                      |
| A                    | 2015-03                | 20                      |
| B                    | 2015-01                | 30                      |
| B                    | 2015-02                | 15                      |
| B                    | 2015-03                | 45                      |
| C                    | 2015-01                | 30                      |
| C                    
1
2
3
4
5
6
7
8
9
10
11