[HIVE-7100] Users of hive should be able to specify skipTrash when dropping tables.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.14.0
• Component/s: Query Processor
• Release Note: Add PURGE option to DROP TABLE to skip moving table data to the trash
• Assignee: david serafini
• Reporter: Ravi Prakash
• Created: 20/May/14 20:22
• Updated: 09/Mar/15 09:59
• Resolved: 22/Sep/14 19:32

Description

Users of our clusters are often running up against their quota limits because of Hive tables. When they drop tables, they have to then manually delete the files from HDFS using skipTrash. This is cumbersome and unnecessary. We should enable users to skipTrash directly when dropping tables.
We should also be able to provide this functionality without polluting SQL syntax.

Issue Links

• is related to: HIVE-9083 New metastore API to support to purge partition-data directly in dropPartitions().
• is related to: HIVE-9086 Add language support to PURGE data while dropping partitions.
• is related to: HIVE-9118 Support auto-purge for tables, when dropping tables/partitions.
• is related to: HIVE-7289 revert HIVE-6469
• relates to: HIVE-6469 skipTrash option in hive command line
• links to: Review Board