Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

When I am trying to import data from mysql to HDFS using Sqoop and running the following command

sqoop import --connect jdbc:mysql://IP Address/database name --username root --password password --table table name --m 1

I am getting the below error

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@555b6c34 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.

I am unable to understand what it is and browsed many websites for solutions but did not even got a clue.

Please suggest.

a quick google search on your exception gives me an impression that this was a bug reported in sqoop. It looks like they have resolved it. Please look at this https://issues.apache.org/jira/browse/SQOOP-1400 .

Verify your sqoop and mysql connector version and update to newer version if required. Thanks.

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question . Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers .