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 Wed, 04 Mar 2015 00:16:05 GMT

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

Lefty Leverenz commented on HIVE-9118:
--------------------------------------

Do we need a TODOC1.2 label on this issue, or will HIVE-9086 suffice?  The table property
needs to be documented as well as the new HQL syntax.

> 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