Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3210

last_value()/first_value() support for IGNORE NULLS

    XMLWordPrintableJSON

    Details

      Description

      Add support for the first_value() and last_value() analytic functions to ignore nulls, e.g. returning the first/last non-null value in the window.

      For example,

      LAST_VALUE ( expression [ IGNORE NULLS ] ) OVER ( ... )
      

        Attachments

          Activity

            People

            • Assignee:
              twmarshall Thomas Tauber-Marshall
              Reporter:
              mjacobs Matthew Jacobs
            • Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: