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)
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.