Hive窗口函数sum、min、max、avg入门
1....()操作
select cookieid, createtime, pv,
min(pv) over(partition by cookieid) as min1,
min(pv) over(partition...rows between current row and unbounded following) as min4,
min(pv) over(partition by cookieid order...()操作
select cookieid,createtime,pv,
max(pv) over(partition by cookieid) as max1,
max(pv) over(partition...,MAX