Sqoop:ERROR manager.SqlManager:从数据库读取错误:java.sql.SQLException:

当我尝试使用Sqoop将数据从mysql导入HDFS并运行以下命令时

sqoop import –connect jdbc:mysql://IP Address/database name
–username root –password password –table table name –m 1

我收到以下错误

ERROR manager.SqlManager: Error reading from database:
java.sql.SQLException: Streaming result set
com.mysql.jdbc.RowDataDynamic@555b6c34 is still active. No statements
may be issued when any streaming result sets are open and in use on a
given connection. Ensure that you have called .close() on any active
streaming result sets before attempting more queries.

我无法理解它是什么,并浏览了许多网站的解决方案,但甚至没有得到线索.

请建议.

解决方法:

尝试提一下驱动程序名称,它对我有用

--driver com.mysql.jdbc.Driver 

为我工作.谢谢.

上一篇:URL Schemes(转载)


下一篇:sqoop job --exec sojob报错:ERROR hive.HiveConfig: Could not load