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

Implement Respect/Ignore Nulls in first/last_value

    XMLWordPrintableJSON

Details

    Description

      <null treatment> ::=
      RESPECT NULLS | IGNORE NULLS
      
      <first or last value function> ::=
      <first or last value> <left paren> <value expression> <right paren> [ <null treatment>
      ]
      
      <first or last value> ::=
      FIRST_VALUE | LAST_VALUE
      

      Example:

      select last_value(b) ignore nulls over(partition by a order by b) from t1;
      

      Existing non-standard implementation:

      select last_value(b, true) over(partition by a order by b) from t1;
      

      Attachments

        Issue Links

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              1 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 - 1h 10m
                  1h 10m