hadoop - 如何对存储在 Hive 中的数据执行滞后/超前操作？

Question

是否可以对存储在 Hive 中的数据执行延迟、引导操作？

任何指针将不胜感激!!!

Answer 1

您可以使用 LAG 函数获取之前的时间戳示例如下:

NVL( LAG (currentTimestamp, 1) OVER (PARTITION BY [partinioned columns] ORDER BY currentTimestamp ASC)  , 0 ) AS previousTimestamp;

Same Like LEAD 这里也默认一行NVL( LEAD (currentTimestamp, 1) OVER (PARTITION BY [partinioned columns] ORDER BY currentTimestamp ASC) , 0 ) AS NextTimestamp;