Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Super Collaborator

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?

1 ACCEPTED SOLUTION

avatar
Expert Contributor
@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.

View solution in original post

5 REPLIES 5

avatar
Expert Contributor
@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.

avatar
Super Collaborator

Thanks, @mbalakrishnan

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

avatar

avatar
Super Collaborator

@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=RootServi...

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?servic...

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?servic...

avatar
Super Collaborator

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