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.

Requirements

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.

Property	Value
jmx.ports	Network port number where the JMX metrics are available. Used by addCategory_ApacheHive to validate Apache Hive configuration and to set system.category.

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.

Name	Type	Description
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.