clickhouse-java icon indicating copy to clipboard operation
clickhouse-java copied to clipboard

getResultSet not implemented

Open adrevant opened this issue 2 years ago • 3 comments

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?

adrevant avatar Aug 31 '23 14:08 adrevant

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.

zhicwu avatar Aug 31 '23 23:08 zhicwu

@zhicwu what is the status of this PR?

mzitnik avatar Sep 12 '23 05:09 mzitnik