You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Weizisheng (Jira)" <ji...@apache.org> on 2022/04/14 10:13:00 UTC

[jira] [Created] (IMPALA-11245) Inaccurate description with 'select' on not exist table

Weizisheng created IMPALA-11245:
-----------------------------------

             Summary: Inaccurate description with 'select' on not exist table
                 Key: IMPALA-11245
                 URL: https://issues.apache.org/jira/browse/IMPALA-11245
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 3.4.0, Impala 4.0.0
            Reporter: Weizisheng


{code:java}
select count(1) from db.table;{code}
Both database 'db' and table 'table' are not exist. This will get error "AnalysisException: Could not resolve table reference: 'db.test'". If enabled Ranger then get error "AuthorizationException: User 'xx' does not have privileges to execute 'SELECT' on default.db".

Actually maybe 'Table does not exist:' is more friendly tip :)

[resolvePath|https://github.com/apache/impala/blob/c190966db932cf7b24881ce2213fd6f7d9192099/fe/src/main/java/org/apache/impala/analysis/Analyzer.java#L1237] source code here ignores table not exist exception, and the above two errors return to the user.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)