hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <>
Subject [jira] [Commented] (HIVE-9118) Support auto-purge for tables, when dropping tables/partitions.
Date Wed, 04 Mar 2015 00:16:05 GMT


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:
>             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

View raw message