Skip to main content
[103-1] TPC-H: Decision Support Benchmark for Cloudberry Database
Run the TPC-H benchmark automatically on an existing Cloudberry Database cluster.

This tool is based on the benchmark tool TPC-H. This repo will guide you on how to run the TPC-H benchmark automatically on an existing CloudberryDB cluster in the CloudberryDB Sandbox.


The TPC-H is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions. You can learn more from the TPC-H official website.


Supported TPC-H Versions

TPC has published the following TPC-H standards over time:

TPC-H Benchmark VersionPublished DateStandard Specification
3.0.104/28, 2022
3.0.002/18, 2021



This is a follow-up tutorial for previous bootcamp steps. Please make sure to have the environment ready for Cloudberry Database Sandbox up and running.

TPC-H Tools Dependencies

Make sure that gcc and make are installed on mdw for compiling the dbgen (data generation) and qgen (query generation).

You can install the dependencies on mdw:

docker exec -it $(docker ps -q) /bin/bash
yum -y install gcc make

The source code is from


TPC-H and TPC-DS packages are already placed under "mdw:/tmp/" folder.

[gpadmin@mdw tmp]$ ls -rlt
-rw-rw-r-- 1 root root 24520013 Jul 27 14:18 TPC-H-CBDB.tar.gz
-rw-rw-r-- 1 root root 7096941 Jul 27 14:18 TPC-DS-CBDB.tar.gz


To run the benchmark, login as gpadmin on mdw in the CloudberryDB Sandbox, and execute the following command:

su - gpadmin
tar xzf TPC-H-CBDB.tar.gz

The TPC-H benchmark needs a few minutes to run before you get the final report, which depends on your machine's hardware. You may check the TPC-H execution log information file under the same directory with a similar name as below.