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