[HIVE-1856] Implement DROP TABLE/VIEW ... IF EXISTS

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: Metastore, Query Processor
• Hadoop Flags: Reviewed
• Release Note: Backwards-compatible DROP behavior is controlled via new configuration parameter hive.exec.drop.ignorenonexistent
• Assignee: Marcel Kinard
• Reporter: Marcel Kinard
• Created: 20/Dec/10 22:19
• Updated: 17/Feb/15 18:04
• Resolved: 21/Dec/10 23:19

Description

This issue combines issues HIVE-1550/1165/1542/1551:

• augment DROP TABLE/VIEW with IF EXISTS
• signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
• introduce a flag in the configuration that allows you to turn off the new behavior

Issue Links

• blocks: HIVE-1858 Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS
• incorporates: HIVE-1542 DROP TABLE <tablename> should raise an error when <tablename> does not exist
• incorporates: HIVE-1551 DROP VIEW should raise an error if the view does not exist
• incorporates: HIVE-1550 Implement DROP VIEW IF EXISTS
• incorporates: HIVE-1165 Support `DROP TABLE XXX IF EXISTS`
• is duplicated by: HIVE-1550 Implement DROP VIEW IF EXISTS
• is related to: HIVE-6754 Inconsistent default for hive.exec.drop.ignorenonexistent