-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Closed
Description
Describe the bug
query with lead or lag will cause some be down
To Reproduce
select lead(last_stage_id, 1, null) over ( partition by student_id order by paid_date_time ) as next_stage_id, lead(is_refund_order, 1, null) over ( partition by student_id order by paid_date_time ) as next_is_refund_order, lead(consumption, 1, null) over ( partition by student_id order by paid_date_time ) as next_consumption, lead(paid_date_time, 1, null) over ( partition by student_id order by paid_date_time ) as next_paid_date_time from xxxx
Expected behavior
exec normally
Metadata
Metadata
Assignees
Labels
No labels