[ 
https://issues.apache.org/jira/browse/HIVE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14017134#comment-14017134
 ] 

Jayesh commented on HIVE-7100:
------------------------------

{quote}
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.
{quote}

sorry, my earlier comment about this was bit misleading.
I wanted to say following,

In local metastore mode:
If user set hive.warehouse.data.skipTrash to true from hive client, It also 
updates the configuration on metastore side, ( essentially communicating the 
configuration change)
I believe this is due to metastore running on same JVM as client driver.

In remote metastore mode:
If user set hive.warehouse.data.skipTrash to true from hive client, It does not 
updates the configuration on metastore side,(i.e. it still remains false)
I believe this is due to metastore running on separate JVM, and not 
communicating configuration set by hive client driver which could be right 
behavior by design.

so Yes, The purpose of the patch is to provide a way for client to specify 
whether to skip trash while dropping the table. (by setting configuration 
hive.warehouse.data.skipTrash from hive client driver) . Please also note that 
this configuration can also be set by admin to make required default behavior 
but client ultimately controls the configuration. 

Is this right behavior ?

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