SQOOP job failure


#1

I have tried to execute the following sqoop jobs

sqoop import --connect jdbc:mysql://ip-172-31-13-154:3306/retail_db --username sqoopuser --password <> --table sales --fields-terminated-by “,” --target-dir /user/deepdd20123361/sqoopdata/d0 -m1

sqoop import --connect jdbc:mysql://ip-172-31-13-154:3306/sqoopex --username sqoopuser --password <> --table loan_info --fields-terminated-by “,” --target-dir /user/deepdd20123361/sqoopdata/d1 -m1

Both have failed with the following message. Please help me out.

19/02/08 05:20:48 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce
ption: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the
server.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the
server.

---- Now it is working … I have corrected the URL …