Chris Dragga created HIVE-7765:
----------------------------------
Summary: Null pointer error with UNION ALL on partitioned tables
using Tez
Key: HIVE-7765
URL: https://issues.apache.org/jira/browse/HIVE-7765
Project: Hive
Issue Type: Bug
Affects Versions: 0.13.1
Environment: Tez 0.4.1, Ubuntu 12.04, Hadoop 2.4.1.
Reporter: Chris Dragga
Priority: Minor
When executing a UNION ALL query in Tez over partitioned tables where at least
one table is empty, Hive fails to execute the query, returning the message
"FAILED: NullPointerException null". No stack trace accompanies this message.
Removing partitioning solves this problem, as does switching to MapReduce as
the execution engine.
This can be reproduced using a variant of the example tables from the "Getting
Started" documentation on the Hive wiki. To create the schema, use
CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
CREATE TABLE empty_invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
Then, load invites with data (e.g., using the instructions
[here|https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-DMLOperations])
and execute the following:
SELECT * FROM invites
UNION ALL
SELECT * FROM empty_invites;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
