[HIVE-747] void type (null column) cannot be UNIONed with other type

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Ning Zhang
• Reporter: Ning Zhang
• Created: 11/Aug/09 16:48
• Updated: 14/May/13 08:07

Description

hive> select * from (select NULL from zshao_tt union all select 1 from zshao_tt)x;
select * from (select NULL from zshao_tt union all select 1 from zshao_tt)x;
FAILED: Error in semantic analysis: Schema of both sides of union should match: Column _c0 is of type void on first table and type int on second table

Issue Links

• is duplicated by: HIVE-2901 Hive union with NULL constant and string in same column returns all null