方案二實現如下：

-- 級聯累加求和場景 /* login.txtA,2021-01,5 A,2021-01,15 B,2021-01,5 A,2021-01,8 B,2021-01,25 A,2021-01,5 A,2021-02,4 A,2021-02,6 B,2021-02,10 B,2021-02,5 A,2021-03,7 B,2021-03,9 A,2021-03,11 B,2021-03,6 */ create table money (user_id string,month string,money int ) row format delimited fields terminated by ',';load data local inpath '/root/hivedata/money.txt' overwrite into table money;select * from money;-- 先查詢每個用戶每個月的消費總金額 select user_id,month,sum(money) month_money from money group by user_id, month;-- 再累計每個用戶到當前月的消費總金額 with tmp_money as (select user_id,month,sum(money) month_moneyfrom moneygroup by user_id, month ) select user_id,month,month_money,sum(month_money) over (partition by user_id order by month-- rows between unbounded preceding and current row) as sum_month_money from tmp_money;

總結

以上是生活随笔為你收集整理的Hive窗口函数应用：级联累加求和场景的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。