Support Questions
Find answers, ask questions, and share your expertise

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.

Contributor
 
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

View solution in original post

2 REPLIES 2

@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

@omkar pathallapalli

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

Thanks

; ;