[ 
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)

Reply via email to