[IMPALA-8918] Drop-Table-If-Exists can't drop unloaded table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.3.0
• Component/s: Frontend
• Target Version: Impala 4.3.0
• Epic Color: ghx-label-7
• Assignee: Unassigned
• Reporter: Quanlong Huang
• Created: 04/Sep/19 13:06
• Updated: 23/Nov/22 12:28

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.

Issue Links

• is broken by: IMPALA-8851 Drop table if exists throws authorization exception when table does not exist