Versions benchmark: Run TPC-H and TPC-DS queries in standard-compatible mode

Open
  • Is something wrong?
#1,322 0 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
58/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Quiet
Tech stack
shell, sql
Domain
databases

Research direction

Start with the ClickBench versions benchmark at https://benchmark.clickhouse.com/versions/ and inspect how its TPC-H and TPC-DS runs set session options. Compare those settings with tests/benchmarks/tpc-h/settings.json and tests/benchmarks/tpc-ds/settings.json; done means both benchmark families run in standard-compatible mode.

Written by the indexing model from the issue text.

Description

close in a month if not active

The TPC-H and TPC-DS benchmarks in ClickBench should run with the following session settings to produce official-SQL-compliant results. Compared to running with default settings like today, this is more a nice-to-have since since no official reference files exist for scale factors 40 / 35 (TPC-H / TPC-DS) used by the versions benchmark.

Dominant language
Shell
Stars
1.1k
Forks
328
Avg merge
4h 12m
Merged PRs (30d)
605

Getting set up

  • No Dockerfile or Docker Compose file
  • Has a pull request template
  • No contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from ClickHouse/ClickBench

All issues in ClickHouse/ClickBench

Similar issues

More Shell/Bash issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.