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

Hive metastore MySQL to Postgres migration

New Contributor

We're migrating our cluster to new hardware. TBs of HDFS (/Data, /user & /apps/hive/warehouse) data transferred well to destination. Now, we need to move the Hive tables Metastore. There are 10s of DBs and each would have 100s of tables. The new cluster HIVE DB id Postgres and the older one is on MySQL. The specifications are as follows:

Ambari: 2.5.0.3 (Old), 2.6.1.5 (New)

HDP: 2.6.0.3 (Old), 2.6.4.0 (New)

HIVE DB: MySQL (Old), Postgres (New)

Issue: We don't have the DBs schema so that we can run again on new cluster. It would be very tedious to Create Table from one to another. Is there a way to import the metadata dump from one to another?

Please advise!

Thanks allot in advance!

Regards.

1 REPLY 1

Mentor

@Vikas Gupta

Unfortunately, there is no ready-made utility, you will have to look into external utilities for the database migration. Here is a good source of utilities you might need to test.

Converting from other Databases to PostgreSQL

Hope that helps