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脚本换张表就能跑通，那张一直会变化的维表则同步报错，偶尔也会遇到
页:
[1]