Sqoop报错记录

来源：互联网发布：阿尔法淘宝宝贝下载编辑：程序博客网时间：2024/05/21 08:02

1，在进行从MySql到hive的数据导入时，出现如下错误：

Streaming result set com.mysql.jdbc.RowDataDynamic@7c30e29c 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.at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1521)at com.mysql.jdbc.ConnectionImpl.getMaxBytesPerChar(ConnectionImpl.java:3003)at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:602)at com.mysql.jdbc.ResultSetMetaData.getPrecision(ResultSetMetaData.java:445)

这好像是MySql的问题，挺多人在写代码时没有把之前的连接close掉，但是MySql一次只允许一个连接，所以出现错误。

解决办法：把$SQOOP_HOME/lib下面原来的mysql-connector-java-5.0.8-bin.jar替换为mysql-connector-java-5.1.33-bin.jar

0 0