Sqoop Error While import from MySQL - Communications link failure



0

Hello,

This looks like a common error. The scoop import on CDH4 failed while trying to import table data from MySQL. Can you please help?

Here's is part of the error message:

-----------------------

17/09/14 19:30:33 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/09/14 19:30:33 INFO tool.CodeGenTool: Beginning code generation
17/09/14 19:30:55 ERROR manager.SqlManager: Error executing statement: 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.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

------------------------

Thanks


1 Answer(s)


0

I turned off the firewall in my anti-virus software and it worked.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password