Jeremy Hanna created HIVE-3732: ---------------------------------- Summary: Multiple aggregates in query fail the job Key: HIVE-3732 URL: https://issues.apache.org/jira/browse/HIVE-3732 Project: Hive Issue Type: Bug Affects Versions: 0.9.0 Reporter: Jeremy Hanna Attachments: hive_output.txt
To reproduce: Create the hive table: {code}CREATE EXTERNAL TABLE Birthdays (id int, name string, birthday timestamp) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ';{code} Insert the data (from file): {quote} 1 A 2012-10-15 08:01:00 2 B 2012-10-15 08:02:00 3 C 2012-10-15 08:03:00 4 D 2012-10-15 08:04:00 5 E 2012-10-15 08:05:00 6 F 2012-10-15 08:06:00 7 G 2012-10-15 08:07:00 8 H 2012-10-15 08:08:00 9 I 2012-10-15 08:09:00 {quote} The first 3 queries work, the last query errors out: {code} SELECT * FROM Birthdays; SELECT MIN(Birthday) AS MinBirthday FROM Birthdays; SELECT MAX(Birthday) AS MaxBirthday FROM Birthdays; SELECT MIN(Birthday) AS MinBirthday, MAX(Birthday) AS MaxBirthday FROM Birthdays; {code} -- 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