Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
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
- relates to
-
HIVE-24908 Adding Respect/Ignore nulls as a UDAF parameter is ambiguous
- Closed
-
HIVE-24868 Support specifying Respect/Ignore Nulls in function parameter list
- Closed
- links to