Apache Hive Monitoring

Last 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.portsNetwork port number where the JMX metrics are available. Used by addCategory_ApacheHive to validate Apache Hive configuration and to set system.category.

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_ApacheHivePropertySourceChecks to see if Apache Hive is running on the configured JMX port.
Hive Metastore API EventsDataSourceApache Hive Metastore API events, including add, alter, create, drop events per second.
Hive Metastore API Active CallsDataSourceApache Hive Metastore API Active Calls, including add, alter, create and drop events.
Hive MetastoreDataSourceApache HiveServer2 Metastore database, table, and partition metrics.
Hive JVMDataSourceApache HiveServer2 JVM memory and thread utilization metrics.
Hive HiveServer2 API EventsDataSourceApache HiveServer2 API events, including HS2 operation and SQL operations.
Hive HiveServer2 API Active CallsDataSourceApache HiveServer2 API active calls, including HS2 operation and SQL operations.
Hive HiveServer2DataSourceApache 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.

In This Article