hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-18145) PTF: Support IGNORE NULLS in LEAD/LAG functions
Date Fri, 24 Nov 2017 23:19:00 GMT
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)

Mime
View raw message