[
https://issues.apache.org/jira/browse/HIVE-23706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17138426#comment-17138426
]
Jesus Camacho Rodriguez commented on HIVE-23706:
------------------------------------------------
+1
> 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: 50m
> 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)
