[jira] [Resolved] (HIVE-3576) Regression: ALTER TABLE DROP IF EXISTS PARTITION throws a SemanticException if Partition is not found

["Harsh J (JIRA)" <ji...@apache.org>]

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

Harsh J resolved HIVE-3576.
---------------------------

       Resolution: Cannot Reproduce
    Fix Version/s: 0.11.0

Unable to reproduce in 0.11+. Resolving.

{code}
hive> create table str_part_table (a string) partitioned by (dt string);
OK
Time taken: 16.108 seconds
hive> create table int_part_table (a string) partitioned by (dt int);
OK
Time taken: 0.705 seconds
hive> alter table str_part_table drop if exists partition (dt=2007);
OK
Time taken: 1.38 seconds
hive> alter table int_part_table drop if exists partition (dt=2007);
OK
Time taken: 3.494 seconds
hive> alter table str_part_table drop if exists partition (dt='2007');
OK
Time taken: 0.091 seconds
hive> alter table int_part_table drop if exists partition (dt='2007');
OK
Time taken: 0.101 seconds
{code}

> Regression: ALTER TABLE DROP IF EXISTS PARTITION throws a SemanticException if Partition is not found
> -----------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-3576
>                 URL: https://issues.apache.org/jira/browse/HIVE-3576
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore, Query Processor
>    Affects Versions: 0.9.0
>            Reporter: Harsh J
>             Fix For: 0.11.0
>
>
> Doing a simple "{{ALTER TABLE testtable DROP IF EXISTS PARTITION(dt=NONEXISTENTPARTITION)}}" fails with a SemanticException of the 10006 kind (INVALID_PARTITION).
> This does not respect the {{hive.exec.drop.ignorenonexistent}} condition either, since there are no if-check-wraps around this area, when fetching partitions from the store.



--
This message was sent by Atlassian JIRA
(v6.2#6252)