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

Xuefu Zhang commented on HIVE-6469:
-----------------------------------

Here is the recap of what I have said above.

Putting data for a dropped data in the .trash folder is a safety feature. It's 
understandable that in dev env user might want to turn this off. Thus, I 
suggest we put a server configuration for that. This safety feature is a server 
behavior, and being applied to tables does NOT mean that we need to provide an 
option at table level, which appears to me an over-kill. 

If the feature is desirable for production and optional for development, I 
don't understand why a user would want to turn this feature on  in an 
environment while wanting to skip this for some tables. If instead there is 
such a rare need for this, then manual deleting the data after dropping a table 
seems more reasonable to me. Thus, I'm not convinced that such a requirement is 
strong enough to have such a skiptrash syntax in drop table command.

> skipTrash option in hive command line
> -------------------------------------
>
>                 Key: HIVE-6469
>                 URL: https://issues.apache.org/jira/browse/HIVE-6469
>             Project: Hive
>          Issue Type: New Feature
>          Components: CLI
>    Affects Versions: 0.12.0
>            Reporter: Jayesh
>             Fix For: 0.12.1
>
>         Attachments: HIVE-6469.patch
>
>
> hive drop table command deletes the data from HDFS warehouse and puts it into 
> Trash.
> Currently there is no way to provide flag to tell warehouse to skip trash 
> while deleting table data.
> This ticket is to add skipTrash feature in hive command-line, that looks as 
> following. 
> hive -e "drop table skipTrash testTable"
> This would be good feature to add, so that user can specify when not to put 
> data into trash directory and thus not to fill hdfs space instead of relying 
> on trash interval and policy configuration to take care of disk filling issue.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to