[ https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14029927#comment-14029927 ]
Xuefu Zhang commented on HIVE-7100: ----------------------------------- [~jhsenjaliya] This seems just getting more and more complicated. I'd like to hear other's opinion, but I'm open to: 1. Revert HIVE-6469. 2. Expand the drop table syntax to: DROP TABLE table_name [PURGE] skipTrash is a no-go because it's too implementation specific, but PURGE seems more generic and acceptable, which hides the implementation. Let's wait for others to chime in. > Users of hive should be able to specify skipTrash when dropping tables. > ----------------------------------------------------------------------- > > Key: HIVE-7100 > URL: https://issues.apache.org/jira/browse/HIVE-7100 > Project: Hive > Issue Type: Improvement > Affects Versions: 0.13.0 > Reporter: Ravi Prakash > Assignee: Jayesh > Attachments: HIVE-7100.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.2#6252)