[HIVE-23706] Fix nulls first sorting behavior

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Parser
• Labels: pull-request-available
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 17/Jun/20 03:34
• Updated: 27/Feb/24 22:23
• Resolved: 22/Jun/20 10:53

Description

INSERT INTO t(a) VALUES (1), (null), (3), (2), (2), (2);

select a from t order by a desc;

instead of

3, 2, 2, 2, 1, null

should return

null, 3, 2 ,2 ,2, 1

Issue Links

• is related to: HIVE-22321 Setting default nulls last does not take effect when order direction is specified
• links to: GitHub Pull Request #1131