You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2017/11/24 23:19:00 UTC

[jira] [Created] (HIVE-18145) PTF: Support IGNORE NULLS in LEAD/LAG functions

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)