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

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Convert to Issue

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.2.0
Fix Version/s: 3.0.0
Component/s: None
Labels:
None

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.