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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.