question Re: How does Grafana Hive Dashboard work? in Archives of Support Questions (Read Only)

How does Grafana Hive Dashboard work?

ArtiW — Wed, 09 Nov 2016 04:12:15 GMT

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?

Re: How does Grafana Hive Dashboard work?

avijayan — Wed, 09 Nov 2016 04:14:53 GMT

@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?

Re: How does Grafana Hive Dashboard work?

ArtiW — Wed, 09 Nov 2016 04:19:06 GMT

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.

Re: How does Grafana Hive Dashboard work?

himanshu_sharma — Wed, 30 Nov 2016 20:41:45 GMT

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.

Re: How does Grafana Hive Dashboard work?

pd47 — Tue, 14 Mar 2017 04:05:57 GMT

@ 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

Re: How does Grafana Hive Dashboard work?

aervits — Tue, 14 Mar 2017 09:50:15 GMT

@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

Re: How does Grafana Hive Dashboard work?

pd47 — Tue, 14 Mar 2017 20:52:04 GMT

@ 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

Re: How does Grafana Hive Dashboard work?

vchandraker — Thu, 06 Jul 2017 20:07:57 GMT

Hi Himanshu,

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

Thank you.

Re: How does Grafana Hive Dashboard work?

MichaelTomar — Thu, 15 Dec 2022 11:46:41 GMT

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