In this article we will explain how to resolve hive goes to down in production cluster while updating the services or cluster.

HDP Hive error:

I am trying to update the Hive service in Hontonworks Data Platform (HDP) getting below and Hive service went to down.

Connection failed on host <hostname> or <fully qualified domain name>:10001 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/stacks/HDP/3.0/services/HIVE/package/alerts/alert_hive_thrift_port.py", line 204, in execute ldap_password=ldap_password) File "/usr/lib/ambari-agent/lib/resource_management/libraries/functions/hive_check.py", line 85, in check_thrift_port_s...

Solution:

1. First, I have checked the Hive logs it’s showing above error.

2.Then I went to Ambari, click on Hive Service “Restart” the service through Web – UI

3. After some time again Hive server goes down.

4.So I went to login edge server through putty, after that restarted from putty. It’s working fine.

Sometime web – ui restarted is not working properly then will go to the backend start the Hive service.

These type of error common in Hive server. Sometimes we will get Hive Server Connection refused. First, resolution like Hive restart on Amabri web – ui. Second, resolution like through CLI prompt from backed we have restarted simply.