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

Drop-Table-If-Exists can't drop unloaded table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.3.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:
      None

      Description

      "unloaded" in the title means Impala does know the table name.

      If a table is created in Hive and haven't been run INVALIDATE METADATA in Impala, Drop-Table-If-Exists on it will always return results as "Table does not exist."

      Repro:

      $ beeline -u "jdbc:hive2://localhost:11050/default;" -e "create table abcd (i int)"
      $ bin/impala-shell.sh
      [localhost:21000] default> drop table if exists abcd;
      Query: drop table if exists abcd
      +-----------------------+
      | summary               |
      +-----------------------+
      | Table does not exist. |
      +-----------------------+
      Fetched 1 row(s) in 0.04s
      [localhost:21000] default> invalidate metadata abcd;
      Query: invalidate metadata abcd
      Query submitted at: 2019-09-04 06:03:19 (Coordinator: http://quanlong-OptiPlex-7060:25000)
      Query progress can be monitored at: http://quanlong-OptiPlex-7060:25000/query_plan?query_id=c34120fc1891edae:38a6bf0700000000
      Fetched 0 row(s) in 0.05s
      [localhost:21000] default> drop table if exists abcd;                                                                                                                                                         
      Query: drop table if exists abcd
      +-------------------------+
      | summary                 |
      +-------------------------+
      | Table has been dropped. |
      +-------------------------+
      Fetched 1 row(s) in 3.91s 

      Drop-Table-If-Exists should be able to drop such kind of a table.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                stigahuang Quanlong Huang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: