Support Object/JSON type?

[franchb]

New data type Object(<schema_format>), which supports storing of semi-structured data (for now JSON only). Data is written to such types as string. Then all paths are extracted according to format of semi-structured data and written as separate columns in most optimal types, that can store all their values. Those columns can be queried by names that match paths in source data. E.g data.key1.key2 or with cast operator data.key1.key2::Int64.

https://clickhouse.com/docs/en/whats-new/changelog/#experimental-feature-1

[iam047801]

@vmihailenco, hey there! Will you implement it? I need it too.

[vmihailenco]

There are multiple issues with JSON datatype and none is working on them: https://github.com/ClickHouse/ClickHouse/issues?q=is%3Aissue+is%3Aopen+label%3Acomp-type-object

[StealthBadger747]

Looks like the JSON data type is now obsolete.
See ClickHouse/ClickHouse#59367 and ClickHouse/ClickHouse#46190

Looks like I will have to find a new strategy for storing dynamic user defined data.

[anishjain94]

@StealthBadger747 Were you able to find a new strategy for storing dynamic types or json?