Hive Connections Test

Monitoring client connections to an Apache Hive data warehouse typically provide insights into the workload of the warehouse and whether/not the warehouse is sized well-enough to handle the load. This is exactly the type of visibility the Hive Connections test provides. This test tracks client connections to the target warehouse. With the help of the metrics reported by this test, administrators can determine whether/not the warehouse has sufficient connections to handle subsequent connection requests. Based on these insights, administrators can plan the future connection capacity of the warehouse.

Target of the test : Apache Hive

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the target Apache Hive.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed.


The IP address of the target server that is being monitored.


The port number through which the Apache Hive communicates. The default port is 10002.


By default, the SSL flag is set to False, indicating that the target Apache Hive is not SSL-enabled by default. To enable the test to connect to an SSL-enabled Apache Hive, set the SSL flag to True.

DD Frequency

Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time the test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD Frequency.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Open connections

Indicates the count of incoming connections from clients to the data warehouse.


This is a good measure of the current load on the data warehouse.

Open operations

Indicates the count of open operations in the data warehouse.


Ideally, the value of this measure should be zero.