topic Re: sqoopimport from sql server failing due to connection refused error in Talend Studio

sqoopimport from sql server failing due to connection refused error

Anonymous — Sat, 16 Nov 2024 11:44:05 GMT

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

Re: sqoopimport from sql server failing due to connection refused error

Anonymous — Sun, 02 Mar 2014 10:44:39 GMT

Hello,
What connection type to you use? Command Line? Java API?

Re: sqoopimport from sql server failing due to connection refused error

Anonymous — Sun, 02 Mar 2014 17:37:03 GMT

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?