hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-19933) ALTER TABLE DROP PARTITION - Partition Not Found
Date Tue, 03 Jul 2018 00:02:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-19933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16530600#comment-16530600
] 

Aihua Xu commented on HIVE-19933:
---------------------------------

Since we support {{IF EXISTS}} syntax for drop partitions and drop table, {{hive.exec.drop.ignorenonexistent}}
configuration seems not very useful to me. If {{IF EXISTS}} is specified, then drop table/partition/view
will succeed if they don't exist; if not, then "Not found" message will get displayed. Maybe
we should remove this configuration?



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

Mime
View raw message