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.