[
https://issues.apache.org/jira/browse/HIVE-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2812:
------------------------------
Attachment: HIVE-2812.D1821.2.patch
kevinwilfong updated the revision "HIVE-2812 [jira] Hive multi group by single
reducer optimization fails when aggregation with no keys followed by query with
no aggregations".
Reviewers: JIRA, njain
Updated.
REVISION DETAIL
https://reviews.facebook.net/D1821
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/test/queries/clientpositive/groupby_multi_single_reducer3.q
ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out
To: JIRA, njain, kevinwilfong
> 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.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