Re: moving hadoop and hive tables with its table structure and schema to new hadoop cluster

Hi , Yes. The hdfs data under /user/hive/warehouse can be migrated to new cluster using distcp.. But what about the hive table structures which are stored in my sql metastore? how to load hive table definitions to new mysql database and again then link that new mysqlschema to data in

RE: moving hadoop and hive tables with its table structure and schema to new hadoop cluster

Hi Distcp can be used for same…DistCp is a tool used for large inter/intra-cluster copying. References: http://hadoop.apache.org/docs/stable/hadoop-distcp/DistCp.html https://www.cloudera.com/documentation/enterprise/5-3-x/topics/cdh_admin_distcp_data_cluster_migrate.html