[HIVE-11418] Dropping a database in an encryption zone with CASCADE and trash enabled fails

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 3.0.0
• Assignee: Sahil Takiar
• Reporter: Sergio Peña
• Created: 30/Jul/15 22:51
• Updated: 22/May/18 23:58
• Resolved: 19/Apr/17 16:40

Description

Here's the query that fails:

hive> CREATE DATABASE db;
hive> USE db;
hive> CREATE TABLE a(id int);
hive> SET fs.trash.interval=1;
hive> DROP DATABASE db CASCADE;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Unable to drop db.a because it is in an encryption zone and trash
 is enabled.  Use PURGE option to skip trash.)

DROP DATABASE does not support PURGE, so we have to remove the tables one by one, and then drop the database.

Issue Links

• links to: RB