Summary of Sqoop problems

1. SqoopImportMySQLData Error

The following error occurred when importing mysql data with sqoop :

14/12/03 16:37:58 error manager. sqlmanager: error reading from database: java.sql.sqlexception: streaming  Result set [email protected] 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 [email protected] is still active. No statements may issued if any streaming result sets is open and in use on a given connection. Ensure that there are called. Close () on any active streaming result sets before attempting more queries.

At Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:930)

At Com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData (mysqlio.java:2694)

At Com.mysql.jdbc.MysqlIO.sendCommand (mysqlio.java:1868)

At Com.mysql.jdbc.MysqlIO.sqlQueryDirect (mysqlio.java:2109)

At Com.mysql.jdbc.ConnectionImpl.execSQL (connectionimpl.java:2642)

At Com.mysql.jdbc.ConnectionImpl.execSQL (connectionimpl.java:2571)

At Com.mysql.jdbc.StatementImpl.executeQuery (statementimpl.java:1464)

At Com.mysql.jdbc.ConnectionImpl.getMaxBytesPerChar (connectionimpl.java:3030)

At Com.mysql.jdbc.Field.getMaxBytesPerCharacter (field.java:592)

At Com.mysql.jdbc.ResultSetMetaData.getPrecision (resultsetmetadata.java:444)

At Org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery (sqlmanager.java:285)

At Org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery (sqlmanager.java:240)

At Org.apache.sqoop.manager.SqlManager.getColumnTypes (sqlmanager.java:226)

At Org.apache.sqoop.manager.ConnManager.getColumnTypes (connmanager.java:295)

At Org.apache.sqoop.orm.ClassWriter.getColumnTypes (classwriter.java:1773)

At Org.apache.sqoop.orm.ClassWriter.generate (classwriter.java:1578)

At Org.apache.sqoop.tool.CodeGenTool.generateORM (codegentool.java:96)

At Org.apache.sqoop.tool.ImportTool.importTable (importtool.java:478)

At Org.apache.sqoop.tool.ImportTool.run (importtool.java:601)

At Org.apache.sqoop.Sqoop.run (sqoop.java:143)

At Org.apache.hadoop.util.ToolRunner.run (toolrunner.java:65)

At Org.apache.sqoop.Sqoop.runSqoop (sqoop.java:179)

At Org.apache.sqoop.Sqoop.runTool (sqoop.java:218)

At Org.apache.sqoop.Sqoop.runTool (sqoop.java:227)

At Org.apache.sqoop.Sqoop.main (sqoop.java:236)

14/12/03 16:37:58 ERROR tool. importtool:encountered IOException Running Import job:java.io.IOException:No columns to generate for Classwriter

At Org.apache.sqoop.orm.ClassWriter.generate (classwriter.java:1584)

At Org.apache.sqoop.tool.CodeGenTool.generateORM (codegentool.java:96)

At Org.apache.sqoop.tool.ImportTool.importTable (importtool.java:478)

At Org.apache.sqoop.tool.ImportTool.run (importtool.java:601)

At Org.apache.sqoop.Sqoop.run (sqoop.java:143)

At Org.apache.hadoop.util.ToolRunner.run (toolrunner.java:65)

At Org.apache.sqoop.Sqoop.runSqoop (sqoop.java:179)

At Org.apache.sqoop.Sqoop.runTool (sqoop.java:218)

At Org.apache.sqoop.Sqoop.runTool (sqoop.java:227)

At Org.apache.sqoop.Sqoop.main (sqoop.java:236)

This is due to the Mysql-connector-java bug , I use the error Mysql-connector-java-5.1.10-bin.jar, updated to Mysql-connector-java-5.1.32-bin.jar on it. Mysql-connector-java-5.1.32-bin.jar for http://dev.mysql.com/get/Downloads/. Connector-j/mysql-connector-java-5.1.32.tar.gz. After downloading the extract, in the extracted directory can be found mysql-connector-java-5.1.32-bin.jar.

Sqoop Problem Summary