clickhouse-java
clickhouse-java copied to clipboard
getResultSet not implemented
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?
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 what is the status of this PR?