I want to copy data from one cluster to another by DISTCP or export/import. Problem is Cluster 1 has only one hive database HIVE1 whereas cluster 2 has 3 hive databases HIVE2, HIVE3, HIVE4.
All 3 databases in cluster2 shares same HMS.
I have to copy HIVE1 into HIVE2.
If i try to copy data from HIVE1 to HIVE2 then HMS will also copy which will make HIVE3 & HIVE4 unusable.
Can someone please provide a solution for this?