Pavel Kruglov
Pavel Kruglov
> And it's planned to stay in that way in future? Right now we plan to keep it this way.
> Is there any possibility of eventually being able to add data-skipping indices on JSON subcolumns? Hi! Right now only using materialized columns as you described. We will work on...
> How can we use new JSON type in Kafka tables? You can use [JSONAsObject](https://clickhouse.com/docs/en/interfaces/formats#jsonasobject) input format
> Yes I can however I'd prefer using new JSON type if it is possible JSONAsObject input format reads the whole JSON object into single column with type JSON, so...
> another issue related #70490 It's actually issue with Native format + async inserts in general. Fixed in https://github.com/ClickHouse/ClickHouse/pull/71193
I need to disallow `Dynamic` type in `min/max` functions. It may be misleading, because `Dynamic` type has custom comparison rule: https://clickhouse.com/docs/en/sql-reference/data-types/dynamic#using-dynamic-type-in-order-by-and-group-by
> Is there a way to flatten a JSON type column into multiple columns in ClickHouse? Unfortunately no. Mainly because we don't know all JSON paths stored in the table...
> Is there any chance we could support reading JSON sub-columns that match specific wildcard patterns or regular expressions? I think it's possible to implement similar to `json.^key` subcolumn. Something...
I am working on the tests, will add them later
> I assume, that if a.b.c is "object", that if we set SKIP a.b.c, user may want to skip it as whole, basically behavior of SKIP PREFIX. Yes, this is...