[jira] [Commented] (HIVE-11313) dynamic partition with null key from union select will fail

["Jay Lee (JIRA)" <ji...@apache.org>]

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

Jay Lee commented on HIVE-11313:
--------------------------------

Just test with 1.2.1, the issue seems fixed.

> dynamic partition with null key from union select will fail
> -----------------------------------------------------------
>
>                 Key: HIVE-11313
>                 URL: https://issues.apache.org/jira/browse/HIVE-11313
>             Project: Hive
>          Issue Type: Bug
>          Components: Tez
>    Affects Versions: 0.14.0
>         Environment: hive 0.14
> hadoop 2.6.0
> tez 0.6.1
>            Reporter: Jay Lee
>
> Using union with dynamic partition insert will fail if there is a null partition name.
> hive> select * from testDynamicTezPartitionWithUnionSource;
> OK
> jay	18	20150101	NULL	NULL
> jack	20	20150101	NULL	NULL
> linda	25	20150102	BJ	NULL
> nancy	33	20150103	BJ	NC
> hive> set hive.execution.engine=tez;
> hive> set hive.exec.dynamic.partition=true;
> hive> insert into table testDynamicTezPartitionWithUnion partition(birthday=20150101, city, school) select name, age, city, school from testDynamicTezPartitionWithUnionSource where name="jay" union all select name, age, city, school from testDynamicTezPartitionWithUnionSource where name="jack";
> ...
> Loading data to table test.testdynamictezpartitionwithunion partition (birthday=20150101, city=null, school=null)
> Failed with exception MetaException(message:Invalid partition key & values; keys [birthday, city, school, ], values [20150101, NULL, ])
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
> When change engine to mr, every thing just works fine.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)