Hive Metrics

 

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

The metrics dump will display any metric available over JMX encoded in JSON: 

Alternatively the metrics can be written directly into HDFS, a JSON file on the local file system where the HS2 instance is running or to the console by enabling the corresponding metric reporters. By default only the JMX and the JSON file reporter are enabled.

These metrics include:

• jvm.pause.info-threshold (Hive 2.0.0 )
• jvm.pause.warn-threshold (Hive 2.0.0 )
• jvm.pause.extraSleepTime (Hive 2.0.0 )
• open_connections (Hive 2.0.0 )
• open_operations (Hive 2.0.0 )
• cumulative_connection_count (Hive 2.1.0 )
• metastore_hive_locks (Hive 2.0.0 )
• zookeeper_hive_sharedlocks (Hive 2.0.0 )
• zookeeper_hive_exclusivelocks (Hive 2.0.0 )
• zookeeper_hive_semisharedlocks (Hive 2.0.0 )
• exec_async_queue_size (Hive 2.0.0 )
• exec_async_pool_size (Hive 2.0.0 )
• HiveServer2 operations (Hive 2.0.0 )
• HiveServer2 operations completed (Hive 2.0.0 )
• SQL operations (Hive 2.1.0 )
• SQL operations completed (Hive 2.1.0 )
• init_total_count_dbs (Hive 2.1.0 )
• init_total_count_tables (Hive 2.1.0 )
• init_total_count_partitions (Hive 2.1.0 )
• create_total_count_dbs (Hive 2.1.0 )
• create_total_count_tables (Hive 2.1.0 )
• create_total_count_partitions (Hive 2.1.0 )
• delete_total_count_dbs (Hive 2.1.0 )
• delete_total_count_tables (Hive 2.1.0 )
• delete_total_count_partitions (Hive 2.1.0 )
• directsql_errors (Hive 2.1.0 )
• waiting_compile_ops (Hive 2.2.0 )
• hive_mapred_tasks (Hive 2.2.0 )
• hive_spark_tasks (Hive 2.2.0 )
• hive_tez_tasks (Hive 2.2.0 )
• acquireReadWriteLocks (Hive 0.8.0 )
• compile (Hive 0.8.0 )
• doAuthorization (Hive 0.8.0 )
• Driver.execute (Hive 0.8.0 )
• releaseLocks (Hive 0.8.0 )
• prune-listing (Hive 0.8.0 )
• partition-retrieving (Hive 0.8.0 )
• PreHook (Hive 0.8.0 )
• PostHook (Hive 0.8.0 )
• FailureHook (Hive 0.8.0 )
• parse (Hive 0.12.0 )
• semanticAnalyze (Hive 0.12.0 )
• getInputSummary (Hive 0.12.0 )
• getSplits (Hive 0.12.0 )
• runTasks (Hive 0.12.0 )
• serializePlan (Hive 0.12.0 )
• deserializePlan (Hive 0.12.0 )
• clonePlan (Hive 0.12.0 )
• task (Hive 0.12.0 )
• optimizer (Hive 2.0.0 )
• Driver.run (Hive 0.9.0 )
• TezCompiler (Hive 2.1.0 )
• TezSubmitToRunningDag (Hive 0.13.0 )
• TezBuildDag (Hive 0.13.0 )
• TezSubmitDag (Hive 0.13.0 )
• TezRunDag (Hive 0.13.0 )
• TezCreateVertex (Hive 0.13.0 )
• TezRunVertex (Hive 0.13.0 )
• TezInitializeProcessor (Hive 0.13.0 )
• TezRunProcessor (Hive 0.13.0 )
• TezInitializeOperators (Hive 0.13.0 )
• LoadHashtable (Hive 0.13.0 )
• SparkSubmitToRunning (Hive 1.1.0 )
• SparkBuildPlan (Hive 1.1.0 )
• SparkBuildRDDGraph (Hive 1.1.0 )
• SparkSubmitJob (Hive 1.1.0 )
• SparkRunJob (Hive 1.1.0 )
• SparkCreateTran (Hive 1.1.0 )
• SparkRunStage (Hive 1.1.0 )
• SparkInitializeOperators (Hive 1.1.0 )
• SparkGenerateTaskTree (Hive 1.1.0 )
• SparkFlushHashTable (Hive 1.1.0 )
• SparkOptimizeOperatorTree (Hive 1.1.0 )
• SparkOptimizeTaskTree (Hive 1.1.0 )
• hs2_open_sessions (Hive 2.2.0 )
• hs2_active_sessions (Hive 2.2.0 )
• hs2_abandoned_sessions (Hive 2.2.0 )
• hs2_avg_open_session_time (Hive 2.2.0 )
• hs2_avg_active_session_time (Hive 2.2.0 )
• hs2_submitted_queries (Hive 2.2.0 )
• hs2_compiling_queries (Hive 2.2.0 )
• hs2_executing_queries (Hive 2.2.0 )
• hs2_failed_queries (Hive 2.2.0 )
• hs2_succeeded_queries (Hive 2.2.0 )
• GarbageCollectorMetricSet (Hive 1.3.0 ) - publishing attributes of GarbageCollectorMXBeans
• MemoryUsageGaugeSet (Hive 1.3.0 ) - publishing attributes of MemoryMXBeans
• ThreadStatesGaugeSet (Hive 1.3.0 ) - publishing attributes of ThreadMXBeans
• ClassLoadingGaugeSet (Hive 1.3.0 ) - publishing attributes of ClassLoadingMXBeans
• BufferPoolMetricSet (Hive 1.3.0 ) - publishing attributes of BufferPool JMX beans

Configuration properties for metrics can be found here:  Metrics.

See HiveServer2 Overview for more information about HiveServer2.