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: 220.127.116.11 (Old), 18.104.22.168 (New)
HDP: 22.214.171.124 (Old), 126.96.36.199 (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?