vikasgbiz
New Contributor

Re: Migrate Hive Metastore from MySQL to Postgres

by New Contributor in Support Questions
‎06-05-2018 12:05 AM
‎06-05-2018 12:05 AM
Hi @Rinku Singh, @Sindhu, We're migrating our cluster to new hardware. TBs of HDFS (/Data, /user & /apps/hive/warehouse) data transferred well to destination. Now, we need to move the Hive tables Metastore. There are 10s of DBs and each would have 100s of tables. The specifications are as follows: Ambari: 2.5.0.3 (Old), 2.6.1.5 (New) HDP: 2.6.0.3 (Old), 2.6.4.0 (New) HIVE DB: MySQL (Old), Postgres (New) Issue: We don't have the DBs schema so that we can run again on new cluster. It would be very tedious to Create Table from one to another. Is there a way to import the metadata dump from one to another? Please advise! Thanks allot in advance! Regards. ... View more

Hive metastore MySQL to Postgres migration

by New Contributor in Support Questions
‎06-04-2018 07:44 PM
‎06-04-2018 07:44 PM
We're migrating our cluster to new hardware. TBs of HDFS (/Data, /user & /apps/hive/warehouse) data transferred well to destination. Now, we need to move the Hive tables Metastore. There are 10s of DBs and each would have 100s of tables. The new cluster HIVE DB id Postgres and the older one is on MySQL. The specifications are as follows: Ambari: 2.5.0.3 (Old), 2.6.1.5 (New) HDP: 2.6.0.3 (Old), 2.6.4.0 (New) HIVE DB: MySQL (Old), Postgres (New) Issue: We don't have the DBs schema so that we can run again on new cluster. It would be very tedious to Create Table from one to another. Is there a way to import the metadata dump from one to another? Please advise! Thanks allot in advance! Regards. ... View more
Labels:

Hive metastore MySQL to Postgres migration

by New Contributor in Support Questions
‎06-04-2018 07:43 PM
‎06-04-2018 07:43 PM
We're migrating our cluster to new hardware. TBs of HDFS (/Data, /user & /apps/hive/warehouse) data transferred well to destination. Now, we need to move the Hive tables Metastore. There are 10s of DBs and each would have 100s of tables. The new cluster HIVE DB id Postgres and the older one is on MySQL. The specifications are as follows: Ambari: 2.5.0.3 (Old), 2.6.1.5 (New) HDP: 2.6.0.3 (Old), 2.6.4.0 (New) HIVE DB: MySQL (Old), Postgres (New) Issue: We don't have the DBs schema so that we can run again on new cluster. It would be very tedious to Create Table from one to another. Is there a way to import the metadata dump from one to another? Please advise! Thanks allot in advance! Regards. ... View more
Labels:

Re: Migrate Hive Metastore from MySQL to Postgres

by New Contributor in Support Questions
‎05-26-2018 10:45 PM
‎05-26-2018 10:45 PM
Hi @Rinku Singh, @Sindhu, We're migrating our cluster to new hardware. TBs of HDFS (/Data, /user & /apps/hive/warehouse) data transferred well to destination. Now, we need to move the Hive tables Metastore. There are 10s of DBs and each would have 100s of tables. The specifications are as follows: Ambari: 2.5.0.3 (Old), 2.6.1.5 (New) HDP: 2.6.0.3 (Old), 2.6.4.0 (New) HIVE DB: MySQL (Old), Postgres (New) Issue: We don't have the DBs schema so that we can run again on new cluster. It would be very tedious to Create Table from one to another. Is there a way to import the metadata dump from one to another? Please advise! Thanks allot in advance! Regards. ... View more
Contact Me
Online
Offline
Last Visited
‎10-29-2018 09:35 PM
Public Statistics
Date Registered ‎12-13-2017 03:57 AM
Last Visited ‎10-29-2018 09:35 PM
Total Messages Posted 4