[ 
https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jayesh updated HIVE-7100:
-------------------------

    Attachment: HIVE-7100.patch

Hi [~xuefuz],

we realized that hive.warehouse.data.skipTrash as admin property creates some 
confusions over the behavior of hive in dropping table.

since there ll be no way for client to figure out what 
hive.warehouse.data.skipTrash configuration is set to. ( in remote metastore 
setup with HIVE-6469 patch)
Ex:  if hive.warehouse.data.skipTrash is set to true on metastore (admin side)
"set hive.warehouse.data.skipTrash" still returns false on client side. which 
is bit confusing.

I have uploaded the patch that provides client to specify skipTrash option on 
ad-hoc basis, which also does not dilute the SQL syntax and it is configuration 
driven as you suggested.

ps: To provide this way of setting skipTrash by client, I had to remove it 
solely based on admin configuration.

Please let us know your comments.

Thanks
Jay

> 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