https://community.cloudera.com/t5/Archives-of-Support-Questions/Migrate-Hive-Metastore-from-Postgres-to-MySQL/m-p/193816#M62161 <P>Hi, </P><P>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??</P> Thu, 01 Jun 2017 13:52:12 GMT brajeshreddy 2017-06-01T13:52:12Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Migrate-Hive-Metastore-from-Postgres-to-MySQL/m-p/193816#M62161 <P>Hi, </P><P>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??</P> Thu, 01 Jun 2017 13:52:12 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Migrate-Hive-Metastore-from-Postgres-to-MySQL/m-p/193816#M62161 brajeshreddy 2017-06-01T13:52:12Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Migrate-Hive-Metastore-from-Postgres-to-MySQL/m-p/193817#M62162 <P>followed this link and it worked. </P><P><A href="http://www.ericlin.me/hive-metastore-migration-from-embedded-postgres-to-mysql" target="_blank">http://www.ericlin.me/hive-metastore-migration-from-embedded-postgres-to-mysql</A></P> Thu, 01 Jun 2017 16:30:06 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Migrate-Hive-Metastore-from-Postgres-to-MySQL/m-p/193817#M62162 brajeshreddy 2017-06-01T16:30:06Z