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.


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

Thread pool size

Indicates the size of asynchronous thread pool.


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.


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.