tsqoopimport for oracle

Four Stars

tsqoopimport for oracle

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

Moderator

Re: tsqoopimport for oracle

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tsqoopimport for oracle

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