[ https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14142002#comment-14142002 ]
Xuefu Zhang commented on HIVE-7100: ----------------------------------- {quote} What should the behavior of drop table be for an immutable table? With and without the purge option? {quote} There should be no difference in dropping table behavior regarding immutable tables, accordingly HIVE-6406. Being "immutable" doesn't prevents "droping". It only blocks "updating" when content exisits. Purge is an option for dropping, Thus, there shouldn't be any relationship between "immutable" and "purge". > 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: david serafini > Attachments: HIVE-7100.1.patch, HIVE-7100.10.patch, > HIVE-7100.2.patch, HIVE-7100.3.patch, HIVE-7100.4.patch, HIVE-7100.5.patch, > HIVE-7100.8.patch, HIVE-7100.9.patch, 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.3.4#6332)