Hive中window as与with as的用法

Hive中自定义变量的用法

承接上篇Hive窗口帧文章，具体主页有

两个窗口帧方式：rows、range

range格式：如果当前值在80，求前2后2所有值的平均值，

取值就会在80-2=78和80+2=82之内的所有行

//格式1
avg(score) over (partition by clazz order by score desc range between 2 perceding and 2 following)

select *,
row_number() over(partition by clazz order by score desc) as num,
rank() over(partition by clazz order by score desc) as num2,
avg(score) over(partition by clazz order by score desc rows between 1 preceding and 1 following)