topic tSqoopImport ERROR cannot find the file in Talend Studio

tSqoopImport ERROR cannot find the file

Anonymous — Sat, 16 Nov 2024 12:03:29 GMT

Hi all,
i get this error when running a simple job with tSqoopImport component.
Exception in component tSqoopImport_1
java.io.IOException: Cannot run program "sqoop": CreateProcess error=2, The system cannot find the file specified
I specified the necessary parameters.
=> general parameter
connexion :"jdbc racle:thin:@//dwdv:1511/dbdev"
utilisateur: "user"
mot de passe : "pass"
nom de la table: "tablename"
=>advanced parameter
the columns, targetdir and the split by.
my database is Oracle as shown.
in the parameter "Connexion", do you have idea about the structure of ORACLE connection? "jdbc racle:thin..." ?
thanks!

Re: tSqoopImport ERROR cannot find the file

Anonymous — Thu, 18 Apr 2013 03:30:02 GMT

Hi
The error indicates it can't find the program sqoop, ensure that you have Sqoop installed in the host used to run this component and ensure as well that you have added the Sqoop command line to the PATH variable of this host.

in the parameter "Connexion", do you have idea about the structure of ORACLE connection? "jdbcracle:thin..." ?

For Oracle DB, the connection string looks like:
"jdbc racle:thin:@host_ip:1521:database_name"
Shong

Re: tSqoopImport ERROR cannot find the file

Anonymous — Fri, 19 Apr 2013 09:35:59 GMT

Hi,
thank you for answering
I added the two envi var
SQOOP_HOME: C:\Hadoop\sqoop-1.4.2
PATH : C:\Hadoop\sqoop-1.4.2\bin
but still didn't work!!!!!!
error:
Exception in component tSqoopImport_1
java.io.IOException: Cannot run program "sqoop": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.tSqoopImport_1Process(ChargerDansHDFS.java:314)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.runJobInTOS(ChargerDansHDFS.java:783)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.main(ChargerDansHDFS.java:651)
from the console, sqoop commad work successfully..