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