分享

sqoop导入报错

使用sqoop时,有时会报这种错:
17/09/05 15:02:19 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter
乍一看猜测时sqoop脚本的问题,或者是mysql的jdbc包版本问题,实则不然
17/09/05 15:02:19 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@55634720 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.
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@55634720 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.

有些维表在同步时若是有其他程序正在增删改这张表会出现这个错,同样的sqoop脚本换张表就能跑通,那张一直会变化的维表则同步报错,偶尔也会遇到

没找到任何评论,期待你打破沉寂

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条