hive 中over()窗口函数
简单找一份数据用来实验:
hql:
select name,orderdate,cost,
sum(cost) over() as sample1,--所有行相加
sum(cost) over(partition by name) as sample2,--按name分组,组内数据相加
sum(cost) over(partition by name order by orderdate)...
原创
2019-05-17 18:13:48 ·
2467 阅读 ·
0 评论