[HIVE-3544] union involving double column with a map join subquery will fail or give wrong results

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Kevin Wilfong
• Reporter: Kevin Wilfong
• Created: 07/Oct/12 08:23
• Updated: 02/May/13 02:29
• Resolved: 19/Oct/12 20:06

Description

The following query fails:
select * from (select cast(a.key as bigint) as key from src a join src b on a.key = b.key union all select cast(key as double) as key from src)a

The following query gives wrong results:
select * from (select cast(a.key as bigint) as key, cast(b.key as double) as value from src a join src b on a.key = b.key union all select cast(key as double) as key, cast(key as string) as value from src)a

But the following query runs fine:
select * from (select cast(a.key as bigint) as key from src a union all select cast(key as double) as key from src)a

Issue Links

• is depended upon by: HIVE-3276 optimize union sub-queries