[jira] [Created] (HIVE-7765) Null pointer error with UNION ALL on partitioned tables using Tez

["Chris Dragga (JIRA)" <ji...@apache.org>]

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)