Importing a MySQL table to HDFS - Cloud - 8.0

Sqoop

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database tools > Sqoop components
Data Governance > Third-party systems > Data management components > Data movement > Sqoop components
Data Quality and Preparation > Third-party systems > Database tools > Sqoop components
Data Quality and Preparation > Third-party systems > Data management components > Data movement > Sqoop components
Design and Development > Third-party systems > Database tools > Sqoop components
Design and Development > Third-party systems > Data management components > Data movement > Sqoop components
Last publication date
2024-02-20

This scenario applies only to Talend products with Big Data.

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: