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

["Sergio Peña (JIRA)" <ji...@apache.org>]

Sergio Peña created HIVE-11418:
----------------------------------

             Summary: Dropping a database in an encryption zone with CASCADE and trash enabled fails
                 Key: HIVE-11418
                 URL: https://issues.apache.org/jira/browse/HIVE-11418
             Project: Hive
          Issue Type: Sub-task
    Affects Versions: 1.2.0
            Reporter: Sergio Peña


Here's the query that fails:

{noformat}
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.)
{noformat}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)