Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot create database or perform any hive operation after enabling sentry

Cannot create database or perform any hive operation after enabling sentry

Explorer

Logged to beeline:

beeline
!connect jdbc:hive2://<server name>:10000/default
username: hive
password: hive

 

Able to perform grant and create role but not able to do anything else. Hive should have super user privileges

Error: Error: Error while compiling statement: FAILED: SemanticException No valid privileges
User hive does not have privileges for CREATEDATABASE
The required privileges: Server=server1->action=*; (state=42000,code=40000)

 

Kindly Assist.

1 REPLY 1

Re: Cannot create database or perform any hive operation after enabling sentry

Rising Star
If you want to be able to run any SQL as hive you would need to create a role, grant privileges to that role and grant the role to hive. Hive is a superuser insofar as it can grant roles, but by default it has no Sentry roles assigned to it.

Regards,
Jim