My Oracle Support Banner

Unable to Set Read Level Privileges on a Hive Table using Sentry (Doc ID 1954225.1)

Last updated on AUGUST 03, 2021

Applies to:

Big Data Appliance Integrated Software - Version 4.0 and later
Linux x86-64

Symptoms

Unable to set user read privileges on a Hive table using Sentry. The following error message is returned:

jdbc:hive2://<HOSTNAME4>.<DOMAIN>:10000/> grant select on table `<TABLE_NAME>` Partition (<PARTITION>=<PARTITION_VALUE>) to role <ROLE>;
Error: Error while compiling statement: FAILED: SemanticException Sentry does not support partition level authorization (state=42000,code=40000)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.