[jira] [Commented] (HIVE-9118) Support auto-purge for tables, when dropping tables/partitions.

2015-03-09 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-9118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14352734#comment-14352734
 ] 

Lefty Leverenz commented on HIVE-9118:
--

Doc note:  This is documented in the TBLPROPERTIES bullet item after the CREATE 
TABLE syntax in the DDL doc (please review).

* [LanguageManual DDL -- Create Table | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable]

 Support auto-purge for tables, when dropping tables/partitions.
 ---

 Key: HIVE-9118
 URL: https://issues.apache.org/jira/browse/HIVE-9118
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 1.0.0, 1.1
Reporter: Mithun Radhakrishnan
Assignee: Mithun Radhakrishnan
 Fix For: 1.2.0

 Attachments: HIVE-9118.1.patch, HIVE-9118.2.patch, HIVE-9118.3.patch


 HIVE-7100 introduced a way to skip the trash directory, when deleting 
 table-data, while dropping tables.
 In HIVE-9083/HIVE-9086, I extended this to work when partitions are dropped.
 Here, I propose a table-parameter ({{auto.purge}}) to set up tables to 
 skip-trash when table/partition data is deleted, without needing to say 
 PURGE on the Hive CLI. Apropos, on {{dropTable()}} and {{dropPartition()}}, 
 table data is deleted directly (and not moved to trash) if the following hold 
 true:
 # The table is MANAGED.
 # The {{deleteData}} parameter to the {{HMSC.drop*()}} methods is true.
 # Either PURGE is explicitly specified on the command-line (or rather, 
 {{ifPurge}} is set in the environment context, OR
 # TBLPROPERTIES contains {{auto.purge=true}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (HIVE-9118) Support auto-purge for tables, when dropping tables/partitions.

2015-03-03 Thread Mithun Radhakrishnan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-9118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14345436#comment-14345436
 ] 

Mithun Radhakrishnan commented on HIVE-9118:


Thanks for the review and commit, sir. Much appreciated.

Could I please bother you for advice on HIVE-9086? We're having trouble 
reaching consensus on what the grammar should look like, for {{DROP PARTITIONS 
... PURGE}}.

 Support auto-purge for tables, when dropping tables/partitions.
 ---

 Key: HIVE-9118
 URL: https://issues.apache.org/jira/browse/HIVE-9118
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 1.0.0, 1.1
Reporter: Mithun Radhakrishnan
Assignee: Mithun Radhakrishnan
 Fix For: 1.2.0

 Attachments: HIVE-9118.1.patch, HIVE-9118.2.patch, HIVE-9118.3.patch


 HIVE-7100 introduced a way to skip the trash directory, when deleting 
 table-data, while dropping tables.
 In HIVE-9083/HIVE-9086, I extended this to work when partitions are dropped.
 Here, I propose a table-parameter ({{auto.purge}}) to set up tables to 
 skip-trash when table/partition data is deleted, without needing to say 
 PURGE on the Hive CLI. Apropos, on {{dropTable()}} and {{dropPartition()}}, 
 table data is deleted directly (and not moved to trash) if the following hold 
 true:
 # The table is MANAGED.
 # The {{deleteData}} parameter to the {{HMSC.drop*()}} methods is true.
 # Either PURGE is explicitly specified on the command-line (or rather, 
 {{ifPurge}} is set in the environment context, OR
 # TBLPROPERTIES contains {{auto.purge=true}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)