[
https://issues.apache.org/jira/browse/HIVE-9118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)
