hive-LEAD() over() 取字段的下一个值

　lead(status,1,null)  over(partition by shop oreder by month)  as next_status   

--lead()参数1：目标字段;参数2：步长（是取下1个还是下2个）;参数3：取不到给NULL

 SELECT
        a.related_org_code,
        a.camera_id,
        a.event_time,
        a.status,
        LEAD(status) OVER (PARTITION BY related_org_code, camera_id ORDER BY event_time) AS next_status,
        LEAD(event_time) OVER (PARTITION BY related_org_code, camera_id ORDER BY event_time) AS next_event_time
    FROM table_a