Migrating Hive database from Postgress to Mysql

[#1]

Hi All

We have our hive database on Postgress and wanted to migrate it to MySQL,

Is there any easy way to do it?

Thanks

[#2 · Accepted solution]

@KPG1 Here is a good post i found that describes the required steps to move postgres to mysql including a php to do the postgres to mysql conversion.

https://cloudera.ericlin.me/2016/10/hive-metastore-migration-from-embedded-postgres-to-mysql/

You may need to find a more modern tool for that conversion, but the process to dump, convert, and move metastores should be very similar.