hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9118) Support auto-purge for tables, when dropping tables/partitions.
Date Mon, 09 Mar 2015 10:04:38 GMT

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

Mime
View raw message