Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop import got stuck

Sqoop import got stuck

Explorer

Am trying to import data from netezza to hadoop using sqoop import. sqoop stucks at running job. Table has only 100 records.

Not even started map reduce 0%.

5 REPLIES 5

Re: Sqoop import got stuck

Mentor

Please post logs

Re: Sqoop import got stuck

Explorer

@Artem Ervits which path logs will be stored?

Re: Sqoop import got stuck

Expert Contributor

@Ram - Check your applicationId in sqoop output and then:

yarn logs -applicationId <application_XXXXXXXXXX_XXXX> and post it, please also post sqoop output.

Also if running on Sandbox - check that you don't have hanged YARN jobs occupying resosurces ( http://sandbox.hortonworks.com:8088/cluster/apps ). This as sandbox has limited resources and hanged jobs will block sqoop jobs from starting the map reduce phase.

Re: Sqoop import got stuck

New Contributor

Hi,

I am getting below error.

INFO mapreduce.Job: map 0% reduce 0% 16/10/03 20:37:55 INFO mapreduce.Job: Job job_1475506260696_0001 failed with state FAILED due to: Application application_1475506260696_0001 failed 2 times due to Error launching appattempt_1475506260696_0001_000002. Got exception: java.net.ConnectException: Call From tindthtoixd0038.timesgroup.com/10.150.237.123 to tindthtoixd0038.timesgroup.com:38660 failed on connection exception: java.net.ConnectException: Connection refused

Highlighted

Re: Sqoop import got stuck

New Contributor

Can you please re-verify connection details, sqoop is not able to connect to Netzza.