Sqoop import command line

[adeshpande2020]

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

[fdenis]

try tSystem

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

be carefull if you are using TAC!!!

[iamabhishek]

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

[fdenis]

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