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

["Mithun Radhakrishnan (JIRA)" <ji...@apache.org>]

Mithun Radhakrishnan created HIVE-9118:
------------------------------------------

             Summary: 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: 0.15.0
            Reporter: Mithun Radhakrishnan
            Assignee: Mithun Radhakrishnan


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)