Issue with Clickhouse connector when pulling from different schemas

Summary

The user is facing an issue with the Clickhouse connector when pulling data from schema2, receiving a ‘getResultSet not implemented’ error. The problem might be related to user privileges.


Question

Hi everyone!
Can anyone suggest a possible issue?
When I pull from schema1 everything works perfectly, but when I pull from schema2 I get this.
I’m using a Clickhouse connector and Clickhouse destination.
Can it be related to user’s privileges?

2024-02-21 13:40:53 [44msource[0m > SQLState: 0A000, Message: getResultSet not implemented
2024-02-21 13:40:53 [44msource[0m > Closing database connection pool.
2024-02-21 13:40:53 [44msource[0m > HikariPool-1 - Shutdown initiated…
2024-02-21 13:40:53 [44msource[0m > HikariPool-1 - Shutdown completed.
2024-02-21 13:40:53 [44msource[0m > Closed database connection pool.
2024-02-21 13:40:53 [44msource[0m > Something went wrong in the connector. See the logs for more details.
Stack Trace: java.lang.RuntimeException: java.sql.SQLFeatureNotSupportedException: getResultSet not implemented
at io.airbyte.db.jdbc.StreamingJdbcDatabase$1.tryAdvance(StreamingJdbcDatabase.java:105)
at java.base/java.util.Spliterators$1Adapter.hasNext(Spliterators.java:681)
at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:38)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at io.airbyte.commons.util.LazyAutoCloseableIterator.computeNext(LazyAutoCloseableIterator.java:42)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at com.google.common.collect.TransformedIterator.hasNext(TransformedIterator.java:46)
at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:38)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at com.google.common.collect.TransformedIterator.hasNext(TransformedIterator.java:46)
at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:38)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at io.airbyte.commons.util.CompositeIterator.computeNext(CompositeIterator.java:63)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:38)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at io.airbyte.commons.util.DefaultAutoCloseableIterator.computeNext(DefaultAutoCloseableIterator.java:38)
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:146)
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:141)
at java.base/java.util.Iterator.forEachRemaining(Iterator.java:132)
at io.airbyte.integrations.base.IntegrationRunner.lambda$produceMessages$0(IntegrationRunner.java:157)
at io.airbyte.integrations.base.IntegrationRunner.watchForOrphanThreads(IntegrationRunner.java:207)
at io.airbyte.integrations.base.IntegrationRunner.produceMessages(IntegrationRunner.java:156)
at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:137)
at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:97)
at io.airbyte.integrations.source.clickhouse.ClickHouseSource.main(ClickHouseSource.java:134)
Caused by: java.sql.SQLFeatureNotSupportedException: getResultSet not implemented
at com.clickhouse.jdbc.SqlExceptionUtils.unsupportedError(SqlExceptionUtils.java:138)
at com.clickhouse.jdbc.ClickHouseArray.getResultSet(ClickHouseArray.java:74)
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.putArray(AbstractJdbcCompatibleSourceOperations.java:69)
at io.airbyte.db.jdbc.JdbcSourceOperations.setJsonField(JdbcSourceOperations.java:59)
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.rowToJson(AbstractJdbcCompatibleSourceOperations.java:61)
at io.airbyte.db.jdbc.AbstractJdbcCompatibleSourceOperations.rowToJson(AbstractJdbcCompatibleSourceOperations.java:38)
at io.airbyte.db.jdbc.StreamingJdbcDatabase$1.tryAdvance(StreamingJdbcDatabase.java:99)
… 31 more



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["clickhouse-connector", "schema2", "user-privileges", "getresultset-not-implemented"]