User specific default database in Hive I am running a Oracle Big Data Appliance platform that has Cloudera EDH 5.9.x running under the hood. My users are mainly using beeswax, which is the Hive query editor app within Hue.

When a user logs into Hue and then opens beeswax, the default Hive database "default" is preselected. I want to change this so that the first database they see is their own sandbox database. Currently, the user has to manually select the database from beeswax or run the use DATABASE command in the editor.

Is there a configuration item I can change within any of the CDH software modules that will help me do this? Or is there a concept of a Hive startup script where I can run the use DATABASE command?
In bypass mode Hive clients directly access the metastore database instead of using the Hive Metastore Server for metastore information.


Go to the Hive service.
Click the Configuration tab.
Select Scope > HIVE service_name (Service-Wide)
Select Category > Advanced.
Deselect the Bypass Hive Metastore Server property.
Click Save Changes to commit the changes.
Re-deploy Hive client configurations.
Restart Hive and any Hue or Impala services configured to use that Hive service.


This might work for you.