iam triying to load data from mysql to hdfs on localdomian error is 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.

[#1 · Accepted solution]

@omkar pathallapalli

This issue should be resolved by adding --driver com.mysql.jdbc.Driver at the end of the sqoop command.

For example:

sqoop import --connect $DB_CONNECTION --username $DB_USERNAME --password $DB_PASSWORD --table salaries --target-dir /tmp/salaries --outdir sqoop_import -m -1 --fields-terminated-by ',' --driver com.mysql.jdbc.Driver

Thanks

[#2]

@omkar pathallapalli

Let us know if the solution I posted worked for you.

Thanks