N Campbell created HIVE-9535:
--------------------------------
Summary: add support for NULL ORDER specification in windowed
aggregates
Key: HIVE-9535
URL: https://issues.apache.org/jira/browse/HIVE-9535
Project: Hive
Issue Type: Improvement
Components: SQL
Reporter: N Campbell
Cannot explicitly state how nulls order in windowed aggregates.
select rnum, c1, c2, c3, rank() over(partition by c1,c2 order by c3 desc nulls
last), rank() over(partition by c1,c2 order by c3 desc nulls first) from tolap
while faking with an expression may simulate the intent supporting the ISO
standard would be preferred.
select rnum, c1, c2, c3, rank() over(partition by c1,c2 order by c3 desc nulls
last), rank() over(partition by c1,c2 order by c3 desc nulls first) from tolap
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
