FAILED SemanticException Range based Window Frame can have only 1 Sort Key
一、描述
执行select *,sum(money) over(partition by userid,month order by userid asc,month asc range between 0 and 2 2 following) aa from user order by userid,month;报如下错误
二、解决方法
select *,sum(money) over(partition by userid,month order by month asc range between 0 and 2 2 following) aa from user order by userid,month