[HIVE-5323] NPE on executing query with order by 1 asc

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 0.11.0
• Fix Version/s: 0.11.1
• Component/s: SQL

Environment

MAC OSX
Hive 0.11

• Assignee: Unassigned
• Reporter: tariq rahiman
• Created: 19/Sep/13 22:48
• Updated: 10/Oct/13 15:10
• Resolved: 10/Oct/13 15:10

Description

I created a table with the below DDL in Hive 0.11 and used order by 1 asc in a SQL query and got NPE. Details are below:

CREATE TABLE hive_npe(viewTime INT, userid BIGINT,
page_url STRING, referrer_url STRING)
COMMENT 'NPE for Order by 1 ASC'
STORED AS SEQUENCEFILE
;

select sum(viewtime) , sum(distinct userid) from hive_npe order by 1 asc
;

I get the below error message
Query returned non-zero code: 40000, cause: FAILED: NullPointerException null