关于字符串转换成日期格式的函数:
select from_unixtime(unix_timestamp('2015/01/01' ,'yyyy/MM/dd'), 'yyyy-MM-dd') ;
2019-01-01
建表语句:
drop table action if exists ;
create table action( id string , vd string, vc int ) ;
查询语句为:
select a.id ,
a.dt,
a.sc ,
sum(sc) over(partition by a.id order by a.dt)
from
(select id ,
from_unixtime(unix_timestamp(vd ,'yyyy/MM/dd'), 'yyyy-MM') dt,
sum(vc) sc
from action
group by id,from_unixtime(unix_timestamp(vd ,'yyyy/MM/dd'), 'yyyy-MM')
order by id , dt ) a;