[ https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14016217#comment-14016217 ]
Xuefu Zhang commented on HIVE-7100: ----------------------------------- If I understand correctly, the patch provides a metastore client API that can take a skipTrash option when droppring a table/partition. While this doesn't change SQL syntax, it seems creating a backdoor to allow a client to drop table with skipTrash on/off regardless of the admin option, thus defeating the purpose of an admin option. This doesn't seem to be a config driven, but rather a security concern. If your concern was being unable to read the the global hive.warehouse.data.skipTrash option value from client code, this seems to be a bug that can be fixed. But the patch seems to abandon whatever HIVE-6469 provides and provide the functionality thru a client API. Did I miss anything? > 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)