Gopal V created HIVE-18145:
------------------------------
Summary: PTF: Support IGNORE NULLS in LEAD/LAG functions
Key: HIVE-18145
URL: https://issues.apache.org/jira/browse/HIVE-18145
Project: Hive
Issue Type: New Feature
Components: PTF-Windowing
Affects Versions: 3.0.0
Reporter: Gopal V
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
