hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tariq rahiman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-5323) NPE on executing query with order by 1 asc
Date Thu, 10 Oct 2013 15:11:42 GMT

     [ https://issues.apache.org/jira/browse/HIVE-5323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

tariq rahiman resolved HIVE-5323.
---------------------------------

       Resolution: Invalid
    Fix Version/s: 0.11.1

I was using a version of hive in which this was not fixed. I got the latest version and see
that it is fixed now.

We are working on a UI for hive administrators and I think i connected using a different driver.
You can see it here: http://www.aquafold.com/dbspecific/apache_hive_client.html

Apologize for the late response

> 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
>             Fix For: 0.11.1
>
>
> 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)

Mime
View raw message