Support for JSON data type on Dbeaver - Datagrip

[shi-sis]

Description

I'm using the driver 0.9.2 with DBeaver or Datagrip.
When trying to read a table with a JSON column I get the following error :
SQL Error [HY000]: Failed to read value for column json_data

Steps to reproduce

1. SELECT * FROM table_with_json_column

Error Log or Exception StackTrace

eclipse.buildId=unknown
java.version=21.0.5
java.vendor=Eclipse Adoptium
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en
Framework arguments: -eclipse.keyring C:\Users\shimeur\AppData\Roaming\DBeaverData\secure\secure_storage
Command-line arguments: -os win32 -ws win32 -arch x86_64 -eclipse.keyring C:\Users\shimeur\AppData\Roaming\DBeaverData\secure\secure_storage

org.jkiss.dbeaver.model
Error
Wed Sep 17 09:21:20 CEST 2025
Failed to read value for column json_data

com.clickhouse.client.api.ClientException: Failed to read value for column json_data
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:259)
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:90)
at com.clickhouse.client.api.data_formats.internal.AbstractBinaryFormatReader.readRecord(AbstractBinaryFormatReader.java:179)
at com.clickhouse.client.api.data_formats.internal.AbstractBinaryFormatReader.next(AbstractBinaryFormatReader.java:249)
at com.clickhouse.jdbc.ResultSetImpl.next(ResultSetImpl.java:107)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCResultSetImpl.next(JDBCResultSetImpl.java:282)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCResultSetImpl.nextRow(JDBCResultSetImpl.java:190)
at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:210)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:128)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:126)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5155)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:119)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: com.clickhouse.client.api.ClientException: Unsupported data type with tag 97
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readDynamicData(BinaryStreamReader.java:1216)
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:112)
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:90)
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readJsonData(BinaryStreamReader.java:1237)
at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:230)
... 13 more

Expected Behaviour

Select should return the content of JSON columns

Environment

• Client version: DBeaver 25.2.0 / DataGrip 2025.2.2
• OS: Windows 11

ClickHouse Server

• ClickHouse Server version: 25.4.1.37654 Cloud
• ClickHouse Server non-default settings, if any:
• CREATE TABLE statements for tables involved:

CREATE TABLE schema.table_with_json_column
(
    `id` String,
    `json_data` JSON,
    `emitted_at` DateTime64(3) DEFAULT now64()
)
ENGINE = SharedReplacingMergeTree('/clickhouse/tables/{uuid}/{shard}', '{replica}')
ORDER BY id
SETTINGS index_granularity = 8192

[BeautyFades]

Investigating on #2102. Might also be somewhat related to dbeaver/dbeaver#38742.
@chernser has had success creating a generic connector with the .jar downloaded from this repository.

[chernser]

Thank you, @BeautyFades !

[chernser]

Good day, @shi-sis !
Thank you for the issue!

Is any JSON columns even with empty values cause the issue?
Do you have example JSON that reproduces the problem?

Thanks!