Unsupported data type: JSON

[aarcha123]

Using the below snippet results in "Unsupported data type: JSON:" using 0.3.2.patch11

PreparedStatement pstmt = connection.prepareStatement("INSERT INTO json_demo SELECT id,details from INPUT('id UInt8, details JSON')"); `
    pstmt.setInt(1, 20);
pstmt.setObject(2, "{\"type\": \"Region\"}");
pstmt.addBatch();
pstmt.executeBatch();

Table definition

CREATE TABLE json_demo
( id UInt8,
details JSON)
ENGINE = MergeTree()
PRIMARY KEY (id)

Stack trace:

Exception in thread "main" java.lang.IllegalArgumentException: Unsupported data type: JSON
	at com.clickhouse.client.data.ClickHouseRowBinaryProcessor$MappedFunctions.serialize(ClickHouseRowBinaryProcessor.java:484)
	at com.clickhouse.jdbc.internal.InputBasedPreparedStatement.addBatch(InputBasedPreparedStatement.java:333)

[zhicwu]

Hi @aarcha123, thanks for the report. It looks like now ClickHouse supports string format JSON object, which is way better than constructing a complex object in client. I'll update data type mapping accordingly in next release. Meanwhile, the workaround is simply change JSON to String in your insert query.

[aarcha123]

Thank you @zhicwu

[Martin7-1]

@zhicwu Hi, I encounter this exception when I want to select JSON data type. My code:

String sql = "SELECT id,text,embedding,metadata, dist " + 
"FROM table ORDER BY cosineDistance(embedding, [0.1, 0.2, 0.3]) AS dist ASC LIMIT 1000";

Records records = client.queryRecords(sql).get(3000, TimeUnit.MILLISECONDS)

And clickhouse-client throw Exception Caused by: java.lang.IllegalArgumentException: Unsupported data type: JSON.

I have setting allow_experimental_json_type = 1 and allow_experimental_vector_similarity_index = 1 when I create table. Any idea?

Dependency:

client-v2: 0.7.0
clickhouse-version: 24.9.2.42

[mzitnik]

@Martin7-1 can you open a dedicated issue for it.
@chernser can you take a look

[Martin7-1]

@mzitnik Hi! Thank you for your reply, I think this problem is related to #1833.

[mzitnik]

Duplicate of #1833