@kapa.ai , there is an issue in reading table schema when clickhouse version 26.8 is used through the connector , is there a bug /change we are missing?

Thinking completed I'm sorry, but the provided knowledge sources do not explicitly mention ClickHouse version 26.8 or any specific bugs or changes related to schema reading on that exact version. However, the knowledge sources do document known schema-reading issues and compatibility limitations in the ClickHouse connectors that might explain the behavior you are seeing: 1. Source Connector: JDBC Driver Compatibility & Unsupported Types If you are using ClickHouse as a source (

source-clickhouse

): • Outdated JDBC Driver: Airbyte's ClickHouse source uses the ClickHouse JDBC driver, which has had compatibility issues parsing newer aggregate functions and types when discovering columns (e.g.,

IllegalArgumentException: Unknown aggregate function

during schema discovery) [Clickhouse as a source has an outdated JDBC version]. • Complex Data Types (

Array

/

Object

): There is an open issue where schema reading and queries fail with

SQLFeatureNotSupportedException: getResultSet() is not supported

on complex types like

Array

or

Object

[source-clickhouse] SQLFeatureNotSupportedException: getResultSet not implemented]. As a workaround, converting these columns to

String

on the ClickHouse side has been reported to resolve the sync [source-clickhouse] SQLFeatureNotSupportedException: getResultSet not implemented]. 2. Destination Connector: Schema Discovery Queries If you are using ClickHouse as a destination (

destination-clickhouse

): • Schema discovery reads table metadata by querying

system.tables

(specifically

SELECT engine_full FROM system.tables WHERE database = ... AND name = ...

) [ClickhouseSchemaDumper.kt]. If ClickHouse 26.8 altered system table metadata responses or JDBC metadata behavior, it could lead to discovery issues. • Ensuring you are on the latest connector release (such as

2.1.30

or newer) is recommended, as recent updates include newer CDK versions and driver bumps [Changelog]. If your sync failure includes a specific stack trace (such as

IllegalArgumentException

,

SQLFeatureNotSupportedException

, or syntax errors), checking whether it involves complex types or opening an issue with the connector logs on the Airbyte GitHub repository would be the best next step. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

issue is failed to get table com.clickhouse.client.api.ClientException: Failed to get table schema error in clickhouse airbyte connector after upgrading to clickhouse version 26.8