What are the Steps/ Best Practices of migrating Hive Service like Hive Metastore and Hive Server2 to new Node.
HS2 is easier, just install rpm on new node, and use the old hive-site.xml to start.
HM depends on if you need to migrate the backend database or not:
1. Yes, then you need to dump and restore the backend database firstly; And grant proper privileges.
2. No, then just change the JDBC connection parameters in hive-site.xml of HM.
The underlying database (Metastore db) needs to be safely dumped and the configuration backups should be done before the components migrated.
Retrieving data ...