[ https://issues.apache.org/jira/browse/HIVE-5083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Micah Gutman resolved HIVE-5083. -------------------------------- Resolution: Not A Problem The reported problem is just a symptom of a different known bug. > 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