hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <>
Subject [jira] [Commented] (HIVE-5129) Multiple table insert fails on count(distinct)
Date Fri, 23 Aug 2013 20:11:51 GMT


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:
>             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:

View raw message