Snowflake java.io.IOException: Error processing query

[kenczq]

Hi all, I am currently encountering an issue when I run a Talend Job that read a query from Snowflake which is able to run in my local PC Talend but not in a Remote Engine that I have connected in Talend Portal. Here is the log:

tDBInput_1 Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
java.io.IOException: Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
    at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:138)
    at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
    at fpi_dw.tcurr_0_1.TCURR.tDBInput_1Process(TCURR.java:3704)
    at fpi_dw.tcurr_0_1.TCURR.tDBRow_1Process(TCURR.java:2622)
    at fpi_dw.tcurr_0_1.TCURR.runJobInTOS(TCURR.java:7710)
    at fpi_dw.tcurr_0_1.TCURR.main(TCURR.java:7142)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:243)
    at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:131)
    at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:135)
    ... 5 more

From my PC, works perfectly:

Talend Portal:

Appreciate with any advice and feedback, thank you!

[Shicong_Hong]

Hello

It looks like a Java issue. If the Remote Engine runs with Java 17, you have to install the 8.0 R2023-10 Talend Studio monthly update or a later one, and re-build the jobs using Java 17, please read the Pay attention to the following before working with Java 17 section in this documentation page.

Regards

Shicong