[jira] [Commented] (HIVE-5323) NPE on executing query with order by 1 asc
[ https://issues.apache.org/jira/browse/HIVE-5323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13782407#comment-13782407 ] Vikram Dixit K commented on HIVE-5323: -- It would be great if you could post the error/stack trace as well. 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: 4, cause: FAILED: NullPointerException null -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5323) NPE on executing query with order by 1 asc
[ https://issues.apache.org/jira/browse/HIVE-5323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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: 4, cause: FAILED: NullPointerException null -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-5323) NPE on executing query with order by 1 asc
[
https://issues.apache.org/jira/browse/HIVE-5323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13781490#comment-13781490
]
Vikram Dixit K commented on HIVE-5323:
--
{noformat}
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
{noformat}
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: 4, cause: FAILED: NullPointerException null
--
This message was sent by Atlassian JIRA
(v6.1#6144)
