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
