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

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

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

Target Version:

Impala 4.3.0
Epic Color:
ghx-label-7

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