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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 3.0.0
    • None
    • 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.1.patch
          20 kB
          Sahil Takiar
        2. HIVE-11418.2.patch
          20 kB
          Sahil Takiar

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: