[
https://issues.apache.org/jira/browse/HIVE-3852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-3852:
------------------------------
Attachment: HIVE-3852.D7737.1.patch
navis requested code review of "HIVE-3852 [jira] Multi-groupby optimization
fails when same distinct column is used twice or more".
Reviewers: JIRA
DPAL-1951 Multi-groupby optimization fails when same distinct column is used
twice or more
FROM INPUT
INSERT OVERWRITE TABLE dest1
SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), count(distinct
substr(INPUT.value,5)) GROUP BY INPUT.key
INSERT OVERWRITE TABLE dest2
SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), avg(distinct
substr(INPUT.value,5)) GROUP BY INPUT.key;
fails with exception FAILED: IndexOutOfBoundsException Index: 0,Size: 0
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D7737
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/test/queries/clientpositive/groupby10.q
ql/src/test/results/clientpositive/groupby10.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/18621/
To: JIRA, navis
> Multi-groupby optimization fails when same distinct column is used twice or
> more
> --------------------------------------------------------------------------------
>
> Key: HIVE-3852
> URL: https://issues.apache.org/jira/browse/HIVE-3852
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Priority: Trivial
> Attachments: HIVE-3852.D7737.1.patch
>
>
> {code}
> FROM INPUT
> INSERT OVERWRITE TABLE dest1
> SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), count(distinct
> substr(INPUT.value,5)) GROUP BY INPUT.key
> INSERT OVERWRITE TABLE dest2
> SELECT INPUT.key, sum(distinct substr(INPUT.value,5)), avg(distinct
> substr(INPUT.value,5)) GROUP BY INPUT.key;
> {code}
> fails with exception FAILED: IndexOutOfBoundsException Index: 0,Size: 0
--
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
