Hive services fail to start giving the error "HTTP Error 404: Not Found"

Products

• Services Suite

Issue/Introduction

Symptoms:

HiveServer2 or Hive MetaStore service fails to start from Ambari.
 

The following error message is produced from the Ambari WebUI:

:
Traceback (most recent call last):
 File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_server.py", line 185, in <module>
 HiveServer().execute()
 File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 218, in execute
 method(env)
:
:
 File "/usr/lib/python2.6/site-packages/resource_management/core/source.py", line 51, in __call__
 return self.get_content()
 File "/usr/lib/python2.6/site-packages/resource_management/core/source.py", line 195, in get_content
 raise Fail("Failed to download file from {0} due to HTTP error: {1}".format(self.url, str(ex)))
resource_management.core.exceptions.Fail: Failed to download file from https://bdl8node01.isus.emc.com:8443/resources//postgres-jdbc-driver.jar due to HTTP error: HTTP Error 404: Not Found
stdout: /var/lib/ambari-agent/data/output-477.txt

Environment

Cause

For some unknown reason, a symbolic link postgres-jdbc-driver.jar was removed from the directory of /var/lib/amvari-server/resources/. It is possible the symbolic link got removed by mistake during a cluster maintenance.

Resolution

Follow the instructions below to resolve this issue: 

1. Identify the Java Database Connectivity (JDBC) driver (.jar) file from the Ambari server node:

# locate postgresql | grep jdbc | grep jar
/usr/lib/ambari-server/postgresql-9.3-1101-jdbc4.jar

2. Create a symbolic link of postgres-jdbc-driver.jar under /var/lib/ambari-server/resources. Make it pointing to the identified file:

# cd /var/lib/ambari-server/resources/
# ln -s /usr/lib/ambari-server/postgresql-9.3-1101-jdbc4.jar postgres-jdbc-driver.jar

3. Restart the related Hive services from Ambari.