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

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