Hive ACID metric properties for compaction observability
As an administrator, you must configure certain properties related to the Hive ACID metrics service to enable the collection of Hive ACID metrics that are required to display compaction-related alerts and charts in Cloudera Manager.
Basic properties
You must configure the following metrics to enable Hive ACID metrics collection:
- hive.metastore.metrics.enabled
- Default value: True
- hive.server2.metrics.enabled
- Default value: True
- hive.metastore.acidmetrics.ext.on
- Default value: False
- metastore.acidmetrics.thread.on
- Default value: True
Advanced properties
Set these additional properties to configure how Hive ACID metrics service collects metric data:
The following properties have to be configured in the HMS instance where
metastore.acidmetrics.thread.on
is enabled:- metastore.acidmetrics.check.interval
- Default value: 300 seconds
- metastore.acidmetrics.table.aborted.txns.threshold
- Default value: 1500
- metastore.compactor.acid.metrics.logger.frequency
- Default value: 360m
The following properties have to be configured in the HS2 (Hive on Tez) service:
- hive.txn.acid.metrics.cache.size
- Default value: 100
- hive.txn.acid.metrics.cache.duration
- Default value: 7200 seconds
- hive.txn.acid.metrics.reporting.interval
- Default value: 30 seconds
- hive.txn.acid.metrics.delta.num.threshold
- Default value: 100
- hive.txn.acid.metrics.obsolete.delta.num.threshold
- Default value: 100
- hive.txn.acid.metrics.delta.check.threshold
- Default value: 300 seconds
- hive.txn.acid.metrics.delta.pct.threshold
- Default value: 0.01