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

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Hooks
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 18/Jun/18 20:31
• Updated: 20/Jun/18 03:00

Description

On a secured cluster with Sentry integrated run the following queries

create table foobar (id int) partitioned by (val int);
explain alter table foobar add partition (val=50);

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
Required privilege( Table) not available in output privileges
The required privileges: (state=42000,code=40000)