[
https://issues.apache.org/jira/browse/HIVE-9086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14337374#comment-14337374
]
Lefty Leverenz commented on HIVE-9086:
--------------------------------------
bq. FWIW, I prefer the syntax from the patch. I think it reads more cleanly.
Agreed, "DROP PURGE PARTITION" is harder to understand than "DROP PARTITION
PURGE". The IF EXISTS option doesn't have the same natural language problem.
But it's confusing to put PURGE after PARTITION in the ALTER statement
(separate from IF EXISTS) while the DROP TABLE statement puts it next to IF
EXISTS.
* Would the DROP TABLE syntax be better if it were "DROP TABLE IF EXISTS
table_name PURGE"? But that breaks backward compatibility (PURGE was added in
0.14.0).
* Should the syntax of both statements be changed to tolerate either placement
of PURGE?
> 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)
