We have our hive database on Postgress and wanted to migrate it to MySQL,
Is there any easy way to do it?
@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.
View solution in original post