Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.0.0
-
None
-
None
Description
While collapsing time-series data, it is common to do LEAD with ignore NULLs to find the previous non-null value for the sequence (when no-change is recorded as a NULL).
Here's a Presto PR, which also implements the same - https://github.com/prestodb/presto/pull/6157
Discovered while porting a RedShift query to LLAP, unsuccessfully
Attachments
Issue Links
- is superceded by
-
HIVE-24869 Implement Respect/Ignore Nulls in lag/lead
- Open