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

Xuefu Zhang commented on HIVE-7100:
-----------------------------------

{quote}
What should the behavior of drop table be for an immutable table? With and 
without the purge option?
{quote}
There should be no difference in dropping table behavior regarding immutable 
tables, accordingly HIVE-6406. Being "immutable" doesn't prevents "droping". It 
only blocks "updating" when content exisits.

Purge is an option for dropping, Thus, there shouldn't be any relationship 
between "immutable" and "purge".


> 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: david serafini
>         Attachments: HIVE-7100.1.patch, HIVE-7100.10.patch, 
> HIVE-7100.2.patch, HIVE-7100.3.patch, HIVE-7100.4.patch, HIVE-7100.5.patch, 
> HIVE-7100.8.patch, HIVE-7100.9.patch, 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.3.4#6332)

Reply via email to