hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-14805) Subquery inside a view doesn't set InsideView property correctly
Date Wed, 21 Sep 2016 16:41:20 GMT

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






  was:
Here is the repro steps.

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;

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 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.



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

Mime
View raw message