Pre-requisites for Monitoring Apache Hive

Before attempting to manage and monitor Apache Hive, make sure that the following pre-requisites are fulfilled:

• To collect the required metrics from the target Apache Hive data warehouse, the eG agent should be able to connect to the port through which the target warehouse communicates. The default port is 10002.

• Apache Hive supports 2.3.0 version and above. As part of pre-requisites, navigate to the following directory -HIVE_HOME/conf/hive-site.xml to view the Hive-site xml file and then enable the Hive Metastore and HiveServer2 metric properties in the xml file. If you are unable to find those 2 properties in the xml file, then add those properties as shown below and change the corresponding values for both properties as True (By default, the value is False).

  <property>
  <name>hive.metastore.metrics.enabled</name>
  <value>true</value>
  </property>
  <property>
  <name>hive.server2.metrics.enabled</name>
  <value>true</value>
  </property>

• After adding those properties, restart Hiveserver2 and Hive Metastore service.

• Check the property value for Hiveserver2 webport in the xml file as shown below. By default, the port is 10002. If you have configured with different port number, then provide the similar port number while configuring the Apache Hive Component.

  <property>
  <name>hive.server2.webui.port</name>
  <value>10002</value>
  </property>