hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ruish li (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-6042) With Dynamic partitioning, All partitions can not be overwrited
Date Fri, 17 Jan 2014 03:04:23 GMT

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

ruish li updated HIVE-6042:
---------------------------

    Attachment: HIVE-6042.patch

this patch can fix HIVE-6042.

> 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
>         Attachments: HIVE-6042.patch
>
>
> 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.5#6160)

Mime
View raw message