topic Re: Loading data to redshift using tRedshiftOutputBulkExec - aws jdk compilation errors in Talend Studio

Loading data to redshift using tRedshiftOutputBulkExec - aws jdk compilation errors

Anonymous — Sat, 16 Nov 2024 07:37:53 GMT

Talend Open Studio for Data Integration
Version: 7.0.1

I'm creating a simple job to source data from Aurora RDS (MySQL) and load data into Redshift using the tRedshiftOutputBulkExec component, but am hitting compilation errors.

org.talend.designer.runprocess.ProcessorException: Job compile errors 
At least job "aurora_2_redshift" has a compile errors, please fix and export again.
Error Line: 6904
Detail Message: com.amazonaws cannot be resolved to a type
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Modules shows the AWS Java JDK is installed.

mvn:com.amazonaws/aws-java-sdk/1.11.269/jar

Code shows that "com.amazonaws cannot be resolved to a type"

I tried to import "com.amazonaws.*" by using the tLibrary component, but the code says "The import com.amazonaws cannot be resolved.

How do I import the "com.amazonaws" package into my project?

Re: Loading data to redshift using tRedshiftOutputBulkExec - aws jdk compilation errors

Anonymous — Fri, 21 Sep 2018 10:19:51 GMT

Hello,

It seems that this jar file is not loaded successfully.

Did you try to add aws-java-sdk-x.xx.xx jar to talend via the modules window? After you click the "Code " to see the generate code, is the jar "aws-java-sdk-x.xx.xx" included the lib?

Best regards

Sabrina

Re: Loading data to redshift using tRedshiftOutputBulkExec - aws jdk compilation errors

Anonymous — Tue, 25 Sep 2018 18:24:15 GMT

I wasn't able to fix/reload the AWS SDK. I reinstalled TOS and was able to install the AWS SDK module successfully. Not sure what went wrong the first time, but now it's working.

Thanks,

Hugo

Re: Loading data to redshift using tRedshiftOutputBulkExec - aws jdk compilation errors

Anonymous — Wed, 26 Sep 2018 04:48:21 GMT

Hello Hugo,

Great it is working now. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina