Search code examples
javamysqlsqlhadoopsqoop

Sqoop: ERROR manager.SqlManager: Error reading from database: java.sql.SQLException:

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.

Solution

  • Try mentioning driver name, It worked for me

    --driver com.mysql.jdbc.Driver

    Worked for me. Thankyou.