[jira] [Comment Edited] (SENTRY-898) [column level privilege] with column level privilege, show partitions fails, SemanticException No valid privileges

["Anne Yu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SENTRY-898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15368090#comment-15368090 ] 

Anne Yu edited comment on SENTRY-898 at 7/8/16 6:07 PM:
--------------------------------------------------------

Thanks for your patch, [~Ke Jia], could you fix the hadoop-qa?


was (Author: anneyu):
[~hahao], seems like the most recent patch is not the one uploaded to cr. Could you check? Also the cr looks good to me. Ship it upon successful run of hadoop qa. Thanks for your patch!

> [column level privilege] with column level privilege, show partitions fails, SemanticException No valid privileges
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: SENTRY-898
>                 URL: https://issues.apache.org/jira/browse/SENTRY-898
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 1.5.1
>            Reporter: Anne Yu
>            Assignee: Hao Hao
>         Attachments: SENTRY-898-001.patch, SENTRY-898-002.patch
>
>
> If grant column level privilege to test user on a partition, show partitions fails to list the permitted partition with Error: Error while compiling statement: FAILED: SemanticException No valid privileges; 
> {code}
> CREATE TABLE pageviews (userid VARCHAR(64), link STRING, came_from STRING) PARTITIONED BY (datestamp STRING, counter INT) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC;
> grant select(datestamp) on table pageviews to role test_par;
> grant role test_par to group test_user;
> show partitions pageviews;
> {code}
> cc [~guoquan], [~sravya], [~lskuff]



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