Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-8065 Support HDFS encryption functionality on Hive
  3. HIVE-11418

Dropping a database in an encryption zone with CASCADE and trash enabled fails

    XMLWordPrintableJSON

    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.

        Attachments

        1. HIVE-11418.2.patch
          20 kB
          Sahil Takiar
        2. HIVE-11418.1.patch
          20 kB
          Sahil Takiar

          Issue Links

            Activity

              People

              • Assignee:
                stakiar Sahil Takiar
                Reporter:
                spena Sergio Peña
              • Votes:
                0 Vote for this issue
                Watchers:
                13 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: