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 …