Hive Asynchronous Operation Test

To optimize the performance and at the same time to support concurrent accesses from users, the Apache Hive data warehouse uses asynchronous thread pools. It is critical to monitor thread pools in a data warehouse on an ongoing basis. This test does just that.

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
Thread pool size	Indicates the size of asynchronous thread pool.	Byte	If the pool size is high and the number of active threads is low, it signifies that the threads are not being destroyed immediately after use.
Operation queue size	Indicates the size of the asynchronous operation queue.	Byte	Ideally, a low value is desired for this measure. An unusually high value of this measure is indicative of any problem with the corresponding queue or its end points.