Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
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
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.
Related posts
- We Built a 19 PiB Logging Platform with ClickHouse and Saved Millions
- 1 billion rows challenge in PostgreSQL and ClickHouse
- We Executed a Critical Supply Chain Attack on PyTorch
- Tell HN: Hacker News dataset on BigQuery hasn't been updated since Nov 2022
- Real-Time Data Enrichment and Analytics With RisingWave and ClickHouse