Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-883

Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions

    XMLWordPrintableJSON

Details

    Description

      This issue was brought up in Drill community: (https://issues.apache.org/jira/browse/DRILL-3597)

      For convenience, I copied and pasted the reporter Khurram Faraaz's description here:

      "The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead, lag, first_value, and last_value window functions."

      In Calcite, we should have been able to recognized this option.

      Attachments

        Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-337 Support IGNORE NULLS in window aggregates

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Wish - General wishlist item. DRILL-4397 Add support for NULL treatment in LAG/LEAD functions

          • Major - Major loss of function.
          • Open
          links to

          Web Link GitHub Pull Request #1108

          Activity

            People

              julianhyde Julian Hyde
              seanhychu Sean Hsuan-Yi Chu
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h