Repository navigation
Please support JSON / Object('json') type - at least [bulk] inserts #308
Description
Dear all,
my app (c++) needs to populate JSON column.
Is there a plan to add support for it?
I made attempt to add JSON following implementation for String type (https://github.com/v-instrumentix/clickhouse-cpp.git - sorry if you find it nasty), but ended with server error
DB::Exception: Syntax error (data type): failed at position 1 ('{'): {"a":false, "b":true, "c":0, "d":1, "e":"Hello", "d":"", "z":null}. Expected one of: data type, nested table, identifier.
..that looks as I miss something about the protocol / encoding, and this is where I stuck.
Any hints would be welcome.
Thanks!
Activity
Enmk commentedon Jun 5, 2023
Hi @v-instrumentix ! Well, there were no plans to support Json type, but any contribution is more than welcome. Please do not forget to update tests as well (I haven't found any in your repo)
v-instrumentix commentedon Jun 5, 2023
Dear @Enmk , thanks for returning back to me.
I would be happy to contribute, but I miss knowledge of client-server protocol and encoding, so I failed with adding support for JSON in my previous attempt.
If you could point me to appropriate docs, I'll give it another try.
Cheers!
Enmk commentedon Jun 7, 2023
There are not much docs on native client-server protocol, you'd have to read source of ClickHouse in order to understand how the data is transferred:
Object('json')to/from native format.v-val commentedon Jun 7, 2023
@Enmk right, I tried to follow the code and made some progress this way but then stuck with the error above; hoped there're some docs that might help.
FYI, I was able to sort the functional side of problem via plain text bulk insert statements:
Thanks a lot for the hints anyway, I'll use them if / when I have a chance to proceed with this.
slabko commentedon Jul 9, 2026
JSON is no supported in version 2.6.2 using
output_format_native_write_json_as_string. Please see more in the PR description Experimental support for the JSON data type