resource_management.core.exceptions.Fail: Failed to download file from http://ambari1.hdp.hadoop:8080/resources//mysql-connector-java.jar due to HTTP error: HTTP Error 404: Not Found
By the following command, the problem is fixed:
Ambari Server:(Ref: https://discuss.pivotal.io/hc/en-us/articles/115001611807-Hive-Services-Fail-to-Start-giving-Error-H... )
sudo yum install mysql-connector-java*
ls -al /usr/share/java/mysql-connector-java.jar
ln -s /usr/share/java/mysql-connector-java.jar mysql-connector-java.jar
In same scenario on AWS cloud. First check on ambari server host that directory (/var/lib/ambari-server/resources/) contains the mysql-connector-java.jar file. If not download it and follow below steps.
1. Download mysql connector jar from here
2. Untar the file and rename mysql connector jar to mysql-connector-java.jar
3. Copy the file under directory (/var/lib/ambari-server/resources/)
4. Restart Hive services.
Above troubleshoot helped me where I was installing test HDP cluster on AWS.