[
https://issues.apache.org/jira/browse/HIVE-9086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14337520#comment-14337520
]
Mithun Radhakrishnan commented on HIVE-9086:
--------------------------------------------
Judging from [the
patch|https://issues.apache.org/jira/secure/attachment/12670435/HIVE-7100.11.patch#file-12],
HIVE-7100 added the "drop-table-purge" functionality to read thus:
{code:sql}
DROP TABLE IF EXISTS my_doomed_table PURGE;
{code}
The current "alter table drop partitions" reads as follows:
{code:sql}
ALTER TABLE my_doomed_table DROP IF EXISTS PARTITION (part_key = "sayonara")
IGNORE PROTECTION;
{code}
HIVE-9086 extends HIVE-7100's purge-functionality to partitions, and suggests
that the {{PURGE}} keyword go at the end, thus:
{code:sql}
ALTER TABLE my_doomed_table DROP IF EXISTS PARTITION (part_key = "sayonara")
IGNORE PROTECTION PURGE;
{code}
Should {{PURGE}} sit before/after {{IF EXISTS}} or after {{IGNORE PROTECTION}}?
We can't break backward compatibility, so we shouldn't be changing what we
released in 0.14.
> Add language support to PURGE data while dropping partitions.
> -------------------------------------------------------------
>
> Key: HIVE-9086
> URL: https://issues.apache.org/jira/browse/HIVE-9086
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.15.0
> Reporter: Mithun Radhakrishnan
> Assignee: Mithun Radhakrishnan
> Attachments: HIVE-9086.1.patch
>
>
> HIVE-9083 adds metastore-support to skip-trash while dropping partitions.
> This patch includes language support to do the same.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
