Difference Between Hive Service Health Status and Hive Instance Health Status

Question

What is the difference between Hive service health status and Hive instance health status?

Solution

The Hive service health status is displayed on Manager and has four values: Good, Bad, Partially Healthy, and Unknown. It depends not only on Hive service availability but also the service status of other related components. Simple SQL is used to check Hive service availability.

Hive instances consist of HiveServer and MetaStore. Their health status is determined by communications between instances and JMX and can be Good (normal communications), Concerning (abnormal communications), or Unknown (no communications).