[
https://issues.apache.org/jira/browse/HIVE-19933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16530682#comment-16530682
]
Alice Fan commented on HIVE-19933:
----------------------------------
Added results of MySQL and Oracle when dropping an non-existing partition:
MySQL
{code:java}
mysql> ALTER TABLE trb3 TRUNCATE PARTITION part1;
ERROR 1735 (HY000): Unknown partition 'part1' in table 'trb3'
{code}
Oracle
{code:java}
Alter table Q1_SALES_BY_REGION drop partition notexistingpart;
ORA-02149: Specified partition does not exist
{code}
> ALTER TABLE DROP PARTITION - Partition Not Found
> ------------------------------------------------
>
> Key: HIVE-19933
> URL: https://issues.apache.org/jira/browse/HIVE-19933
> Project: Hive
> Issue Type: Improvement
> Components: HiveServer2
> Affects Versions: 1.2.2
> Reporter: BELUGA BEHR
> Assignee: Alice Fan
> Priority: Major
>
> {code:sql}
> ALTER TABLE web_logsz DROP PARTITION (`date`='xyz')
> -- SemanticException [Error 10001]: Table not found web_logsz
> ALTER TABLE web_logs DROP PARTITION (`date`='xyz')
> -- Success.
> {code}
> There is no 'xyz' partition for the 'date' column. To make this more
> consistent, the query should fail if the user tries to drop a partition that
> does not exist
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
