I need to query the Hive metastore db and to do that I need the metastore db name. How can I determine the Hive metastore db name? I have searched in hive-conf.xml file also but no luck. I am using CDH 5.5
look for javax.jdo.option.ConnectionURL in hive-site.xml,
in my case it is jdbc:mysql://sandbox.hortonworks.com/hive?createDatabaseIfNotExist=true so my metastore db name is hive.
From the information that I have gathered, I there should be a hive-site.xml in the Hive Server Node, can you check that you to see if you can spot it.
If not there should be a option in cloudera manager which should also have this information.