hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7765) Null pointer error with UNION ALL on partitioned tables using Tez
Date Thu, 02 Jul 2015 02:00:07 GMT

    [ https://issues.apache.org/jira/browse/HIVE-7765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14611324#comment-14611324
] 

Gopal V commented on HIVE-7765:
-------------------------------

Looks like this was fixed somewhere in the 1.x branch.

In the old build, it removes the entire TableScan for some reason. So mostly you need a more
recent build & test again.

> 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.14.0, 0.13.1
>         Environment: Tez 0.4.1, Ubuntu 12.04, Hadoop 2.4.1;
> Hadoop 2.2.6, Tez 0.5.2, Hive 0.14.0, CentOS 6.6
>            Reporter: Chris Dragga
>
> 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.3.4#6332)

Mime
View raw message