Importing a MySQL table to HDFS (deprecated)
Information noteDeprecation: The Sqoop components are deprecated since the
7.3.1-R2021-06 release.
For more technologies supported by Talend, see Talend components.
This scenario applies only to Talend products with Big Data.
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: