Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Expert Contributor

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

avatar
Super Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
Super Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Expert Contributor

@Pranay Vyas

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