[ 
https://issues.apache.org/jira/browse/HIVE-10875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14566660#comment-14566660
 ] 

Thejas M Nair commented on HIVE-10875:
--------------------------------------

This results in SQLStdauthorization (and the HiveAuthorizerAPI) consider the 
input table T as an input on which user needs access.

The problem is that in such queries, the PlanUtils.getParentViewInfo does not 
find the input view. Fixing this would also benefit other optimization code 
which tries to find input view for a table.

cc [~ashutoshc] [~prasadm] 


> Select query with view in subquery adds underlying table as direct input
> ------------------------------------------------------------------------
>
>                 Key: HIVE-10875
>                 URL: https://issues.apache.org/jira/browse/HIVE-10875
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Thejas M Nair
>            Assignee: Thejas M Nair
>
> In the following case, 
> {code}
> create view V as select * from T;
> select * from (select * from V) A;
> {code}
> The semantic analyzer inputs contain input table T as a direct input instead 
> of adding it as an indirect input.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to