You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by "Eric Lin (JIRA)" <ji...@apache.org> on 2015/10/24 11:51:27 UTC

[jira] [Updated] (SENTRY-922) INSERT OVERWRITE DIRECTORY permission not working correctly

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

Eric Lin updated SENTRY-922:
----------------------------
    Description: 
Run the following command with correct URI permissions:

{code}
INSERT OVERWRITE DIRECTORY '/tmp/test' select * FROM sample_07 LIMIT 100;
{code}

without "LOCAL" keyword, sentry will complain the following:

{code}
Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->URI=file:///tmp/test->action=*; (state=42000,code=40000)
{code}

However, after giving permission to "file:///tmp/test", query finished with data in "hdfs:///tmp/test", even though no permission to "hdfs:///tmp/test"

  was:
Run the following command:

{code}
INSERT OVERWRITE DIRECTORY '/tmp/test' select * FROM sample_07 LIMIT 100;
{code}

without "LOCAL" keyword, sentry will complain the following:

{code}
Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->URI=file:///tmp/test->action=*; (state=42000,code=40000)
{code}

However, after giving permission to "file:///tmp/test", query finished with data in "hdfs:///tmp/test", even though no permission to "hdfs:///tmp/test"


> INSERT OVERWRITE DIRECTORY permission not working correctly
> -----------------------------------------------------------
>
>                 Key: SENTRY-922
>                 URL: https://issues.apache.org/jira/browse/SENTRY-922
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 1.4.0
>            Reporter: Eric Lin
>
> Run the following command with correct URI permissions:
> {code}
> INSERT OVERWRITE DIRECTORY '/tmp/test' select * FROM sample_07 LIMIT 100;
> {code}
> without "LOCAL" keyword, sentry will complain the following:
> {code}
> Error: Error while compiling statement: FAILED: SemanticException No valid privileges
>  Required privileges for this query: Server=server1->URI=file:///tmp/test->action=*; (state=42000,code=40000)
> {code}
> However, after giving permission to "file:///tmp/test", query finished with data in "hdfs:///tmp/test", even though no permission to "hdfs:///tmp/test"



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