You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2019/09/04 13:07:00 UTC
[jira] [Created] (IMPALA-8918) Drop-Table-If-Exists can't drop
unloaded table
Quanlong Huang created IMPALA-8918:
--------------------------------------
Summary: Drop-Table-If-Exists can't drop unloaded table
Key: IMPALA-8918
URL: https://issues.apache.org/jira/browse/IMPALA-8918
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 3.3.0
Reporter: Quanlong Huang
"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:
{code:java}
$ 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 {code}
Drop-Table-If-Exists should be able to drop such kind of a table.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org