select
etl_date
,sum(order_cnt) over(partition by etl_month order by etl_date asc) as order_cnt_1m --当月累计订单量
,sum(order_cnt) over(partition by etl_year order by etl_date asc) as order_cnt_1y --当年累计订单量
from (
select
etl_date
,substr(etl_date,1,7) as etl_month
,substr(etl_date,1,4) as etl_year
,sum(order_cnt) as order_cnt --每日订单量
from order
group by etl_date
) t
hive、maxcompute计算当月累计、当年累计值示例
最新推荐文章于 2023-01-10 23:57:30 发布