question Re: Connection refused - when loading data from MySQL to HDFS using sqoop2 in Archives of Support Questions (Read Only)

Connection refused - when loading data from MySQL to HDFS using sqoop2

VarunR — Tue, 21 Apr 2026 14:00:20 GMT

Getting this error.

Error: java.net.ConnectException: Call From server1.cvrunner.com/158.85.75.36 to localhost:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused

Created connection on linux in sqoop2 shell. THe connection passed. MySQL is up and running.

When i created a job on Hue and tried to run the job. I am getting this error.

Not sure it is connectivity to MySQL or something else

Can anybody suggest me?

Re: Connection refused - when loading data from MySQL to HDFS using sqoop2

abe — Thu, 30 Oct 2014 01:03:30 GMT

It sounds like your core-site.xml on the node running the Sqoop server isn't configured properly. Does the node running Sqoop2 server have /etc/hadoop/conf/core-site.xml? If not, could you try copying your clients /etc/hadoop/conf to the node running Sqoop2 server?

So, your problem should be rectifiable more easily in Sqoop 1.99.4 (CDH 5.3.0). See https://issues.apache.org/jira/browse/SQOOP-1620 for more details.

Re: Connection refused - when loading data from MySQL to HDFS using sqoop2

VarunR — Thu, 30 Oct 2014 01:48:25 GMT

Both the components are on the same server.

I am using CDH 4.7 and sqoop2.

Re: Connection refused - when loading data from MySQL to HDFS using sqoop2

abe — Thu, 30 Oct 2014 20:08:03 GMT

Is server1.cvrunner.com your machine? If so, core-site.xml might not be configured properly. Could you try adding a property:

  <property>
    <name>fs.defaultFS</name>
    <value>hdfs://server1.cvrunner.com:8020</value>
  </property>

Re: Connection refused - when loading data from MySQL to HDFS using sqoop2

VarunR — Fri, 31 Oct 2014 01:51:38 GMT

Yes...

Re: Connection refused - when loading data from MySQL to HDFS using sqoop2

VarunR — Fri, 31 Oct 2014 16:24:41 GMT

Thanks Abe. It worked.

There are 2 changes I did.

1. changing from localhost to actual server name

2. Giving permission to Hue user to create the files on hdfs using "hadoop fs -R -chown" command.