Reply
Highlighted
Explorer
Posts: 11
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.

Announcements