question Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc in Archives of Support Questions (Read Only)

How to find the database used by Ambari, Hive Metastore, Oozie, etc

zack_riesland — Thu, 12 May 2016 01:21:16 GMT

I'm looking for help in determining which database (PostgreSQL, Oracle, MySQL, etc) is being used by Ambari, Hive Metastore, and Oozie on an existing cluster.

Can someone please point me in the right direction?

Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc

quadoss — Thu, 12 May 2016 01:27:06 GMT

@Zack Riesland

For Ambari, go to the ambari-server properties file in the Ambari server host and this would provide the information about the backend db.

For Hive and Oozie, Go to Ambari -> Hive -> Config and this will provide the info. Like wise for Oozie as well.

Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc

zack_riesland — Thu, 12 May 2016 01:32:35 GMT

Thanks, @mbalakrishnan

To further clarify, I found my Ambari properties file at /etc/ambari-server/conf/ambari.properties

Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc

jaimin — Thu, 12 May 2016 01:41:34 GMT

@Zack Riesland

you can use Ambari's RESTFul APIs to know this on a deployed cluster.

For determining ambari server DB use following API:

http://c6401.ambari.apache.org:8080/api/v1/services/AMBARI/components/AMBARI_SERVER?fields=RootServiceComponents/properties/server.jdbc.database

For determining Hive Metastore DB use following API and lookup for hive_database property

http://c6401.ambari.apache.org:8080/api/v1/clusters/c1/configurations/service_config_versions?service_name=HIVE&is_current=true

For determining Hive Metastore DB use following API and lookup for oozie_database property

http://c6401.ambari.apache.org:8080/api/v1/clusters/c1/configurations/service_config_versions?service_name=OOZIE&is_current=true

Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc

zack_riesland — Thu, 19 May 2016 00:09:43 GMT

For oozie, I changed the URL to point to my server, but it gives me back an empty array:

{
  "href" : "<my server>:8080/api/v1/clusters/c1/configurations/service_config_versions?service_name=OOZIE&is_current=true",
  "items" : [ ]
}

Any ideas?

We don't use Oozie for anything, as far as I know

Re: How to find the database used by Ambari, Hive Metastore, Oozie, etc

siva26akkala — Thu, 18 May 2017 06:04:41 GMT

Equivalent lookup for ambari.properties file.

http://<ambari_server>:8080/api/v1/services/AMBARI/components/AMBARI_SERVER?fields=RootServiceComponents/properties