hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Micah Gutman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5083) Group by ignored when group by column is a partition column
Date Wed, 14 Aug 2013 00:27:47 GMT
Micah Gutman created HIVE-5083:
----------------------------------

             Summary: Group by ignored when group by column is a partition column
                 Key: HIVE-5083
                 URL: https://issues.apache.org/jira/browse/HIVE-5083
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.11.0
         Environment: linux
            Reporter: Micah Gutman


I have an external table X with partition date (a string YYYYMMDD):

select X.date, count(*) from X group by X.date

Rather then get a count breakdown by date, I get a single row returned with the count for
the entire table. The "date" column returned in my single row appears to be the last partition
in the table.

Note results appear as expected if I select an arbitrary "real" column from my table:

select X.foo, count(*) from X group by X.foo 

correctly gives me a single row per value of X.foo.

Also, my query works fine when I use the date column in the "where" clause, so the partition
does seem to be working.

select X.date, count(*) from X where X.date = "20130101"

correctly gives me a single row with the count for the date 20130101.




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message