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.
Host	The IP address of the target server that is being monitored.
Port	The port number through which the Apache Hive communicates. The default port is 10002.
SSL	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.	Number	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.	Number	Ideally, the value of this measure should be zero.