[
https://issues.apache.org/jira/browse/HIVE-5129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13748951#comment-13748951
]
Harish Butani commented on HIVE-5129:
-------------------------------------
Looks good. Can you add a test that has different distincts, which will cause
multiple Jobs to be genned.
We should look at combining such clauses in the future.
[~navis] we think your e.g. is a separate issue. What we observe is that the
Key OI setup in your e.g. has only 1 field which is the Union Filed for key and
value columns.
For some reason the key column from the group by is removed from the Key OI. So
what happens is each spray instance of the original row is being output.
So can we look at this in a separate jira.
> Multiple table insert fails on count(distinct)
> ----------------------------------------------
>
> Key: HIVE-5129
> URL: https://issues.apache.org/jira/browse/HIVE-5129
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.11.0
> Reporter: Vikram Dixit K
> Assignee: Vikram Dixit K
> Attachments: aggrTestMultiInsertData1.txt,
> aggrTestMultiInsertData.txt, aggrTestMultiInsert.q, HIVE-5129.1.patch.txt,
> HIVE-5129.2.WIP.patch.txt, HIVE-5129.3.patch.txt
>
>
> Hive fails with a class cast exception on queries of the form:
> {noformat}
> from studenttab10k
> insert overwrite table multi_insert_2_1
> select name, avg(age) as avgage
> group by name
> insert overwrite table multi_insert_2_2
> select name, age, sum(gpa) as sumgpa
> group by name, age
> insert overwrite table multi_insert_2_3
> select name, count(distinct age) as distage
> group by name;
> {noformat}
--
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
