3 ms·
Nice article. Materialized columns in ClickHouse are a bit like indexes in the sense that they give a faster path to the answer by reading less data. ClickHous
by hodgesrm 5y ago
Nice article. Materialized columns in ClickHouse are a bit like indexes in the sense that they give a faster path to the answer by reading less data.
ClickHouse devs are adding a feature called semi-structured data that will optimize stored JSONs to columnar storage and also add convenient query syntax. [0] At that point the trade-off between stored JSON blobs and and materialized columns will become a lot less stark than it is today.
[0] https://github.com/ClickHouse/ClickHouse/issues/17623 https://github.com/ClickHouse/ClickHouse/issues/17623