HIVE- 各年逐月累加函数

select
year_flag
,month_flag
,field
,SUM(field) OVER (PARTITION BY year_flag ORDER BY month_flag)
from table
;