Hadoop and Spark developer course

Discussion in 'Other Courses & Certifications' started by _6214, Jun 27, 2017.

  1. _6214

    _6214 New Member

    Apr 4, 2017
    Likes Received:
    Hi TEam,

    I am facing issue while importing a table from mysql to HDFS usinf SQOOP.

    Please find below error :

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

    ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter

    SQOOP command I am using is :
    sqoop import --connect jdbc:mysql:// --username labuser --password simplilearn --table trade --target-dir /user/abhijitdharmadhikari06_gmail/data -m 1

    Please guide me to resolve this issue.

Share This Page