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

[#1]

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.

[#2 · Accepted solution]

@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

[#3]

@Pranay Vyas

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