Sqoop import job has failed

Highlighted
Four Stars

Sqoop import job has failed

Hi Team,

I am connecting mapr sandbox where sqoop is installed. While connecting from Talend I am getting below error. Tried searching over forum but didnt find any answer. Most of the questions are unanswered. Really appreciate your help.

 

Starting job test at 00:58 03/09/2017.

[statistics] connecting to socket on port 3708
[statistics] connected
[WARN ]: org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
[WARN ]: org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
Note: \tmp\sqoop-inbmahapat20\compile\92f43e1bd2a2d11393a376b27613bdb1\EMPLOYEE.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
[WARN ]: mapreduce.Counters - Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
[WARN ]: mapreduce.Counters - Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
[ERROR]: org.apache.sqoop.tool.ImportTool - Error during import: Import job failed!
Exception in component tSqoopImport_2
java.lang.Exception: The Sqoop import job has failed. Please check the logs.
at hadoopproject.test_0_1.test.tSqoopImport_2Process(test.java:551)
at hadoopproject.test_0_1.test.tLibraryLoad_1Process(test.java:403)
at hadoopproject.test_0_1.test.runJobInTOS(test.java:825)
at hadoopproject.test_0_1.test.main(test.java:682)
[statistics] disconnected
Job test ended at 00:59 03/09/2017. [exit code=1]

Moderator

Re: Sqoop import job has failed

Hello,

Could you please indicate on which talend build version you got this issue? Talend V 6.4?

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: Sqoop import job has failed

It is 6.3 TOSBD.

Moderator

Re: Sqoop import job has failed

Hello,

What's your MapR and client environment? Did you use Addtional Argument in advanced settings of tSqoopImport component?

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: Sqoop import job has failed

Hi Sabrina,

I am using MapR-Sandbox-For-Hadoop-5.2.1 and mapr-client-5.2.0.39122GA-1.amd64.

Also I am able to login to sqoop shell. I have tried all permutation combination in talend but no luck so far.

 

Thanks for your help

 

Four Stars

Re: Sqoop import job has failed

Hello, i am also Facing the Same Problem. kinldy help

Error: [statistics] connecting to socket on port 3548 [statistics] connected [ERROR]: org.apache.hadoop.util.Shell - Failed to locate the winutils binary in the hadoop binary path java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries. at org.apache.hadoop.util.Shell.getQualifiedBinPath(Shell.java:367) at org.apache.hadoop.util.Shell.getWinUtilsPath(Shell.java:382) at org.apache.hadoop.util.Shell.(Shell.java:375) at org.apache.hadoop.util.StringUtils.(StringUtils.java:79) at org.apache.hadoop.fs.FileSystem$Cache$Key.(FileSystem.java:2806) at org.apache.hadoop.fs.FileSystem$Cache$Key.(FileSystem.java:2802) at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2668) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:371) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:170) at pratian.job_0_1.job.tSqoopImport_1Process(job.java:349) at pratian.job_0_1.job.runJobInTOS(job.java:663) at pratian.job_0_1.job.main(job.java:520) [WARN ]: org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable [WARN ]: org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration. Note: \tmp\sqoop-Sudhakar\compile\46b71e8e2ae2545002edff5bd8a06fa6\AddMemberFromUI.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. [WARN ]: org.apache.sqoop.mapreduce.JobBase - SQOOP_HOME is unset. May not be able to find all job dependencies. [WARN ]: org.apache.sqoop.mapreduce.db.TextSplitter - Generating splits for a textual index column. [WARN ]: org.apache.sqoop.mapreduce.db.TextSplitter - If your database sorts in a case-insensitive order, this may result in a partial import or duplicate records. [WARN ]: org.apache.sqoop.mapreduce.db.TextSplitter - You are strongly encouraged to choose an integral split column. Exception in component tSqoopImport_1 java.lang.Exception: The Sqoop import job has failed. Please check the logs. at pratian.job_0_1.job.tSqoopImport_1Process(job.java:389) at pratian.job_0_1.job.runJobInTOS(job.java:663) at pratian.job_0_1.job.main(job.java:520) [WARN ]: mapreduce.Counters - Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead [WARN ]: mapreduce.Counters - Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead [ERROR]: org.apache.sqoop.tool.ImportTool - Error during import: Import job failed! [statistics] disconnected

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