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