HIVE 中将下一条记录的创建时间作为上一条记录的结束时间
select
teacher_uid
,stu_pid
,created_at
,coalesce(lead(log.created_at,1) over(partition by teacher_uid,stu_pid order by log.created_at),'9999-12-31 99:99:99') as end_time
from 表名 log
HIVE 中将下一条记录的创建时间作为上一条记录的结束时间
select
teacher_uid
,stu_pid
,created_at
,coalesce(lead(log.created_at,1) over(partition by teacher_uid,stu_pid order by log.created_at),'9999-12-31 99:99:99') as end_time
from 表名 log