Reply
Highlighted
Explorer
Posts: 24
Registered: ‎04-17-2017

Cannot create database or perform any hive operation after enabling sentry

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.

Cloudera Employee
Posts: 39
Registered: ‎08-13-2014

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

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
Announcements