[HIVE-22321] Setting default nulls last does not take effect when order direction is specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Parser
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 10/Oct/19 12:17
• Updated: 27/Feb/24 22:23
• Resolved: 28/Oct/19 16:12

Description

SET hive.default.nulls.last=true;
SELECT * FROM t_test ORDER BY col1 ASC;

POSTHOOK: query: SELECT * FROM t_test ORDER BY col1 ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_test
#### A masked pattern was here ####
NULL
NULL
NULL
NULL
3
5
5

https://github.com/apache/hive/blob/cb83da943c8919e2ab3751244de5c2879c8fda1d/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g#L2510

 

cc. jcamachorodriguez

Issue Links

• relates to: HIVE-23706 Fix nulls first sorting behavior
• links to: Review Board