getResultSet not implemented

[adrevant]

Describe the bug

I'm trying to send some data from a couple of tables in my Clickhouse database to big query by using Airbyte but I'm having this error:

java.sql.SQLFeatureNotSupportedException: getResultSet not implemented

that is shown because indeed clickhouse-jdbc didn't implement the function getResultSet in ClickHouseArray.java.

Error log

INFO i.a.w.g.ReplicationWorkerHelper(getReplicationOutput):313 - failures: [ {
  "failureOrigin" : "source",
  "failureType" : "system_error",
  "internalMessage" : "java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLFeatureNotSupportedException: getResultSet not implemented",
  "externalMessage" : "Something went wrong in the connector. See the logs for more details.",
  "metadata" : {
    "attemptNumber" : 2,
    "jobId" : 5708,
    "from_trace_message" : true,
    "connector_command" : "read"
  },

Configuration

Environment

• Client version: 23.5.3.24
• Language version: 11.0.19
• OS: Debian GNU/Linux 11 (bullseye)

Is there a plan for implementing it?

[zhicwu]

Hi @brendavarguez, thanks for reporting the issue. Will come up with a PR to fix this in weekend.

Meanwhile, if you have control of the code, it's better to use ResultSet.getObject() to retrieve the value. Alternatively, you may play with the typeMappings option to see if you can find a different workaround.

[mzitnik]

@zhicwu what is the status of this PR?

[uttamdeb]

Hey, team. Recently faced the same issue, hence not eleborating any further. Any timeline on this, since it has been here for a while?