question Re: Move Hive server from one node to another in HDP cluster. in Archives of Support Questions (Read Only)

Move Hive server from one node to another in HDP cluster.

Nilesh — Tue, 01 Mar 2016 15:29:15 GMT

Hi Team,

What are the steps to move hive server and its metadata from one node to another node in hdp cluster?

Re: Move Hive server from one node to another in HDP cluster.

nsabharwal — Sun, 18 Aug 2019 11:26:06 GMT

@Nilesh

See this

You can use ambari to move HiveServer2 and other components.

Re: Move Hive server from one node to another in HDP cluster.

nsabharwal — Sun, 18 Aug 2019 11:25:57 GMT

Metastore move @Nilesh

Re: Move Hive server from one node to another in HDP cluster.

Nilesh — Tue, 01 Mar 2016 15:42:49 GMT

@Neeraj Sabharwal

how to do manually? In absence of Ambari

Re: Move Hive server from one node to another in HDP cluster.

nsabharwal — Tue, 01 Mar 2016 16:02:45 GMT

@Nilesh

You can add 2nd HS2 https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-HowtoStart

Hive metastore

Backup and restore

https://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.1/bk_upgrading_Ambari/content/_perform_backups_mamiu.html

Re: Move Hive server from one node to another in HDP cluster.

Nilesh — Tue, 01 Mar 2016 21:23:17 GMT

@Neeraj Sabharwal

At present, I have hdp 2.3 cluster. Hive,mysql,hue and metastore installed on namenode.

All these are available incuding mysql and hive metadata (copied from namenode) on one of the datanode from cluster for redundancy purpose of hive.

Now when namenode server goes down then how can i link new host to hive metadata which i have copied.?

How can i do this via ambari as well as without ambari?

Re: Move Hive server from one node to another in HDP cluster.

gates — Wed, 02 Mar 2016 01:17:46 GMT

To get the metastore to use the moved MySQL database you need to change the JDBC URL in the hive-site.xml file on the machine running the metastore. The correct configuration value to change is "javax.jdo.option.ConnectionURL". You will have to restart the metastore after changing this. If you are using HiveServer2 you will need to make this change on that machine as well.

To get your clients to find the new metastore instance you will have to change the thrift URI for the metastore, again in the hive-site.xml file. This will need to be done on all clients that talk to the metastore. The config value to change is "hive.metastore.uris".

Re: Move Hive server from one node to another in HDP cluster.

umair_khan — Wed, 02 Mar 2016 03:30:53 GMT

What you are asking is Hive High Availability, you will need to set it up:

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_hadoop-ha/content/ch_HA-Hive.html

From best practices it is a bad idea to put any master service on data (slave) node. Use another master node to place HA components like hive, resource manager etc.

Re: Move Hive server from one node to another in HDP cluster.

Nilesh — Thu, 03 Mar 2016 15:09:51 GMT

@Alan Gates

This is continued from previous post: I have made required changes in hive-site.xml on datanode, but when i restarted hive service from ambari changes are not reflecting in hive-site.xml it takes previous working configuration.