How does Grafana Hive Dashboard work?

[#1]

Grafana Hive Dashboard shows no Datapoints for Hive Dashboard. Since Hive service in Ambari has no metrics displayed, so where does Grafana read these metrics from?

[#2]

@Arti Wadhwani,

Hive components emit metrics to the AMS collector through the Hadoop metrics2 framework.

On your cluster, is the Ambari Metrics collector component up and running?

Do you see anything in Hive Metastore and HiveServer2 logs?

Do graphs from other service dashboards show data?

[#3]

Hi @Aravindan Vijayan

-- ambari metrics monitor logs on all hosts throws "Error sending metrics to the server.. Connection refused" errror

-- ambari metrics collector logs have no errors

--other services dashboard in Grafana work fine.

[#4]

@ Aravindan Vijayan

I'm facing the same issue. All other dashboards are showing metrics data. I do not see any metrics error either in hivemetastore or hiveserver2 logs. All database properties are filled in and Hive is working fine.

Ambari version: 2.4.2.0

HDP Stack: 2.4.3.0

Grafana version: 2.4.1.0-22

Datasource: Ambari Metrics

[#5]

@P D you have mismatch in version of Ambari and Grafana, can't conclusively say it is related to your issue but certainly not optimal, if your ambari version is 2.4.2, ambari-metrics-grafana must match the version.

On my machine it looks like so

ambari-metrics-monitor-2.5.0.1-51.x86_64
ambari-infra-solr-client-2.5.0.1-51.noarch
ambari-metrics-hadoop-sink-2.5.0.1-51.x86_64
ambari-metrics-grafana-2.5.0.1-51.x86_64
ambari-agent-2.5.0.1-51.x86_64

[#6 · Accepted solution]

Hi @Arti Wadhwani

I had similar issues with the Hive Dashboard. May be problem is due to Hive Metastore

What I did was

• Created New Mysql database
• Created jdbc connection as described in the hive installation guide.
• Logged in to ambari web service > hive > config > advanced.
• Filled the required details and tested the connection.

After that Hive Metastore was working fine and I was able to see the metrics in grafana.

[#7]

Hi Himanshu,

I too have the same issue.Can you please elaborate the steps that you followed?

Thank you.

[#8]

@ Artem Ervits

Sorry it's a typo. I see Ambari and Grafana both have same version. But Solr still has 2.4.1

I've updated Ambari about couple of days ago to 2.4.2

ambari-agent-2.4.2.0-136.x86_64
ambari-metrics-monitor-2.4.2.0-136.x86_64
ambari-infra-solr-2.4.1.0-22.x86_64
ambari-server-2.4.2.0-136.x86_64
ambari-metrics-grafana-2.4.2.0-136.x86_64
ambari-metrics-hadoop-sink-2.4.2.0-136.x86_64
ambari-metrics-collector-2.4.2.0-136.x86_64
ambari-infra-solr-client-2.4.1.0-22.x86_64

[#9]

Try the Skivia app. It can sync Grafana and Hive Data without coding. Read more here.