question Re: 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. in Archives of Support Questions (Read Only)

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.

omkarmotoe — Tue, 26 Apr 2016 13:30:03 GMT

Re: 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.

rbiswas1 — Fri, 06 May 2016 11:49:36 GMT

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

Re: 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.

rbiswas1 — Fri, 06 May 2016 23:10:40 GMT

@omkar pathallapalli

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

Thanks