https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-move-hive-and-associated-components-from-one-node-to/m-p/165489#M41497 <P>the manual step involved is to move Hive metastore, luckily we have steps outlined here <A href="https://community.hortonworks.com/articles/49660/moving-mysql-server-to-another-host.html" target="_blank">https://community.hortonworks.com/articles/49660/moving-mysql-server-to-another-host.html</A> then you can move other components using Ambari <A href="https://community.hortonworks.com/questions/20404/move-hive-server-from-one-node-to-another-in-hdp-c.html" target="_blank">https://community.hortonworks.com/questions/20404/move-hive-server-from-one-node-to-another-in-hdp-c.html</A></P> Mon, 26 Sep 2016 01:52:28 GMT aervits 2016-09-26T01:52:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-move-hive-and-associated-components-from-one-node-to/m-p/165488#M41496 <P>I am running ambari 2.2.2.0</P><P>I see there is an option for moving hive, just wondering what the process is. I assume shutdown hive metastore, hiveserver2, mysql server and webhcat server, then move the components and start things back up. </P><P>Is there a specific order things thing should be moved? </P><P>Are there configuration changes that need to be made or does ambari do this for you?</P><P>Has anyone done this? I am also wondering how long it might take.</P> Thu, 22 Sep 2016 21:57:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-move-hive-and-associated-components-from-one-node-to/m-p/165488#M41496 wazzu62 2016-09-22T21:57:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-move-hive-and-associated-components-from-one-node-to/m-p/165489#M41497 <P>the manual step involved is to move Hive metastore, luckily we have steps outlined here <A href="https://community.hortonworks.com/articles/49660/moving-mysql-server-to-another-host.html" target="_blank">https://community.hortonworks.com/articles/49660/moving-mysql-server-to-another-host.html</A> then you can move other components using Ambari <A href="https://community.hortonworks.com/questions/20404/move-hive-server-from-one-node-to-another-in-hdp-c.html" target="_blank">https://community.hortonworks.com/questions/20404/move-hive-server-from-one-node-to-another-in-hdp-c.html</A></P> Mon, 26 Sep 2016 01:52:28 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-move-hive-and-associated-components-from-one-node-to/m-p/165489#M41497 aervits 2016-09-26T01:52:28Z