Reply
New Contributor
Posts: 2
Registered: ‎06-08-2017

Error when creating a new database

When trying to create a new database through the Metastore Manager, an error occurs.

 

This is the error that is displayed:

 

QueryServerException at /beeswax/create/database

 errorMessage='Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [......] does not have [USE] privilege on [default]

 

Access to the default database is not granted to users, but Hue insists on accessing the default database when creating a new database.

 

Could anyone help with a solution to this problem?

Cloudera Employee
Posts: 716
Registered: ‎07-30-2013

Re: Error when creating a new database

This means that your user does not belong to a group with the privileges to
query Hive
http://gethue.com/apache-sentry-made-easy-with-the-new-hue-security-app/
New Contributor
Posts: 2
Registered: ‎06-08-2017

Re: Error when creating a new database

Is there a work around for this? Is there a way for users to create a new database without having to grant them full permissions? Hue shouldn't need to run queries on the default database when creating a new one, correct?

Announcements