Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to determine the hive metastore db name?

How to determine the hive metastore db name?

Expert Contributor

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

5 REPLIES 5

Re: How to determine the hive metastore db name?

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.

Re: How to determine the hive metastore db name?

Expert Contributor

I am not able to find this property in the xml file.

Re: How to determine the hive metastore db name?

can you post your hive-site.xml?

for other question I dont think there is any direct way to achieve desired result.

Re: How to determine the hive metastore db name?

Expert Contributor

I need this to solve my other question here.

Highlighted

Re: How to determine the hive metastore db name?

Expert Contributor
@Alex Raj

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.

-Mahesh

Don't have an account?
Coming from Hortonworks? Activate your account here