[HIVE-19933] ALTER TABLE DROP PARTITION - Partition Not Found

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.2
• Component/s: HiveServer2
• Assignee: Alice Fan
• Reporter: David Mollitor
• Created: 18/Jun/18 18:48
• Updated: 21/Oct/22 07:31

Description

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.

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