ruish li created HIVE-6042:
------------------------------
Summary: 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 ，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.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
