Need help cleaning up after failed move of Hive mysql service

[#1]

Hello HCC,

I attempted to perform a move of the mysql service in Hive to another node, but it failed due to a repository problem. Ambari showed a message that there was manual cleanup that needed to be done, but I cannot find any information on how to do it. In the Hive Services screen of Ambari, there are two mysql servers listed, one that runs and the other that does not. This is HDP 2.5.3. Any help cleaning up will be greatly appreciated!

Thanks,

John

[#2 · Accepted solution]

1) Login to Ambari -> Hive -> Config. Check the mysql connection properties to determine which mysql server is currently configured to use.

2) Verify hive works and you are able to access metadata.

3) If you are able to access metadata, go to ambari -> hosts -> select host hosting 2nd instance of mysql.

4) the services is probably stopped or in installed failed state. click on actions and look for delete option.

[#3]

Thank you, Pranay!