[jira] [Updated] (HIVE-15735) In some cases, view objects inside a view do not have parents

["Yongzhi Chen (JIRA)" <ji...@apache.org>]

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

Yongzhi Chen updated HIVE-15735:
--------------------------------
       Resolution: Fixed
    Fix Version/s: 2.2.0
           Status: Resolved  (was: Patch Available)

Committed to master branch. Thanks [~aihuaxu] for the review.

> In some cases, view objects inside a view do not have parents
> -------------------------------------------------------------
>
>                 Key: HIVE-15735
>                 URL: https://issues.apache.org/jira/browse/HIVE-15735
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Yongzhi Chen
>            Assignee: Yongzhi Chen
>             Fix For: 2.2.0
>
>         Attachments: HIVE-15735.1.patch
>
>
> This cause Sentry throws "No valid privileges" error:
> Error: Error while compiling statement: FAILED: SemanticException No valid privileges.
> To reproduce:
> Enable sentry:
> create table t1( i int);
> create view v1 as select * from t1;
> create view v2 as select * from v1 union all select * from v1;
> If the user does not have read permission on t1 and v1, the query
> select * from v2;  
> This will fail with:
> Error: Error while compiling statement: FAILED: SemanticException No valid privileges
>  User foo does not have privileges for QUERY
>  The required privileges: Server=server1->Db=database2->Table=v1->action=select; (state=42000,code=40000)
> Sentry should not check v1's permission, for v1 has at least one parent(v2).



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)