ClickHouse connector gives getResultSet not implemented error

[iluk807]

I'm encountering an issue while trying to load data from ClickHouse using Airbyte. The process fails with the following error:

getResultSet not implemented

I’ve tried using different versions of the ClickHouse JDBC driver, but the error persists.
Has anyone experienced this issue before or found a workaround for it? Any suggestions on how to resolve this would be greatly appreciated!
Below are more detailed logs from the error:

2024-10-18 10:55:45 source > 2024-10-18 10:55:45 ERROR i.a.c.d.j.StreamingJdbcDatabase$1(tryAdvance):109 - SQLState: 0A000, Message: getResultSet not implemented 2024-10-18 10:56:01 source > 2024-10-18 10:56:01 ERROR i.a.c.u.CompositeIterator(close):126 - exception while closing 2024-10-18 10:56:01 source > java.lang.RuntimeException: java.sql.SQLFeatureNotSupportedException: getResultSet not implemented 2024-10-18 10:56:01 source > at io.airbyte.cdk.db.jdbc.StreamingJdbcDatabase.lambda$unsafeQuery$0(StreamingJdbcDatabase.java:77) ~[airbyte-cdk-core-0.20.4.jar:?] 2024-10-18 10:56:01 source > at java.base/java.util.stream.AbstractPipeline.close(AbstractPipeline.java:323) ~[?:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.LazyAutoCloseableIterator.close(LazyAutoCloseableIterator.java:56) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.CompositeIterator.close(CompositeIterator.java:124) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.AutoCloseableIterators.lambda$appendOnClose$0(AutoCloseableIterators.java:106) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.AutoCloseableIterators.lambda$appendOnClose$0(AutoCloseableIterators.java:106) ~[airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.concurrency.VoidCallable.call(VoidCallable.java:15) [airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.commons.util.DefaultAutoCloseableIterator.close(DefaultAutoCloseableIterator.java:53) [airbyte-cdk-dependencies-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.cdk.integrations.base.IntegrationRunner.readSerial(IntegrationRunner.java:275) [airbyte-cdk-core-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.cdk.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:173) [airbyte-cdk-core-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.cdk.integrations.base.IntegrationRunner.run(IntegrationRunner.java:125) [airbyte-cdk-core-0.20.4.jar:?] 2024-10-18 10:56:01 source > at io.airbyte.integrations.source.clickhouse.ClickHouseSource.main(ClickHouseSource.java:134) [io.airbyte.airbyte-integrations.connectors-source-clickhouse-0.50.50.jar:?]