[ 
https://issues.apache.org/jira/browse/HIVE-14805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aihua Xu updated HIVE-14805:
----------------------------
    Description: 
Here is the repro steps.
{noformat}
create table t1(col string);
create view v1 as select * from t1;
create view dataview as select * from  (select * from v1) v2;
select * from dataview;
{noformat}

If hive is configured with authorization hook like Sentry, it will require the 
access not only for dataview but also for v1, which should not be required.
The subquery seems to not carry insideview property from the parent query.






  was:
Here is the repro steps.
{noformat}
create table t1(col string);
create view v1 as select * from t1;
create view dataview as select v1.col from v1 join (select * from v1) v2 on 
v1.col=v2.col;
select * from dataview;
{noformat}

If hive is configured with authorization hook like Sentry, it will require the 
access not only for dataview but also for v1, which should not be required.
The subquery seems to not carry insideview property from the parent query.







> Subquery inside a view doesn't set InsideView property correctly
> ----------------------------------------------------------------
>
>                 Key: HIVE-14805
>                 URL: https://issues.apache.org/jira/browse/HIVE-14805
>             Project: Hive
>          Issue Type: Bug
>          Components: Views
>    Affects Versions: 2.0.1
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>
> Here is the repro steps.
> {noformat}
> create table t1(col string);
> create view v1 as select * from t1;
> create view dataview as select * from  (select * from v1) v2;
> select * from dataview;
> {noformat}
> If hive is configured with authorization hook like Sentry, it will require 
> the access not only for dataview but also for v1, which should not be 
> required.
> The subquery seems to not carry insideview property from the parent query.



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

Reply via email to