Member since
12-13-2017
4
Posts
0
Kudos Received
0
Solutions
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
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:
- Labels:
-
Apache Hive
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:
- Labels:
-
Apache Hive
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