This is first time we are configuring mySQL as external databases for hive metastore and rest of CM components (Service Monitor, activity monitor etc...) We are separating to have one node for CM and anothe node for mySQL.
We were able to get the CM management services up running but it takes more than five minutes login to hive CLI. Once in Hive CLI, hive commands just hangs and can't run any hive queries.
When I look at the "metastore" database in mysql, I don't see any tables created. Below is the link that I followed.