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

["Sahil Takiar (JIRA)" <ji...@apache.org>]

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

Sahil Takiar edited comment on HIVE-11418 at 4/18/17 9:01 PM:
--------------------------------------------------------------

[~spena] could you review? RB: https://reviews.apache.org/r/58330/

Removed the check in {{HiveMetaStore#checkTrashPurgeCombination}} - updated the q test, added a new one called {{encryption_drop_table_in_encrypted_db.q}} that specifically tests encrypting a folder, and then moving a sub-folder into the Trash.


was (Author: stakiar):
[~spena] could you review? RB: https://reviews.apache.org/r/58330/

Removed the check in {{HiveMetaStore#checkTrashPurgeCombination{{ - updated the q test, added a new one called {{encryption_drop_table_in_encrypted_db.q}} that specifically tests encrypting a folder, and then moving a sub-folder into the Trash.

> 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
>            Assignee: Sahil Takiar
>         Attachments: HIVE-11418.1.patch, HIVE-11418.2.patch
>
>
> 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.15#6346)