Hive Metrics

The metrics that Hive collects can be viewed in the HiveServer2 web UI by using the "Metrics Dump" tab.

These metrics include:

• jvm.pause.info-threshold
• jvm.pause.warn-threshold
• jvm.pause.extraSleepTime
• open_connections
• open_operations
• cumulative_connection_count
• metastore_hive_locks
• zookeeper_hive_sharedlocks
• zookeeper_hive_exclusivelocks
• zookeeper_hive_semisharedlocks
• exec_async_queue_size
• exec_async_pool_size
• HiveServer2 operations
• HiveServer2 operations completed
• SQL operations
• SQL operations completed
• init_total_count_dbs
• init_total_count_tables
• init_total_count_partitions
• create_total_count_dbs
• create_total_count_tables
• create_total_count_partitions
• delete_total_count_dbs
• delete_total_count_tables
• delete_total_count_partitions
• directsql_errors
• waiting_compile_ops
• ...
• ...
• ...
• hive_mapred_tasks (Hive 2.2.0+)
• hive_spark_tasks (Hive 2.2.0+)
• hive_tez_tasks (Hive 2.2.0+)

See HiveServer2 Overview for more information about HiveServer2.