question Re: Hive migration to a new cluster & Hive metastore database change from MySQL to Oracle in Support Questions

Hive migration to a new cluster & Hive metastore database change from MySQL to Oracle

Raj_B — Thu, 22 Feb 2018 00:00:11 GMT

Hello,

We've the following Hive migration scenario where there are several variable/changes, we need to migrate Hive data from Source to Target

Source	Target
Cluster A	Cluster B
HDP 2.5.3	HDP 2.6.2
Hive metastore DB - MySQL	Hive metastore DB - Oracle
Has 7 databases to migrate	No existing data to preserve

Both clusters are on the same network, both have HDP running. What's the most efficient way to migrate existing Hive data to the new cluster. Thanks.

Re: Hive migration to a new cluster & Hive metastore database change from MySQL to Oracle

PranayV — Fri, 23 Feb 2018 12:32:57 GMT

@Raj B

If you have both the clusters up and running, you can export tables from one cluster to another using Hive import export commands if the databases are not very large.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport

Re: Hive migration to a new cluster & Hive metastore database change from MySQL to Oracle

Raj_B — Wed, 14 Mar 2018 09:10:12 GMT

@Pranay Vyas

The Hive Export/Import worked well for us. Thanks.