Migrating Hive database from Postgress to Mysql

KPG1 — Thu, 08 Dec 2022 09:12:48 GMT

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

Re: Migrating Hive database from Postgress to Mysql

steven-matison — Fri, 09 Dec 2022 13:36:32 GMT

@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.

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.