[jira] [Updated] (HIVE-19936) explain on a query failing in secure cluster whereas query itself works

["Aihua Xu (JIRA)" <ji...@apache.org>]

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

Aihua Xu updated HIVE-19936:
----------------------------
    Status: Patch Available  (was: Open)

patch-1: the source code change is to add the inputs/outputs from explain command. It will affect many test cases since the inputs/outputs of  PREHOOK and POSTHOOK get updated. Will update that later if this change makes sense.

> explain on a query failing in secure cluster whereas query itself works
> -----------------------------------------------------------------------
>
>                 Key: HIVE-19936
>                 URL: https://issues.apache.org/jira/browse/HIVE-19936
>             Project: Hive
>          Issue Type: Bug
>          Components: Hooks
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>            Priority: Major
>         Attachments: HIVE-19936.1.patch
>
>
> On a secured cluster with Sentry integrated run the following queries
> {noformat}
> create table foobar (id int) partitioned by (val int);
> explain alter table foobar add partition (val=50);
> {noformat}
> The explain query will fail with the following exception while the query itself works with no issue.
> Error while compiling statement: FAILED: SemanticException No valid privileges{color}
>  Required privilege( Table) not available in output privileges
>  The required privileges: (state=42000,code=40000)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)