question Re: Ambari Metrics Collector DB Metadata in Archives of Support Questions (Read Only)

Ambari Metrics Collector DB Metadata

sunile_manjee — Fri, 29 Jul 2016 23:19:29 GMT

Where can I find information on Ambari Metrics Collector DB Metadata? I understand the metrics are stored on hbase using phoenix. I would like to know more about the tables, metadata, and connection info. Where can I find this information?

Re: Ambari Metrics Collector DB Metadata

vxu — Sat, 30 Jul 2016 00:14:55 GMT

Hi @Sunile Manjee, all the configurations of AMS hbase are in /etc/ams-hbase/conf/ on ambari metrics collector node. You can also view and change that in Ambari Metrics -> Configs -> 'Advanced ams-hbase-env' / 'Advanced ams-hbase-site'.

The best way to check AMS metadata info is to execute the following line on ambari metrics collector node:

# hbase --config /etc/ams-hbase/conf/ shell

Then use 'list', 'desc' or other useful commands to view the metadata you need.

Re: Ambari Metrics Collector DB Metadata

Enis — Sat, 30 Jul 2016 01:22:32 GMT

If you have a live cluster, you can take a look at the catalog from Phoenix. You can either query the SYSTEM.CATALOG table, or use !tables, etc kind of commands to check the catalog.

Re: Ambari Metrics Collector DB Metadata

sidwagle — Sat, 30 Jul 2016 04:49:54 GMT

We have basic stuff documented on the wiki:

https://cwiki.apache.org/confluence/display/AMBARI/Metrics