[HIVE-5083] Group by ignored when group by column is a partition column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.11.0
• Component/s: SQL

Environment

linux

• Assignee: Unassigned
• Reporter: Micah Gutman
• Created: 14/Aug/13 00:26
• Updated: 14/Aug/13 17:50
• Resolved: 14/Aug/13 17:50

Description

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.