impalasql获取上当前用户上一笔数据
解决方法:
以userid为统计分区,chtime倒序,LAG(chtime, 1) OVER ( PARTITION BY userid ORDER BY chtime )获取的就是上一笔记录的chtime
SELECT LAG(chtime, 1) OVER ( PARTITION BY userid ORDER BY chtime ) from dwd_oil;
向大家推荐《Activiti工作流实战教程》:https://xiaozhuanlan.com/activiti