[IMPALA-11245] Inaccurate tips with 'select' on not exist table

• Type: Improvement
• Status: Reopened
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 4.0.0, Impala 3.4.0
• Component/s: Frontend
• Labels: auto-deprioritized-minor
• Epic Color: ghx-label-6
• Assignee: Unassigned
• Reporter: Weizisheng
• Created: 14/Apr/22 10:12
• Updated: 14/Apr/23 03:09

Description

select count(1) from db.test;

Both database 'db' and table 'test' 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: db.test" is more friendly tip .   Just like 'insert into db.test' gives error "AnalysisException: Database does not exist: db".

resolvePath source code here ignores table not exist exception, and the above two errors return to the user.