[
https://issues.apache.org/jira/browse/HIVE-23706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa updated HIVE-23706:
----------------------------------
Description:
{code}
INSERT INTO t(a) VALUES (1), (null), (3), (2), (2), (2);
select a from t order by a desc;
{code}
instead of
{code}
3, 2, 2, 2, 1, null
{code}
should return
{code}
null, 3, 2 ,2 ,2, 1
{code}
was:
{code}
INSERT INTO t(a) VALUES (1), (null), (3), (2), (2), (2);
select a from t order by a desc;
{code}
instead of {code}
null, 3, 2 ,2 ,2, 1
{code}
should return
{code}
3, 2, 2, 2, 1, null
{code}
> Fix nulls first sorting behavior
> --------------------------------
>
> Key: HIVE-23706
> URL: https://issues.apache.org/jira/browse/HIVE-23706
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> {code}
> INSERT INTO t(a) VALUES (1), (null), (3), (2), (2), (2);
> select a from t order by a desc;
> {code}
> instead of
> {code}
> 3, 2, 2, 2, 1, null
> {code}
> should return
> {code}
> null, 3, 2 ,2 ,2, 1
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
