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.
Context
Supported TPC-H Versions
TPC has published the following TPC-H standards over time:
| TPC-H Benchmark Version | Published Date | Standard Specification |
|---|---|---|
| 3.0.1 | 04/28, 2022 | https://www.tpc.org/TPC_Documents_Current_Versions/pdf/TPC-H_v3.0.1.pdf |
| 3.0.0 | 02/18, 2021 | https://tpc.org/TPC_Documents_Current_Versions/pdf/tpc-h_v3.0.0.pdf |
Setup
Prerequisites
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 http://tpc.org/tpc_documents_current_versions/current_specifications5.asp.
Packages
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
Execution
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
cd ~/TPC-H-CBDB
./run.sh
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.
tpch_20230727_145051.log
