[jira] [Created] (HIVE-6042) With Dynamic partitioning, All partitions can not be overwrited

["ruish li (JIRA)" <ji...@apache.org>]

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)