当我尝试使用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
为我工作.谢谢.