tsqoopimport for oracle

Anonymous — Sat, 16 Nov 2024 08:41:06 GMT

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

Re: tsqoopimport for oracle

Anonymous — Mon, 26 Feb 2018 06:21:37 GMT

Hello,

Which version and edition of Talend are you using? What's your hadoop version?

Best regards

Sabrina

Re: tsqoopimport for oracle

Anonymous — Mon, 26 Feb 2018 08:15:14 GMT

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

topic tsqoopimport for oracle in Talend Studio

tsqoopimport for oracle

Re: tsqoopimport for oracle

Re: tsqoopimport for oracle