[HIVE-13991] Union All on view fail with no valid permission on underneath table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.1.1, 2.2.0
• Component/s: Query Planning
• Assignee: Yongzhi Chen
• Reporter: Yongzhi Chen
• Created: 10/Jun/16 01:43
• Updated: 08/Dec/16 14:39
• Resolved: 27/Jun/16 15:50

Description

When sentry is enabled.
create view V as select * from T;
When the user has read permission on view V, but does not have read permission on table T,

select * from V union all select * from V
failed with:

0: jdbc:hive2://********> select * from s07view union all select * from s07view limit 1;
Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->Db=default->Table=sample_07->action=select; (state=42000,code=40000)

Issue Links

• duplicates: HIVE-14248 query with view in union adds underlying table as direct input