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