TPC-H Data Vault
Open TPC-H Data Vault in the Results Explorer
TPC-H Data Vault on BenchBox: 18 published runs across 6 platforms. Latest run 2026-10-26.
Platforms
- BigQuery, 4 runs
- ClickHouse Local, 4 runs
- Databricks, 3 runs
- DataFusion, 2 runs
- DuckDB, 2 runs
- Snowflake, 3 runs
Score definitions
- Geomean query time
- Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology.
SF 0.01, power
| Rank | Platform | Version | Run date | Geomean query time | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ClickHouse Local | — | 2026-10-26 | 35 ms | 35 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
SF 0.1, power
| Rank | Platform | Version | Run date | Geomean query time | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ClickHouse Local | — | 2026-10-26 | 127 ms | 127 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
Runs not included in rankings
16 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (16)
| Scale | Phase | Platform | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| SF 0.01 | power | BigQuery | — | 2026-09-27 | 979 ms | 979 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 0.01 | power | ClickHouse Local | — | 2026-08-26 | 11 ms | 11 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | DataFusion | v53.0.0 | 2026-08-25 | 8.2 ms | 8.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | DuckDB | v1.3.2 | 2026-08-26 | 5.3 ms | 5.3 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | BigQuery | — | 2026-09-30 | 1.18 s | 1.18 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 0.1 | power | ClickHouse Local | — | 2026-08-26 | 48 ms | 48 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | Databricks | v2026.36 | 2026-09-30 | 1.6 s | 1.6 s | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 0.1 | power | DataFusion | v53.0.0 | 2026-08-25 | 57 ms | 57 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | DuckDB | v1.3.2 | 2026-08-26 | 19 ms | 19 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | Snowflake | v10.34.101 | 2026-09-26 | 587 ms | 587 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| SF 1 | power | BigQuery | — | 2026-10-01 | 3.01 s | 3.01 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 1 | power | Databricks | v2026.36 | 2026-09-30 | 2.06 s | 2.06 s | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 1 | power | Snowflake | v10.34.101 | 2026-09-25 | 874 ms | 874 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| SF 10 | power | BigQuery | — | 2026-10-01 | 4.9 s | 4.9 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 10 | power | Databricks | v2026.36 | 2026-10-01 | 6.51 s | 6.51 s | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 10 | power | Snowflake | v10.35.101 | 2026-09-30 | 2.92 s | 2.92 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |