Sqoop Import job doesn't run when build and run as .bat file

One Star

Sqoop Import job doesn't run when build and run as .bat file

Hi all,
We are running several jobs in Talend and most of them have two steps: 1) HiveTruncate 2) SqoopImport

We are running the jobs two ways: in Talend; building the job in Talend to run the .bat file via command line.
We don't have issues running the HiveTruncate jobs but the SqoopImport is not working when we run the .bat file on command line and we have the same issue in Talend. Below the error that we are receiving:
Exception in component tSqoopImport_1
java.lang.Exception: The Sqoop import job has failed. Please check the logs.
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.tSqoopImport_1Process(E_JDE812_PRODDTA_F0116.java:1068)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.tHiveRow_1Process(E_JDE812_PRODDTA_F0116.java:828)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.runJobInTOS(E_JDE812_PRODDTA_F0116.java:6559)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.main(E_JDE812_PRODDTA_F0116.java:6396)
: org.apache.sqoop.tool.ImportTool - Encountered IOException running import job: java.io.IOException: Job status not available
 at org.apache.hadoop.mapreduce.Job.updateStatus(Job.java:334)
 at org.apache.hadoop.mapreduce.Job.isComplete(Job.java:621)
 at org.apache.hadoop.mapreduce.Job.monitorAndPrintJob(Job.java:1366)
 at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1328)
 at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:196)
 at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:169)
 at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:266)
 at org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:729)
 at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:499)
 at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
 at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
 at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.tSqoopImport_1Process(E_JDE812_PRODDTA_F0116.java:1063)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.tHiveRow_1Process(E_JDE812_PRODDTA_F0116.java:828)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.runJobInTOS(E_JDE812_PRODDTA_F0116.java:6559)
 at etl_cls_dna.e_jde812_proddta_f0116_0_1.E_JDE812_PRODDTA_F0116.main(E_JDE812_PRODDTA_F0116.java:6396)

The main error ": org.apache.sqoop.tool.ImportTool - Encountered IOException running import job: java.io.IOException: Job status not available" is not providing enough information and we can't find anything relevant on the logs.
If anyone has faced this problem already could you please provide some feedback.
Thanks,
Sérgio
Moderator

Re: Sqoop Import job doesn't run when build and run as .bat file

Hi,
What's your JDK version?
Are you using the same java version for your hadoop cluster and talend studio?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.