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. ... View more

I was facing the same issue. It looks like it is related to hostname. In dfs.namenode.http properties I have added IP address instead of hostname. Which resolved my issue. ... View more