[ 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)