Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tSqoopImport tHDFSPut

Hi everybody,
is there any simple scenario where we user the thow compoennts: tsqoopImport and tHDFSPut.
i want to store atable imported by sqoop on the HDFS.
Thank you! 😃
Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hi,
Here are component references with scenario tHDFSPut and tSqoopImport.
You can check the Sqoop database version and system supported by talend from here:https://help.talend.com/search/all?query=Supported+systems+and+databases&content-lang=en
Best regards
Sabrina
Anonymous
Not applicable
Author

Thank you Sabrina for answring.
my problem is that don't see the "connection" between tSqoopImport and the HDFS.
i looked at the tsqoopImport's properties and there are no directions to a HDFS location.
I'am a Hadoop newbie, it's new to me ^^"
Anonymous
Not applicable
Author

Hi
I believe you need to use the "advance tab" and add a parameter
--target-dir <dir>

Ciaran
Anonymous
Not applicable
Author

Hi,
In the version you use, talend uses the Sqoop CLI to execute a Sqoop job. That means the talend job has to be executed on the same server Sqoop is installed on. That's why we don't need a HDFS connection... Because the job is executed from the cluster directly.
It's a know limitation which is gonna be fixed in 5.3 with the ability to use the Java API.
HTH,
Rémy.
Anonymous
Not applicable
Author

Hi all,
i get this error when running a simple job with tSqoopImport component. I specified the necessary parameters.
general parameter
connexion :"jdbc 0683p000009MA5A.pngracle: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 0683p000009MA5A.pngracle:thin..." ?
thanks!