Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop jobs are not running

Rising Star

I am trying to run sqoop job but it is getting stuck without throwing an error. I am unable to see any yarn logs from this sqoop job.

What can I do to identify the issue here.

Last part of the Log lookslike below:

16/09/13 05:05:35 INFO db.DBInputFormat: Using read commited transaction isolation 16/09/13 05:05:35 DEBUG db.DataDrivenDBInputFormat: Creating input split with lower bound '1=1' and upper bound '1=1' 16/09/13 05:05:35 INFO mapreduce.JobSubmitter: number of splits:1 16/09/13 05:05:35 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1473064502809_0029 16/09/13 05:05:36 INFO impl.YarnClientImpl: Submitted application application_1473064502809_0029 16/09/13 05:05:36 INFO mapreduce.Job: The url to track the job: http://**********/proxy/application_1473064502809_0029/ 16/09/13 05:05:36 INFO mapreduce.Job: Running job: job_1473064502809_0029


Super Guru

@Gaurab D

Can you please share logs for the job? There should be more info you can find either in Ambari or just look under /var/log/sqoop folder or may be /var/log/yarn

View solution in original post


Rising Star

I can see below state of the job from Yarn UI

YarnApplicationState:ACCEPTED: waiting for AM container to be allocated, launched and register with RM.
FinalStatus Reported by AM:Application has not completed yet.


Then it means that no resources are available at the moment to launch your job. Check the current use of your queue, the parameters of the queue, what are the resources you requested, etc.