Hello Fellow Sqoopers!
I’m having some trouble with Sqoop export and wanted to document my findings as the usual Google searching and Apache Sqoop docs aren’t helping.
I’m trying to export a Hive table (sequence file) from AWS EMR to AWS RDS(MySQL) and SQOOP is returning the following error. Please note, I am able to successfully sqoop-import from this MySQL Database into Hive!!!
$ sqoop-export \
--connect jdbc:mysql://<ip address>:<database-name> \
--username <username> \
--password <password> \
--table <table-name> \
ERROR tool.ExportTool: Encountered IOException running export job: java.net.ConnectException:
failed on connection exception: java.net.ConnectException: Connection refused;
For more details see: http://wiki.apache.org/hadoop/ConnectionRefused
-- Some environmental info from the Master Node (ie. internal IP):
$ hostname -I
$ telnet 172.31.47.117 8020
telnet: connect to address 172.31.47.117: Connection refused.
So of course I can see the cause of the problem. But why on earth is SQOOP-EXPORT trying to connect to itself on port 8020 and what can I do about it?
There is no port-configuration information to gleaned from $SQOOP_HOME/conf/sqoop-site.xml
Database and BI Developer