You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "ruish li (JIRA)" <ji...@apache.org> on 2013/12/17 13:15:08 UTC
[jira] [Updated] (HIVE-6042) With Dynamic partitioning, All
partitions can not be overwrited
[ https://issues.apache.org/jira/browse/HIVE-6042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ruish li updated HIVE-6042:
---------------------------
Description:
step1: create table
drop table if exists t;
create table t(a int)PARTITIONED BY (city_ string);
step2: insert data (table dual has only one value: ‘x’)
set hive.exec.dynamic.partition.mode=nonstrict;
insert into table t partition(city_) select 1,'beijing' from dual;
insert into table t partition(city_) select 2,'shanghai' from dual;
hive (default)> select * from t;
1 beijing
2 shanghai
step3: overwrite table
insert overwrite table t partition(city_) select 3,'beijing' from dual;
hive (default)> select * from t;
1 beijing
2 shanghai
here we can see the partition city_=shanghai exist yet,But we hope that this partition is covered With Dynamic partitioning.
was:
step1: create table
drop table if exists t;
create table t(a int)PARTITIONED BY (city_ string);
step2: insert data (table dual has only one value: ‘x’)
set hive.exec.dynamic.partition.mode=nonstrict;
insert into table t partition(city_) select 1,'beijing' from dual;
insert into table t partition(city_) select 2,'shanghai' from dual;
hive (default)> select * from t;
1 beijing
2 shanghai
step3: overwrite table ,we can show that
insert overwrite table t partition(city_) select 3,'beijing' from dual;
hive (default)> select * from t;
1 beijing
2 shanghai
here we can see the partition city_=shanghai exist yet,But we hope that this partition is covered With Dynamic partitioning.
> With Dynamic partitioning, All partitions can not be overwrited
> ---------------------------------------------------------------
>
> Key: HIVE-6042
> URL: https://issues.apache.org/jira/browse/HIVE-6042
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Affects Versions: 0.12.0
> Environment: OS: Red Hat Enterprise Linux Server release 6.2
> HDFS: CDH-4.2.1
> MAPRED: CDH-4.2.1-mr1
> Reporter: ruish li
> Priority: Minor
>
> step1: create table
> drop table if exists t;
> create table t(a int)PARTITIONED BY (city_ string);
> step2: insert data (table dual has only one value: ‘x’)
> set hive.exec.dynamic.partition.mode=nonstrict;
> insert into table t partition(city_) select 1,'beijing' from dual;
> insert into table t partition(city_) select 2,'shanghai' from dual;
> hive (default)> select * from t;
> 1 beijing
> 2 shanghai
> step3: overwrite table
> insert overwrite table t partition(city_) select 3,'beijing' from dual;
> hive (default)> select * from t;
> 1 beijing
> 2 shanghai
> here we can see the partition city_=shanghai exist yet,But we hope that this partition is covered With Dynamic partitioning.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)