1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift

ClickHouse Cloud demonstrated superior cost-performance in executing the TPC-H SF100 benchmark, outperforming other major cloud data warehouses like Snowflake, Databricks, BigQuery, and Redshift. Using a single 59-core node, ClickHouse Cloud completed the TPC-H SF100 workload, which comprises 100GB of data and 22 complex JOIN queries, in 19.8 seconds at a compute cost of $0.063, making it the most cost-effective solution. In a scaled-down SF10 test, ClickHouse Cloud ran the workload in 2.9 seconds for less than a cent, further establishing its efficiency. The benchmark results highlight ClickHouse Cloud's competitive edge in both runtime and cost across various configurations, with significant improvements attributed to two years of focused JOIN engineering. These advances have made ClickHouse Cloud 26 times faster in handling JOIN-centric workloads, with ongoing efforts to enhance performance for larger-scale operations like TPC-H SF1000 through multi-stage distributed query execution.