[hive]hive开窗大小

create table test.b5 as
select
*,
collect_set(year) over(partition by zheng_shi_indicator,guo_biao_di_yu_dai_ma,sub order by year) one_range
from test.b4 

create table test.b6 as
select
*,
collect_set(year) over(partition by zheng_shi_indicator,guo_biao_di_yu_dai_ma,sub) one_range
from test.b4

按找聚合的字段进行排序，开窗大小会被改变