Supprting ClickHouse JSON Type

[mzitnik]

Kafka Connect SinkRecord is supporting nested types It should be translated to JSON Type in ClickHouse

[amit-cashify]

Any timeline on this?

[Paultagoras]

Hi @amit-cashify - the short answer is that we're waiting for official support of the JSON type, as it's currently considered experimental.

There are a few workarounds for this - this guide covers some details, while this is another workaround I've seen used (where the entire object is stored as a single string field and then parsed out in a later MV).

Hope that helps!

[amit-cashify]

Hi @amit-cashify - the short answer is that we're waiting for official support of the JSON type, as it's currently considered experimental.

I am also waiting on that to be production ready. Do you know of an ETA for official support of JSON type?

[Paultagoras]

Hi @amit-cashify - the short answer is that we're waiting for official support of the JSON type, as it's currently considered experimental.

I am also waiting on that to be production ready. Do you know of an ETA for official support of JSON type?

Sorry, I don't know of an ETA at the moment - I can ask internally if there is one, but no promises.

[Paultagoras]

According to https://clickhouse.com/docs/en/sql-reference/data-types/json this is an obsolete type and no longer meant to be used, as such closing this issue.