topic Re: sqoop import error in Talend Studio

sqoop import error

Anonymous — Sat, 16 Nov 2024 09:40:15 GMT

Hi,

I am trying to import mysql data to hortonworks using sqoop but below error keep me stuck . please help to resolve the issues. Talend version is 6.3.1

Note: /tmp/sqoop-root/compile/50736c6a6865232bd5a7349076cbe8e1/CustomersData.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
Exception in component tSqoopImport_1
java.lang.Exception: The Sqoop import job has failed. Please check the logs.
	at local_project.sqoopimport_0_1.SqoopImport.tSqoopImport_1Process(SqoopImport.java:538)
	at local_project.sqoopimport_0_1.SqoopImport.runJobInTOS(SqoopImport.java:842)
	at local_project.sqoopimport_0_1.SqoopImport.main(SqoopImport.java:676)


[ERROR]: org.apache.sqoop.tool.ImportTool - Imported Failed: Unable to parse '/hdp/apps/${hdp.version}/mapreduce/mapreduce.tar.gz#mr-framework' as a URI, check the setting for mapreduce.application.framework.path

Regards,

Arun

Re: sqoop import error

Anonymous — Thu, 08 Jun 2017 09:04:06 GMT

Hi, What's the actual version you are using? Screenshots of your component setting will be preferred. Best regards Sabrina

Re: sqoop import error

Anonymous — Thu, 08 Jun 2017 09:23:34 GMT

Hi Sabrina,

My Talend Version is 6.3.1 and Hortonworks Apache Ambari version is 2.4.2.0.

csv,tweet files can ingest and download but SQOOP is having problem.

Attached component settings snapshot

Re: sqoop import error

Anonymous — Sun, 24 Sep 2017 00:19:03 GMT

Hi Arun,

Check your HDP version and add this variable into jvm settings and run the same.

here is the sample value:

"-Dhdp.version=2.4.0.0-169"