From Talend8 connection to trino giving connection timeout

[MPadmanabhan]

While trying to connect to presto through Trino there is connection timeout error. Can someone help what is the driver and settings in Talend 8 for configuring Trino

Error

[FATAL] 15:25:49 esd.esd_fetch_3_0.ESD_Fetch- tDBInput_5 SQL_ERROR:{message=Error executing query}

org.talend.components.api.exception.ComponentException: SQL_ERROR:{message=Error executing query}

at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:643) ~[components-jdbc-definition-0.37.14.jar:?]

at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:259) ~[components-jdbc-runtime-0.37.14.jar:?]

at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73) ~[talend-codegen-utils.jar:?]

at esd.esd_fetch_3_0.ESD_Fetch.tLoop_2Process(ESD_Fetch.java:2526) [esd_fetch_3_0.jar:?]

at esd.esd_fetch_3_0.ESD_Fetch.tSetGlobalVar_5Process(ESD_Fetch.java:954) [esd_fetch_3_0.jar:?]

at esd.esd_fetch_3_0.ESD_Fetch$4.run(ESD_Fetch.java:4434) [esd_fetch_3_0.jar:?]

Caused by: java.sql.SQLException: Error executing query

at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:287) ~[trino-jdbc-362.jar:362]

at io.trino.jdbc.TrinoStatement.execute(TrinoStatement.java:240) ~[trino-jdbc-362.jar:362]

at io.trino.jdbc.TrinoStatement.executeQuery(TrinoStatement.java:78) ~[trino-jdbc-362.jar:362]

at org.talend.components.jdbc.runtime.reader.JDBCInputReader.start(JDBCInputReader.java:252) ~[components-jdbc-runtime-0.37.14.jar:?]

... 4 more

[Anonymous]

This isn't a supported DB system I am afraid. You can use the tDB components and select the JDBC database type. Then you will need to look through the requirements specified here....

https://trino.io/docs/current/client/jdbc.html

[MPadmanabhan]

Yeah. We have used the tDBInput component and JDBC DB type with driver: trino-jdbc-362.jar and

Driver Class: "io.trino.jdbc.TrinoDriver". Still no luck. Same connection timeout issue

[Anonymous]

Hello,

We are supposing that this is the driver issue.

What's your JDBC Url? Could you please make sure that you are using the correct driver?

https://trino.io/docs/current/client/jdbc.html

Best regards

Sabrina

[Anonymous]

There is a Java example of how to connect here....

https://trino.io/docs/current/client/jdbc.html

Can you try this using a single tJava component? This should give you some clues as to where the issue is.

In your question you say that this is a connection timeout issue, but the error doesn't seem to point to this.