Importing a MySQL table to HDFS - 7.3

Sqoop

EnrichVersion
Cloud
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Database tools > Sqoop components
Data Quality and Preparation > Third-party systems > Database tools > Sqoop components
Design and Development > Third-party systems > Database tools > Sqoop components

For more technologies supported by Talend, see Talend components.

This scenario illustrates how to use tSqoopImport to import a MySQL table to a given HDFS system.

The sample data to be used in this scenario reads as follows:
id,wage,mod_date
0,2000,2008-06-26 04:25:59
1,2300,2011-06-12 05:29:45
2,2500,2007-01-15 11:59:13
3,3000,2010-05-02 15:34:05
				

The data is stored in a MySQL table called sqoopmerge.

Before starting to replicate this scenario, ensure that you have appropriate rights and permissions to access the Hadoop distribution to be used. Then proceed as follows: