Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sqoopimport from sql server failing due to connection refused error

Hello,
We are evaluating talend for hadoop(bigdata). I have hadoop cluster running with 5 nodes. I am able to run a oozie workflow connecting sql server and pulling the data to hdfs.
I am trying to create a job in talend for loading data from sqlserver to hadoop using tSqoopImport. All the connections and properties look completely fine as the job is getting deployed on the Oozie server and starts running but then fails due to java.net.connectExcpetion: connection refused.
I have attached an image of the error from oozie log.

Any help would be great.
Thanks
0683p000009MD9m.jpg
Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hello,
What connection type to you use? Command Line? Java API?
Anonymous
Not applicable
Author

Hi,
I am using java API and submitting talend job through oozie tab in designer.
I have been able to resolve the previous issue for connection refused error.
But I am now stumbled upon a new problem. namenode not in whitelist, not in oozies.
when I use the IPAddress in the oozie-site.xml talend is able to execute the job but when I use the hostname it fails with the namenode issue.
I cannot use IPAddress in Oozie-site.xml because then the workflow job fails on hue (OOzie editor) when I run from there.
In a nutshell, using IPAddress oozie job in talend gets executed but fails on hue(oozie editor) and using hostname fails in talend but gets executed in oozie editor(hue).
Any ideas?