Krisztian Kasa created HIVE-24865:
-------------------------------------
Summary: Implement Respect/Ignore Nulls in first/last_value
Key: HIVE-24865
URL: https://issues.apache.org/jira/browse/HIVE-24865
Project: Hive
Issue Type: New Feature
Components: Parser, UDF
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
{code:java}
<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
{code}
Example:
{code:java}
select last_value(b) ignore nulls over(partition by a order by b) from t1;
{code}
Existing non-standard implementation:
{code:java}
select last_value(b, true) over(partition by a order by b) from t1;
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
