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 2021/05/07 12:45:00 UTC
[jira] [Updated] (IMPALA-8918) Drop-Table-If-Exists can't drop
unloaded table
[ https://issues.apache.org/jira/browse/IMPALA-8918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang updated IMPALA-8918:
-----------------------------------
Target Version: Impala 4.1 (was: Impala 4.0)
> 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
> Priority: Major
>
> "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.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org