Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18145

PTF: Support IGNORE NULLS in LEAD/LAG functions

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • PTF-Windowing
    • 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

          Activity

            People

              Unassigned Unassigned
              gopalv Gopal Vijayaraghavan
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: