[jira] [Created] (IMPALA-15500) Privilege requests for columns in the USING clause are not registered by ImpalaSqlValidatorImpl of the Calcite planner

["Fang-Yu Rao (Jira)" <ji...@apache.org>]

Fang-Yu Rao created IMPALA-15500:
------------------------------------

             Summary: Privilege requests for columns in the USING clause are not registered by ImpalaSqlValidatorImpl of the Calcite planner
                 Key: IMPALA-15500
                 URL: https://issues.apache.org/jira/browse/IMPALA-15500
             Project: IMPALA
          Issue Type: Bug
            Reporter: Fang-Yu Rao
            Assignee: Fang-Yu Rao


Privilege requests for columns in the USING clause are not registered by [ImpalaSqlValidatorImpl.java|https://github.com/apache/impala/blob/master/java/calcite-planner/src/main/java/org/apache/impala/calcite/service/ImpalaSqlValidatorImpl.java].

For instance, in the following query, Impala's Calcite planner does not register the privilege request for the column '{{{}id{}}}' of the table '{{{}functional.alltypestiny{}}}'.
{code:java}
with alltypes as (select 100 as id)
select alltypes.id from alltypes join functional.alltypestiny using (id)
{code}
We most likely need to override [SqlValidatorImpl#validateJoin()|https://github.com/apache/calcite/blob/e9185e9/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorImpl.java#L4228-L4367], which is a protected method. Note that the column name resolution happens within {{validateCommonJoinColumn(id, left, right, scope, natural)}} but unfortunately it's a private method.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org