Sqoop import hangs while importing data from mysql


#1

Hello,

While importing data from mysql to hadoop, the process is getting hanged after following step

20/01/21 11:16:09 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM pkwidgets AS t LIMIT 1
20/01/21 11:16:09 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM pkwidgets AS t LIMIT 1
20/01/21 11:16:09 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.6.2.0-205/hadoop-mapreduce
Note: /tmp/sqoop-pratik58892973/compile/c57fcc4091526fd367536b605e038c40/pkwidgets.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
20/01/21 11:16:11 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-pratik58892973/compile/c57fcc4091526fd367536b605e038c40/pkwidgets.jar
20/01/21 11:16:11 WARN manager.MySQLManager: It looks like you are importing from mysql.
20/01/21 11:16:11 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
20/01/21 11:16:11 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
20/01/21 11:16:11 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
20/01/21 11:16:11 INFO mapreduce.ImportJobBase: Beginning import of pkwidgets
20/01/21 11:16:12 INFO client.RMProxy: Connecting to ResourceManager at cxln2.c.thelab-240901.internal/10.142.1.2:8050
20/01/21 11:16:12 INFO client.AHSProxy: Connecting to Application History server at cxln2.c.thelab-240901.internal/10.142.1.2:10200

After the above step the import gets hanged and I have to press ctrl+c to exit

command which I’m executing is:
sqoop import --connect jdbc:mysql://10.142.1.2/retail_db --username sqoopuser --table pkwidgets --password NHkkP876rp --target-dir /user/
pratik58892973/sqoopprograms -m1

Kindly suggest


#2

It went further and now it is hanging and throwing following message

20/01/21 12:13:31 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1579606980611_0031
20/01/21 12:14:20 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1579606980611_0031 is still in NEW_SAVING
20/01/21 12:14:22 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1579606980611_0031 is still in NEW_SAVING


#3

This post was flagged by the community and is temporarily hidden.