问题
sqoop 执行import或者export时候,出现错误。
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.
解决
1.原命令:
sqoop import --connect jdbc:mysql://localhost:8080/bigdata_db --username root --password 123456 --target-dir /sqoop --table tb_goods --m 1
- 修改后命令:
sqoop import --connect jdbc:mysql://localhost:8080/bigdata_db --username root --password 123456 --target-dir /sqoop --table tb_goods --driver com.mysql.jdbc.Driver --m 1
加上- -driver com.mysql.jdbc.Driver
参考 https://blog.csdn.net/weixin_46307660/article/details/123384921