[
https://issues.apache.org/jira/browse/HIVE-5323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13781489#comment-13781489
]
Vikram Dixit K commented on HIVE-5323:
--------------------------------------
Hi Tariq,
I am not able to reproduce this issue on trunk or 0.11:
select sum(viewtime) , sum(distinct userid) from hive_npe order by 1 asc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive_npe
#### A masked pattern was here ####
NULL NULL
I ran it as a unit test. It may be something to do with your configurations.
Are you aware of any specific non-default configuration you might be using?
> NPE on executing query with order by 1 asc
> ------------------------------------------
>
> Key: HIVE-5323
> URL: https://issues.apache.org/jira/browse/HIVE-5323
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.11.0
> Environment: MAC OSX
> Hive 0.11
> Reporter: tariq rahiman
>
> 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
--
This message was sent by Atlassian JIRA
(v6.1#6144)
