[HIVE-308] UNION ALL should create different destination directories for different operands

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.3.0
• Fix Version/s: 0.3.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed

Release Note

HIVE-308. UNION ALL: FileSinkOperator now adds files in case the target exists. (zshao)

• Assignee: Zheng Shao
• Reporter: Zheng Shao
• Created: 26/Feb/09 06:23
• Updated: 17/Dec/11 00:08
• Resolved: 09/Mar/09 09:41

Description

The following query hangs:

 
select * from (select 1 from zshao_lazy union all select 2 from zshao_lazy) a;

The following query produce wrong results: (one map-reduce job overwrite/cannot overwrite the result of the other)

 
select * from (select 1 as id from zshao_lazy cluster by id union all select 2 as id from zshao_meta) a;

The reason of both is that the destination directory of the file sink operator conflicts with each other.