Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How does Grafana Hive Dashboard work?

Solved Go to solution

How does Grafana Hive Dashboard work?

Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How does Grafana Hive Dashboard work?

New Contributor

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 REPLIES 7

Re: How does Grafana Hive Dashboard work?

Expert Contributor

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

Contributor

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.

Highlighted

Re: How does Grafana Hive Dashboard work?

Contributor

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

Mentor

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

New Contributor

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?

New Contributor

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?

Contributor

@ 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