UnamedRus

> However, concerning the internal representation in a SummingMergeTree for a Bool type is a different question and I don't have a "convenient" solution for it. ClickHouse just need to...

Похоже данная проблема возникает с колонкой FixedString.

It's also make sense to look into projections https://github.com/ClickHouse/ClickHouse/issues/14730 https://www.youtube.com/watch?v=jJ5VuLr2k5k

@javisantana You can look into: https://github.com/ClickHouse/ClickHouse/pull/8331 It's already merged.

``` EXPLAIN QUERYTREE SELECT Carrier, sum(toFloat64(C3)) AS C1, sum(toFloat64(C1)) AS C2, sum(toFloat64(C2)) AS C3 FROM ( SELECT 1 AS Carrier, count(CAST(1, 'Nullable(Int32)')) AS C1, max(rand()) AS C2, min(rand32()) AS C3...

> Because the node still exists in the zookeeper config, I can't just recreate all the tables. It requires me to manually delete the zookeeper keys and then recreate the...

Looks like this restriction was added with support for yaml configs https://github.com/ClickHouse/ClickHouse/pull/21858/files#diff-be8543b10bc4c2ccfeb38691976ffe53ebd8b905dc44f4fa1f440c9f24ec372cL461

Did you saw the exact message: `ClickHouse init process failed` during startup?

I don't suggest to use CLICKHOUSE_INIT_TIMEOUT (and put anything in /init.db ) at all tbh. What do you put here?

For row policies, i think it's better to look into user storage in ZooKeeper. https://kb.altinity.com/altinity-kb-integrations/altinity-cloud/altinity-cloud-access-management/ ``` /etc/clickhouse-server/users.xml /clickhouse/access/ ```