Migrate Hive Metastore from Postgres to MySQL

[#1]

Hi,

Im running hdp 2.5 with ambari 2.4.1. Using Postgres as my hive metastore. I would like to migrate hive metastore from postgres to mysql. Is there any document or link available for this??

[#2 · Accepted solution]

followed this link and it worked.

http://www.ericlin.me/hive-metastore-migration-from-embedded-postgres-to-mysql