https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162827#M53537 <P>Here's an updated <A target="_blank" href="http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_data-movement-and-integration/content/index.html">Falcon doc link for HDP 2.5.3</A>.</P> Wed, 08 Feb 2017 02:34:38 GMT bandalora 2017-02-08T02:34:38Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162824#M53534 <P>What is the best practice to copy data and hive managed and external tables from one cluster to another?</P><P>Any good tools for that to automate process or scripts to validate the data?</P> Tue, 07 Feb 2017 06:48:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162824#M53534 pmj 2017-02-07T06:48:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162825#M53535 <P><A rel="user" href="https://community.cloudera.com/users/14451/pjalleda.html" nodeid="14451">@PJ</A> </P><P>i think we have two option for moving data from Cluster to Cluster</P><P>1) Distcp --this is basic and more conman method for moving the data</P><P> <A href="https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_Sys_Admin_Guides/content/ref-4d13c401-c638-44f3-a3a2-6b6aa89c86c6.1.html" target="_blank">https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_Sys_Admin_Guides/content/ref-4d13c401-c638-44f3-a3a2-6b6aa89c86c6.1.html</A></P><P>2) Falcon --Falcon is another option and we will get nice GUI and we can scheduler the jobs as well. but backend falcon is also running on Distcp. </P><P> <A href="https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-.3.0/bk_data_governance/content/ch_hdp_data_governance_overview.html#falcon_overview" target="_blank">https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-.3.0/bk_data_governance/content/ch_hdp_data_governance_overview.html#falcon_overview</A></P><P>I hope this will help you:)</P> Tue, 07 Feb 2017 07:33:42 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162825#M53535 divakarreddy_a 2017-02-07T07:33:42Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162826#M53536 <A rel="user" href="https://community.cloudera.com/users/14451/pjalleda.html" nodeid="14451">@PJ</A><P>Please have a look at below threads</P><P><A href="https://community.hortonworks.com/questions/8597/how-to-replicate-all-hive-ddl-and-database-from-on.html" target="_blank">https://community.hortonworks.com/questions/8597/how-to-replicate-all-hive-ddl-and-database-from-on.html</A></P><P><A href="https://community.hortonworks.com/questions/4496/how-to-migrate-hive-data-over-to-new-cluster.html" target="_blank">https://community.hortonworks.com/questions/4496/how-to-migrate-hive-data-over-to-new-cluster.html</A></P><P>Hope this helps!</P> Tue, 07 Feb 2017 14:22:50 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162826#M53536 KuldeepK 2017-02-07T14:22:50Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162827#M53537 <P>Here's an updated <A target="_blank" href="http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_data-movement-and-integration/content/index.html">Falcon doc link for HDP 2.5.3</A>.</P> Wed, 08 Feb 2017 02:34:38 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Best-practice-to-copy-data-and-tables-from-one-cluster-to/m-p/162827#M53537 bandalora 2017-02-08T02:34:38Z