Hi.
I’m using Knime 5.9.0 on Mac.
I have added trino jdbc driver. (v475)
I’m getting an exception like:
Execute failed: java.sql.SQLException: Cannot convert from timestamp(6) with time zone to class java.time.OffsetDateTime
When I looked at Trino source code, I found it supports java.sql.Timestamp, String, Instant, ZonedDateTime. OffsetDateTime not listed.
So I tried to set Mapping for timestamp_with_timezone, but only one option is listed. In fact, it says zoneddatetime but it actually expects offsetdatetime.
How can I cover this situation.
Thanks.
