Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am not able to load data into HDFS using tsqoopimport component from Oracle DB.
Below is an error:-
[ERROR]: org.apache.sqoop.tool.ImportTool - Import failed: 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:203)
at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:176)
at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:273)
at org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:748)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:515)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:621)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at local_project.tsqoopimport_0_1.tsqoopimport.tSqoopImport_1Process(tsqoopimport.java:536)
at local_project.tsqoopimport_0_1.tsqoopimport.tLibraryLoad_1Process(tsqoopimport.java:379)
at local_project.tsqoopimport_0_1.tsqoopimport.runJobInTOS(tsqoopimport.java:822)
at local_project.tsqoopimport_0_1.tsqoopimport.main(tsqoopimport.java:671)
Exception in component tSqoopImport_1 (tsqoopimport)
java.lang.Exception: The Sqoop import job has failed. Please check the logs.
at local_project.tsqoopimport_0_1.tsqoopimport.tSqoopImport_1Process(tsqoopimport.java:540)
at local_project.tsqoopimport_0_1.tsqoopimport.tLibraryLoad_1Process(tsqoopimport.java:379)
at local_project.tsqoopimport_0_1.tsqoopimport.runJobInTOS(tsqoopimport.java:822)
at local_project.tsqoopimport_0_1.tsqoopimport.main(tsqoopimport.java:671)
[statistics] disconnected
Job tsqoopimport ended at 14:35 16/02/2018. [exit code=1]
Any lead would be appreciated..!!
Thanks
Rupesh
+917597415520
Hello,
Which version and edition of Talend are you using? What's your hadoop version?
Here is a related article about:https://stackoverflow.com/questions/29620778/java-io-ioexception-job-status-not-available-about-hive.
Best regards
Sabrina
Hi,
I am using Talend 6.4 for Big Data. And Hadoop is cloudera 5.5.
The link is not useful in my case. I am not able to understand, what is the exact error. i have tried a no of things to resolve it but nothing helped me out.
Thanks
Rupesh Gupta