Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 17 Dec 2013 12:13:06 +0000 (UTC)
From: "ruish li (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12685159.1387282360333.49597.1387282386913@arcas>
In-Reply-To: <JIRA.12685159.1387282360333@arcas>
References: <JIRA.12685159.1387282360333@arcas>
Subject: [jira] [Created] (HIVE-6042) With Dynamic partitioning, All
 partitions can not be overwrited
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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=20
             drop table if exists t;
             create table t(a int)PARTITIONED BY (city_ string);
step2: insert data (table dual has only one value=EF=BC=9A =E2=80=98x=E2=80=
=99)
   set hive.exec.dynamic.partition.mode=3Dnonstrict;=20
   insert into table t partition(city_) select  1,'beijing'  from dual;=20
   insert into table t partition(city_) select  2,'shanghai' from dual;

  hive (default)>  select * from t;
1=09beijing
2=09shanghai

step3: overwrite table =EF=BC=8Cwe can show that
 insert overwrite table t partition(city_) select 3,'beijing' from dual;
 hive (default)>  select * from t;
1=09beijing
2=09shanghai

here we can see the partition city_=3Dshanghai  exist yet,But we hope that =
this partition is covered With Dynamic partitioning.


--
This message was sent by Atlassian JIRA
(v6.1.4#6159)