Run TPCDS with one command

Install the Trino TPCDS generator on every FE and BE using the shared installation instructions, then configure conf/doris-cluster.conf and run:

./bin/run-tpcds.sh -s 1 -d tpcds_sf1

This streams generated rows directly into Doris, creates the existing benchmark tables, collects statistics, and records three executions per query. It supports SF1, SF100, SF1000, and SF10000. Preparation requires a new database. Use --queries-only to measure existing data again, with the same scale factor.

See shared workflow options, result files, and timing semantics. TPCDS uses the original scale-specific table DDL and multi-table queries. Install the plugin before running the command.

Original file-based workflow

Usage

These scripts are used to make tpc-ds test. follow the steps below:

1. build tpc-ds dsdgen dsqgen tool.

./bin/build-tpcds-tools.sh

If the build failed in dbgen tools' compilation, update your GCC version or change all "TPC-DS_Tools_v3.2.0new.zip" in build-tpcds-dbgen.sh to "TPC-DS_Tools_v3.2.0.zip"

2. generate tpc-ds data. use -h for more infomations.

./bin/gen-tpcds-data.sh -s 1

3. create tpc-ds tables. modify conf/doris-cluster.conf to specify doris info, then run script below.

./bin/create-tpcds-tables.sh -s 1

4. load tpc-ds data. use -h for help.

./bin/load-tpcds-data.sh

5. run tpc-ds queries.

./bin/run-tpcds-queries.sh -s 1