N Campbell created HIVE-15547: --------------------------------- Summary: nulls not sorted last on cursor specification Key: HIVE-15547 URL: https://issues.apache.org/jira/browse/HIVE-15547 Project: Hive Issue Type: Bug Components: SQL Affects Versions: 2.1.0 Reporter: N Campbell
Query that attempts to sort nulls last produces an incorrect result set. (1) first column contains all null values which is wrong (2) second column has not sorted the only null value as the last row Hive server version: 2.1.0.2.5.3.0-37 Query: SELECT `tint`.`rnum`, `tint`.`cint` FROM `tint` ORDER BY `tint`.`rnum` ASC NULLS LAST Results: tint.rnum tint.cint <null> <null> <null> -1 <null> 0 <null> 1 <null> 10 Source data rnum cint 0 <null> 1 -1 2 0 3 1 4 10 Table create table if not exists TINT ( RNUM int , CINT int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS textfile ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)