[
https://issues.apache.org/jira/browse/HIVE-9535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Pivovarov updated HIVE-9535:
--------------------------------------
Description:
Cannot explicitly state how nulls order in windowed aggregates.
{code}
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;
{code}
while faking with an expression may simulate the intent supporting the ISO
standard would be preferred.
{code}
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;
{code}
was:
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
> 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.
> {code}
> 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;
> {code}
> while faking with an expression may simulate the intent supporting the ISO
> standard would be preferred.
> {code}
> 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;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
