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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now