3 ms·
To help understand the results of the benchmark, I find it helpful to look at how the benchmark is constructed, and what it tests for. From the README: "The da
by carlineng 4y ago
To help understand the results of the benchmark, I find it helpful to look at how the benchmark is constructed, and what it tests for. From the README:
"The dataset is represented by one flat table. This is not representative of classical data warehouses, which use a normalized star or snowflake data model. The systems for classical data warehouses may get an unfair disadvantage on this benchmark."
Taking a look at the queries [0], it looks like it mostly consists of full table scans with filters, aggregations, and sorts. Since it's a single table, there are no joins.
[0]: https://github.com/ClickHouse/ClickBench/blob/main/snowflake/queries.sql https://github.com/ClickHouse/ClickBench/blob/main/snowflake...