[
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)
