[ https://issues.apache.org/jira/browse/HIVE-3576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484004#comment-13484004 ]
Harsh J commented on HIVE-3576: ------------------------------- This also only happens on tables partitioned by a string type key, not int types, for example: {code} hive> create table str_part_table (a string) partitioned by (dt string); OK Time taken: 0.054 seconds hive> create table int_part_table (a string) partitioned by (dt int); OK Time taken: 0.031 seconds hive> alter table str_part_table drop if exists partition (dt=2007); FAILED: SemanticException [Error 10006]: Partition not found dt = 2007 hive> alter table int_part_table drop if exists partition (dt=2007); OK Time taken: 0.091 seconds hive> alter table str_part_table drop if exists partition (dt='2007'); OK Time taken: 0.06 seconds hive> alter table int_part_table drop if exists partition (dt='2007'); OK Time taken: 0.065 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 > > 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira