topic Re: Sqoop import command line in Talend Studio

Sqoop import command line

adeshpande2020 — Sat, 16 Nov 2024 04:52:12 GMT

I want to execute Sqoop command in Talend using tsystem; how to achieve this.

I want to import data from Mysql and with target directory as S3 bucket.

Basically I want to achieve following Sqoop command in Talend.

sqoop import -Dfs.s3a.access.key=$ACCES_KEY -Dfs.s3a.secret.key=$SECRET_KEY--connect jdbc:mysql:// --username $USER --password $PWD --table $TABLENAME --target-dir s3a://example-bucket/target-directory

Re: Sqoop import command line

fdenis — Tue, 27 Aug 2019 09:54:45 GMT

try tSystem

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/mdw6s1fJbAlR4WwQQv9PCw

be carefull if you are using TAC!!!

Re: Sqoop import command line

iamabhishek — Tue, 27 Aug 2019 12:55:57 GMT

@hpan
and what is the error that you are receiving during this, could you share that please.

Re: Sqoop import command line

fdenis — Tue, 27 Aug 2019 13:12:11 GMT

sometime you have to mix java and cmd escape char(\ / ' " or $) to have the right commande line.
try a simple one first.