sqoop报错总结

• 缺少MYSQL JDBC驱动

ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class:
com.mysql.jdbc.Driver
java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver 解决办法：
将 mysql-connector-java-X.X.XX-bin.jar 复制到{安装目录}/sqoop/lib 文件夹下即可。

• MYSQL wait_timeout. 参数时长设置过短 或 mysql 地址出错

Error: java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commu
nications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the serv
er.

解决办法：
mysql上修改 wait_timeout 时长 或 将url中localhost修改为ip。