@panitta suksaran As we see the error, Where it looks like you have not setup MySQL server for Hive properly. Please see: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-administration/content/using_hive_with_mysql.html 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 http://xxxxxx:8080/resources//mysql-connector-java.jar due to HTTP error: HTTP Error 404 So please make sure that you have already done the following steps? On the Ambari Server Host. # yum install mysql-connection-java -y (OR) if you are downloading the mysql-connector-java JAR from some tar.gz archive then please make sure to check the following locations and create the symlinks something like following to point to your jar. . Then you should find some symlink as following: Example: # ls -l /usr/share/java/mysql-connector-java.jar lrwxrwxrwx 1 root root 31 Apr 19 2017 /usr/share/java/mysql-connector-java.jar -> mysql-connector-java-5.1.17.jar https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-administration/content/using_hive_with_mysql.html So now ambari knows how to find this jar. The JAR can be found here after # ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar # ls -l /var/lib/ambari-server/resources/mysql-connector-java.jar -rw-r--r-- 1 root root 819803 Sep 28 19:52 /var/lib/ambari-server/resources/mysql-connector-java.jar Reference HCC Thread: https://community.hortonworks.com/questions/186090/mysql-connector-javajar-due-to-http-error-http-err.html . ... View more