Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.

avatar
Rising Star
 
1 ACCEPTED SOLUTION

avatar

@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

View solution in original post

2 REPLIES 2

avatar

@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

avatar

@omkar pathallapalli

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

Thanks