fetching the metrics from Ambari metrics collector

[#1]

Metrics Collector

The standalone server that collects metrics, aggregates metrics, serves metrics from the Hadoop service sinks and the Metrics Monitor.

Metrics Monitor

Installed on each host in the cluster to collect system-level metrics and forward to the Metrics Collector.

I want to get metrics for Hbase from Metrics collector, as I could see metrics collector collects metrics and aggregates metrics and in Ambari Dashboard relevant metrics is being shown .

could some one please help me point out location where does metrics collector store aggregated metrics for different services like HBASE etc .

[#2]

Hi @Anurag Mishra

AMS uses an embedded hbase/phoenix layer. You can query it, and there is a decent writeup on how to do that here:

https://community.hortonworks.com/articles/71206/using-phoenix-sqlline-utility-to-browse-ambari-met....

[#3]

@Sonu Sahi

can you please provide details where this data resides in hbase ?

[#4]

hi @Anurag Mishra

the tables are listed here in the Apache wiki: https://cwiki.apache.org/confluence/display/AMBARI/Phoenix+Schema

[#5]

hi @Sonu Sahi

thanks for your help , actually my focus is one data from where these tables are loading data into its table.

[#6]

Hi, my pleasure. The docs are decent at describing how it works, and where the data comes from. You can probably start the research from this point, and follow the links on the page as needed: https://cwiki.apache.org/confluence/display/AMBARI/Metrics