[ https://issues.apache.org/jira/browse/HIVE-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Wilfong updated HIVE-2812: -------------------------------- Status: Patch Available (was: Open) > Hive multi group by single reducer optimization fails when aggregation with > no keys followed by query with no aggregations > -------------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-2812 > URL: https://issues.apache.org/jira/browse/HIVE-2812 > Project: Hive > Issue Type: Bug > Reporter: Kevin Wilfong > Assignee: Kevin Wilfong > Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2812.D1821.1.patch, > HIVE-2812.2.patch.txt, HIVE-2812.D1821.2.patch > > > In multi insert queries where one subquery involves an aggregation with no > distinct or group by keys and is followed by a query without any > aggregations, like the following, Hive will attempt to add a group by > operator for the query without aggregations, causing semantic analysis to > fail. > FROM src > INSERT OVERWRITE TABLE table1 SELECT count(*) > INSERT OVERWRITE TABLE table2 SELECT key; -- 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