Apache Hive MonitoringLast updated on 27 December, 2022
LogicMonitor offers monitoring for Apache Hive by default. The monitoring suite uses JMX to query Apache Hive for a wide variety of health and performance metrics.
Apache Hive version 2.3.8 or higher must be used.
Adding Apache Hive Resources
The following custom property must be set on the Apache Hive resource within LogicMonitor. For more information on adding resources into monitoring, see Adding Devices.
|jmx.ports||Network port number where the JMX metrics are available. Used by |
Note: Port number 8808 is used by default for JMX metrics.
Installing the LogicModules
LogicMonitor’s package for Apache Hive consists of the following LogicModules. For full coverage, please ensure that all of these LogicModules are imported into your LogicMonitor platform. For more information, see Installing Modules and Packages.
|addCategory_ApacheHive||PropertySource||Checks to see if Apache Hive is running on the configured JMX port.|
|Hive Metastore API Events||DataSource||Apache Hive Metastore API events, including add, alter, create, drop events per second.|
|Hive Metastore API Active Calls||DataSource||Apache Hive Metastore API Active Calls, including add, alter, create and drop events.|
|Hive Metastore||DataSource||Apache HiveServer2 Metastore database, table, and partition metrics.|
|Hive JVM||DataSource||Apache HiveServer2 JVM memory and thread utilization metrics.|
|Hive HiveServer2 API Events||DataSource||Apache HiveServer2 API events, including HS2 operation and SQL operations.|
|Hive HiveServer2 API Active Calls||DataSource||Apache HiveServer2 API active calls, including HS2 operation and SQL operations.|
|Hive HiveServer2||DataSource||Apache HiveServer2 operation metrics, including SQL operations, running and finished queries, and sessions.|
When setting static datapoint thresholds on the various metrics tracked by this package’s DataSources, LogicMonitor follows the technology owner’s best practice KPI recommendations. If necessary, adjust these predefined thresholds to meet the unique needs of your environment. For more information on tuning datapoint thresholds, see Tuning Static Thresholds for Datapoints.
Note: Not all modules return data, and some of the Apache Hive and Metastore configurations may not provide all metrics. The version of your HiveServer installation may determine the number of metrics returned.