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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org