Support Questions
Find answers, ask questions, and share your expertise

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

Rising Star

Hello,

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

SourceTarget
Cluster A
Cluster B
HDP 2.5.3HDP 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.

1 ACCEPTED SOLUTION

Expert Contributor

@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

View solution in original post

2 REPLIES 2

Expert Contributor

@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

Rising Star

@Pranay Vyas

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

; ;