[HIVE-14805] Subquery inside a view will have the object in the subquery as the direct input

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.1
• Fix Version/s: 2.2.0
• Component/s: Views
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 21/Sep/16 16:39
• Updated: 26/Oct/18 16:55
• Resolved: 23/Sep/16 13:09

Description

Here is the repro steps.

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;

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.

Issue Links

• is related to: HIVE-20818 Views created with a WHERE subquery will regard views referenced in the subquery as direct input