hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input
Date Sun, 31 May 2015 18:34:17 GMT

    [ 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)

Mime
View raw message