User specific default database in Hive
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.