hsql例题

关于字符串转换成日期格式的函数：

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;