hive复杂数据查询

[跌倒的小绵羊]

有如下访客访问次数统计表 t_access_times
访客 月份 访问次数
A 2015-01-02 5
A 2015-01-03 15
B 2015-01-01 5
A 2015-01-04 8
B 2015-01-05 25
A 2015-01-06 5
A 2015-02-02 4
A 2015-02-06 6
B 2015-02-06 10
B 2015-02-07 5
…… …… ……
需要输出报表：t_access_times_report
访客 月份 月访问总计 累计访问总计
A 2015-01 33 33
A 2015-02 10 43
……. ……. ……. …….
B 2015-01 30 30
B 2015-02 15 45
---------------------------------------------------
各位大神这个hive语句怎么写才能搞出来啊，我是菜鸟。第一次提问，忘大神指点下啊谢谢了

[siwluxuefeng]

with a ( select cust, substr(date,0,8) as month, sum(访问次数) as pv from t_access_times group by cust, month ) select a1.cust, a1.month, a1.pv, sum(a2.pv) as sum_pv from a a1 join a a2 on a1.cust = a2.cust and a1.month >= a2.month

[跌倒的小绵羊]

迟到的谢谢，大神