Question: how to transfer data from one database to another database in hive?
Answer: Get the Hive DDL from the source metastore. On the source cluster run the following command, saving the output to a file: ... 
Run the saved DDL on the target cluster/Workbench. ... 
Find the HDFS path to the data in the Warehouse. ... 
Run the distcp command to perform the data copy. ... 
Repair the target table.