Using Sqoop to Import Data from MySQL to Cloudera Data Warehouse

Cloudera Data Warehouse offers a powerful combination of flexibility and cost-savings. Using Cloudera Data Warehouse, you can transform and optimize your current traditional data warehouse by moving select workloads to your CDH cluster. This article shows you how to transform your current setup into a modern data warehouse by moving some initial data over to Impala on your CDH cluster. Prerequisites To use the following data import scenario, you need the following: A moderate-sized CDH cluster that is managed by Cloudera Manager, which configures everything properly so you don't need to worry about Hadoop configurations. Your cluster setup should include a gateway host where you can connect to launch jobs on the cluster. This gateway host must have all the command-line tools installed on it, such as impala-shell and sqoop. Ensure that you have adequate permissions to perform the following operations on your remote CDH cluster and that the following software is installed there: Use secure shell to log in to a remote host in your CDH cluster where a Sqoop client is installed: ssh @ If you don't know the name of the host where the Sqoop client is installed, ask your cluster administrator.

✔ Read More...

I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

CDH,Sqoop,Data Warehouse,mysql