[HIVE-5129] Multiple table insert fails on count(distinct)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: Query Processor
• Tags: HIVE-4692
• Assignee: Vikram Dixit K
• Reporter: Vikram Dixit K
• Created: 21/Aug/13 02:28
• Updated: 16/Oct/13 01:23
• Resolved: 03/Sep/13 17:34

Description

Hive fails with a class cast exception on queries of the form:

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;

Issue Links

• is related to: HIVE-5560 Hive produces incorrect results on multi-distinct query