[
https://issues.apache.org/jira/browse/HIVE-14032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15356840#comment-15356840
]
Chinna Rao Lalam commented on HIVE-14032:
-----------------------------------------
INSERT OVERWRITE TABLE with IF NOT EXISTS for a partition is failed
{code}
drop table sample1;
create table sample1(a STRING, b int) partitioned by (PARTITIONID string) ROW
FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '/data/file1.txt' INTO TABLE sample1 partition
(PARTITIONID = "one");
drop table sample2;
create table sample2(a STRING, b int) partitioned by (PARTITIONID string) ROW
FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '/data/file2.txt' INTO TABLE sample2 partition
(PARTITIONID = "one");
INSERT OVERWRITE TABLE sample2 PARTITION (PARTITIONID = 'one') if not exists
select a,b from sample1;
{code}
> INSERT OVERWRITE command failed with case sensitive partition key names
> -----------------------------------------------------------------------
>
> Key: HIVE-14032
> URL: https://issues.apache.org/jira/browse/HIVE-14032
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 2.0.1
> Reporter: Chinna Rao Lalam
> Assignee: Chinna Rao Lalam
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
