I have a work around: moved the MySQL Hive Metastore off the hadoop clusters. The MySQL now reside on the “ambari” server node. My HDP 2.0 cluster in finally up and running!
– It because the MySQL is just a metastore, having it off the hive node shouldn’t be too much of a performance impact. Or am I mistaken with this naive assumption?