Sqoop: ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Sqoop: ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: hadoop hadoop

Sqoop: ERROR manager.SqlManager: Error reading from database: java.sql.SQLException:


Try mentioning driver name, It worked for me

--driver com.mysql.jdbc.Driver 

Worked for me. Thankyou.


a quick google search on your exception gives me an impression that this was a bug reported in sqoop. It looks like they have resolved it. Please look at this https://issues.apache.org/jira/browse/SQOOP-1400.

Verify your sqoop and mysql connector version and update to newer version if required. Thanks.


My issue was resolved after using:

--driver com.mysql.jdbc.Driver

in sqoop script.

e.g.

sqoop import --connect jdbc:mysql://IP Address/database name --username root --password password --table table name --m 1 --driver com.mysql.jdbc.Driver