Support Questions

Find answers, ask questions, and share your expertise

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

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