[HIVE-14742] Hive on spark throws NPE exception for union all query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0.0
• Component/s: Spark
• Assignee: Unassigned
• Reporter: Aihua Xu
• Created: 13/Sep/16 13:52
• Updated: 13/Sep/16 15:09
• Resolved: 13/Sep/16 15:09

Description

create table foo (fooId string, fooData string) partitioned by (fooPartition string) stored as parquet;
insert into foo partition (fooPartition = '1') values ('1', '1'), ('2', '2');
set hive.execution.engine=spark;
select * from ( 
select 
fooId as myId, 
fooData as myData 
from foo where fooPartition = '1' 
union all 
select 
fooId as myId, 
fooData as myData 
from foo where fooPartition = '3' 
) allData;

Error while compiling statement: FAILED: NullPointerException null