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

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

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