hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-11313) dynamic partition with null key from union select will fail
Date Wed, 22 Jul 2015 07:46:04 GMT

     [ https://issues.apache.org/jira/browse/HIVE-11313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ashutosh Chauhan resolved HIVE-11313.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.2.1

> 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
>             Fix For: 1.2.1
>
>
> 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)

Mime
View raw message