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 "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/09/06 20:19:00 UTC
[jira] [Commented] (IMPALA-7002) Referencing non-existent
table/database in CTE without any privilege results in AnalysisException
and not AuthorizationException
[ https://issues.apache.org/jira/browse/IMPALA-7002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16606352#comment-16606352 ]
Tim Armstrong commented on IMPALA-7002:
---------------------------------------
[~fredyw] do you think the fix is straightforward? Might be a good newbie task.
> Referencing non-existent table/database in CTE without any privilege results in AnalysisException and not AuthorizationException
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: IMPALA-7002
> URL: https://issues.apache.org/jira/browse/IMPALA-7002
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.10.0, Impala 2.11.0, Impala 2.12.0
> Reporter: Fredy Wijaya
> Priority: Major
> Labels: security
>
> {noformat}
> A CTE from non-existent database.
> [localhost:21000] default> with t as (select id from nodb.alltypes) select * from t;
> Query: with t as (select id from nodb.alltypes) select * from t
> Query submitted at: 2018-05-09 12:31:29 (Coordinator: http://impdev-dev:25000)
> ERROR: AnalysisException: Could not resolve table reference: 'nodb.alltypes'
> A normal select from non-existent database.
> [localhost:21000] default> select id from nodb.alltypes; Query: select id from nodb.alltypes
> Query submitted at: 2018-05-09 12:32:58 (Coordinator: http://fwijaya-dev:25000)
> ERROR: AuthorizationException: User 'impdev' does not have privileges to execute 'SELECT' on: nodb.alltypes
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org