moving hive metastore from one node to another

[#1]

We need to move hive metastore and other hive related components from one node to another.

I already checked on the older posts and a thread on this suggests using the move option in ambari.

But is there any particular order to follow as to which service to move first while doing using the move option :

hive mysql server, hive metastore, hive server2

and is webhcat server part of hive?

appreciate the insights.

[#2]

@n c

Please review this hcc link

https://community.hortonworks.com/questions/57866/how-to-move-hive-and-associated-components-from-on...

Definitely the most important piece is to have a good database backup when hivemetastore is down. Then as outlined above move the mysql database (or used database) first. Then you can move the other components using ambari.

And yes, webhcat is part of hive!

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.