Hive Operation Test
Apache Hive chooses respective database servers to store the schema or Metadata of tables, databases, columns in a table, their data types, and HDFS mapping. This test periodically monitors the SQL/API call operations of the target Apache Hive. Using the test, administrators can proactively be alerted when Apache Hive is non operational/stopped. In addition, this test throws light on the SQL/API call operations that were completed and the operations that were kept pending.
Target of the test : Apache Hive
Agent deploying the test : An internal/remote agent
Outputs of the test : One set of results for each operation:total/active SQL and API call operations to the target Apache Hive.
| 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. |
| Measurement | Description | Measurement Unit | Interpretation |
|---|---|---|---|
|
Initialized count |
Indicates the number of total/active SQL and API call operations that are currently initialized. |
Number |
|
|
Running count |
Indicates the number of total/active SQL and API call operations that are currently running. |
Number |
|
|
Pending count |
Indicates the number of total/active SQL and API call operations that are currently pending. |
Number |
Ideally, the value of this measure should be zero. |
|
Closed count |
Indicates the number of total/active SQL and API call operations that are currently closed. |
Number |
|
|
Finished count |
Indicates the number of total/active SQL and API call operations that are currently completed. |
Number |
A very high value is desired for this measure. |
|
User active |
Indicates the number of total/active SQL and API call operations that are currently user active. |
Number |
|
