Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1711

DROP TABLE fails after COMPUTE STATS and ALTER TABLE RENAME to a different database.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.1
    • Impala 2.2
    • None

    Description

      Repro:

      CREATE DATABASE a;
      CREATE DATABASE b;
      
      CREATE TABLE a.test1 (a string);
      INSERT INTO a.test1 (a) VALUES ("a");
      COMPUTE STATS a.test1;
      DROP TABLE a.test1; <-- this works
      
      CREATE TABLE a.test2 (a string);
      INSERT INTO a.test2 (a) VALUES("b");
      COMPUTE STATS a.test2;
      ALTER TABLE a.test2 RENAME TO b.test2;
      DROP TABLE b.test2; <-- this line fails with the stack trace originally posted
      
      ALTER TABLE b.test2 RENAME to a.test2; #move table back to original location
      DROP TABLE a.test2; <-- this now works
      
      DROP DATABASE a;
      DROP DATABASE b;
      

      Attachments

        Activity

          People

            alex.behm Alexander Behm
            alex.behm Alexander Behm
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: