Skip to content

[jdbc-v2] Exception reading table with JSON column #2462

New issue
New issue
Open
#2531
Open
[jdbc-v2] Exception reading table with JSON column#2462
#2531
Assignees
chernser
Labels
area:data-typedata type processing issuesbugclient-api-v2jdbc-v2jdbc-v2 issues
Milestone
0.9.2
@chernser

Description

@chernser
chernser
opened on Jun 19, 2025

Description

There is an exception

[HY000] Failed to read value for column test
Unsupported data type with tag 100

This probably relates to the type mapping in JDBC

Steps to reproduce

--Json with schema
CREATE TABLE json_with_schema
(
    ingestDateTime DateTime64(6, 'UTC') DEFAULT now64(6),
    json_field JSON ( id Int32, name String, value Int64)
)
ENGINE = Memory;

INSERT INTO json_with_schema (ingestDateTime, json_field) VALUES
('2025-04-21 10:00:00.123456', '{"id": 1, "name": "Event1", "value": 100}'),
('2025-04-21 10:01:00.654321', '{"id": 2, "name": "Event2", "value": 200}');

SELECT * FROM json_with_schema;

Error Log or Exception StackTrace

2025-07-22 08:46:48,487 [82990063]   WARN - #c.i.d.d.BaseDatabaseErrorHandler$UnknownErrorInfo - Failed to read value for column json_field
java.sql.SQLException: Failed to read value for column json_field
	at com.clickhouse.jdbc.internal.ExceptionUtils.toSqlState(ExceptionUtils.java:69)
	at com.clickhouse.jdbc.internal.ExceptionUtils.toSqlState(ExceptionUtils.java:42)
	at com.clickhouse.jdbc.ResultSetImpl.next(ResultSetImpl.java:102)
	at com.intellij.database.remote.jdbc.impl.RemoteResultSetImpl.getObjects(RemoteResultSetImpl.java:1342)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
	at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
	at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
	at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
	at java.rmi/sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:304)
	at java.rmi/sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:280)
	at java.rmi/sun.rmi.server.UnicastRef.invoke(UnicastRef.java:166)
	at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:215)
	at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:160)
	at jdk.proxy7/jdk.proxy7.$Proxy372.getObjects(Unknown Source)
	at com.intellij.database.console.JdbcEngine.printResultSet(JdbcEngine.java:983)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.lambda$results$0(JdbcEngine.java:2079)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.processResults(JdbcEngine.java:2064)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.results(JdbcEngine.java:2079)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.results(JdbcEngine.java:2058)
	at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer$processRemaining$2.results(UniversalResultsProducer.kt:43)
	at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer$processRemaining$2.results(UniversalResultsProducer.kt:37)
	at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer.processCurrent(UniversalResultsProducer.kt:64)
	at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer.processRemaining(UniversalResultsProducer.kt:37)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.lambda$execute$0(JdbcEngine.java:2058)
	at com.intellij.database.dataSource.connection.statements.SmartStatementsUtil.consumer$lambda$3(SmartStatementsUtil.kt:105)
	at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement.execute$lambda$1$lambda$0(JdbcBasedSmartStatement.kt:47)
	at com.intellij.database.dataSource.connection.statements.SmartStatementsUtil.runReporting(SmartStatementsUtil.kt:82)
	at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement.execute$lambda$1(JdbcBasedSmartStatement.kt:47)
	at com.intellij.database.dataSource.connection.Either.transform(Either.kt:23)
	at com.intellij.database.dataSource.connection.EitherKt.transformSafe(Either.kt:45)
	at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement.execute(JdbcBasedSmartStatement.kt:46)
	at com.intellij.database.dataSource.connection.statements.NoisyStatement.execute(NoisyStatement.kt:24)
	at com.intellij.database.console.JdbcEngine$RegularExecutor.execute(JdbcEngine.java:1475)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.lambda$execute$1(JdbcEngine.java:2056)
	at com.intellij.database.dialects.base.BaseExecutionEnvironmentHelper.runInSpecificEnvironment(BaseExecutionEnvironmentHelper.java:108)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.execute(JdbcEngine.java:2055)
	at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.perform(JdbcEngine.java:2001)
	at com.intellij.database.console.JdbcEngine$OperationBase.perform(JdbcEngine.java:1672)
	at com.intellij.database.console.JdbcEngine.lambda$visitQuery$4(JdbcEngine.java:492)
	at com.intellij.database.console.JdbcEngine.lambda$submitRequest$15(JdbcEngine.java:1168)
	at com.intellij.database.util.AsyncTask$Frame$sync$$inlined$framed$intellij_database_core_impl$1.run(AsyncTask.kt:338)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$14(CoreProgressManager.java:680)
	at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:695)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:679)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:77)
	at com.intellij.database.util.AsyncTask$Frame.sync(AsyncTask.kt:907)
	at com.intellij.database.console.AbstractEngine.lambda$submitRequest$7(AbstractEngine.java:245)
	at com.intellij.database.util.AsyncUtil.lambda$underProgress$6(AsyncUtil.java:141)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$14(CoreProgressManager.java:680)
	at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:755)
	at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:711)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:679)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:77)
	at com.intellij.database.util.AsyncUtil.underProgress(AsyncUtil.java:146)
	at com.intellij.database.util.AsyncUtil.underProgress(AsyncUtil.java:141)
	at com.intellij.database.console.AbstractEngine.lambda$submitRunnable$6(AbstractEngine.java:204)
	at com.intellij.database.console.AbstractEngine.lambda$submitRunnable$5(AbstractEngine.java:185)
	at com.intellij.database.util.AsyncTask$Frame$compute$$inlined$supply$1$1.run(AsyncTask.kt:338)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$14(CoreProgressManager.java:680)
	at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:695)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:679)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:77)
	at com.intellij.database.util.AsyncTask$Frame$compute$$inlined$supply$1.get(AsyncTask.kt:907)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
	at com.intellij.util.concurrency.ChildContext$runInChildContext$1.invoke(propagation.kt:102)
	at com.intellij.util.concurrency.ChildContext$runInChildContext$1.invoke(propagation.kt:102)
	at com.intellij.util.concurrency.ChildContext.runInChildContext(propagation.kt:108)
	at com.intellij.util.concurrency.ChildContext.runInChildContext(propagation.kt:102)
	at com.intellij.util.concurrency.ContextRunnable.run(ContextRunnable.java:27)
	at com.intellij.database.util.AsyncTask$Companion.captureContext$lambda$2$lambda$1(AsyncTask.kt:563)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: com.clickhouse.client.api.ClientException: Failed to read value for column json_field
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:254)
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:89)
	at com.clickhouse.client.api.data_formats.internal.AbstractBinaryFormatReader.readRecord(AbstractBinaryFormatReader.java:178)
	at com.clickhouse.client.api.data_formats.internal.AbstractBinaryFormatReader.next(AbstractBinaryFormatReader.java:248)
	at com.clickhouse.jdbc.ResultSetImpl.next(ResultSetImpl.java:100)
	at com.intellij.database.remote.jdbc.impl.RemoteResultSetImpl.getObjects(RemoteResultSetImpl.java:1342)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:360)
	at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
	at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
	at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:598)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:844)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:721)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
	at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:720)
	... 3 more
Caused by: com.clickhouse.client.api.ClientException: Unsupported data type with tag 100
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readDynamicData(BinaryStreamReader.java:1183)
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:111)
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:89)
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readJsonData(BinaryStreamReader.java:1200)
	at com.clickhouse.client.api.data_formats.internal.BinaryStreamReader.readValue(BinaryStreamReader.java:225)
	... 20 more

Expected Behaviour

Code Example



Configuration


Client Configuration




Environment


    

  •  Cloud
    • 

  • Client version:
    • 

  • Language version:
    • 

  • OS:
    • 



ClickHouse Server


    

  • ClickHouse Server version:
    • 

  • ClickHouse Server non-default settings, if any:
    • 

  • CREATE TABLE statements for tables involved:
    • 

  • Sample data for all these tables, use clickhouse-obfuscator if necessary
    • 

Metadata
Metadata
Assignees
Labels
area:data-typedata type processing issuesbugclient-api-v2jdbc-v2jdbc-v2 issues
Type
No type
Projects
No projects
Milestone
Relationships
None yet
Development
No branches or pull requests
Issue actions