Hive Query Statistics Test

The efficiency of the Apache Hive service can be measured by the quality of the queries. By periodically checking the feedback returned by the data query engine, administrators can determine the number of queries that may have to be optimized before being executed. The Hive Query Statistics test helps administrators perform this check at regular intervals. With the help of the metrics reported by this test, administrators can quickly figure out the number of queries that succeeded and the queries that failed.

Target of the test : Apache Hive

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each Query Statistics:total/active queries to 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
Succeeded queries	Indicates the number of total/active queries that succeeded.	Number	A very high value is desired for this measure.
Failed queries	Indicates the number of total/active queries that failed.	Number	Ideally, the value of this measure should be 0. A non-zero value could indicate that one/more queries have failed.
Compiling queries	Indicates the number of total/active compiling queries.	Number
Executing queries	Indicates the number of total/active executing queries.	Number	A very high value is desired for this measure.
Submitted queries	Indicates the number of total/active submitted queries.	Number
Waiting compile ops	Indicates the number of total/active queries waiting for compilation.	Number	Ideally, the value of this measure should be 0.