tpctools

Crates.iotpctools
lib.rstpctools
version0.7.0
sourcesrc
created_at2021-05-15 14:27:23.262482
updated_at2024-03-03 18:24:08.54266
descriptionUtilities for generating and converting TPC-H and TPC-DS data sets
homepagehttps://github.com/sql-benchmarks/tpctools/
repositoryhttps://github.com/sql-benchmarks/tpctools/
max_upload_size
id397881
size133,823
Andy Grove (andygrove)

documentation

README

TPC Tools

Command-line tools for invoking TPC-H and TPC-DS data generators in parallel and re-organizing the output files into directory structures that can be consumed by tools such as Apache Spark or Apache Arrow DataFusion/Ballista.

Also supports converting the output to Parquet.

TPC-DS

Install dependencies.

sudo apt install gcc make flex bison byacc git

Download data generator from https://www.tpc.org/tpc_documents_current_versions/current_specifications5.asp

cd /path/to/DSGen-software-code-3.2.0rc1/tools
make

Generate data.

mkdir /tmp/tpcds/sf1000

cargo run --release -- generate --benchmark tpcds \
  --scale 1000 \
  --partitions 48 \
  --generator-path /path/to/DSGen-software-code-3.2.0rc1/tools \
  --output /tmp/tpcds/sf1000/

Example output.

Generated TPC-DS data at scale factor 1000 with 48 partitions in: 6247.155671938s

Convert to Parquet

mkdir /tmp/tpcds/sf1000-parquet

cargo run --release -- convert --benchmark tpcds \
  --input /tmp/tpcds/sf1000/
  --output /tmp/tpcds/sf1000-parquet/

TPC-H

Install dependencies.

git clone git@github.com:databricks/tpch-dbgen.git
cd tpch-dbgen
make
cd ..

Generate data.

mkdir /tmp/tpch

cargo run --release -- generate --benchmark tpch \
  --scale 1 \
  --partitions 2 \
  --generator-path ./tpch-dbgen/ \
  --output /tmp/tpch

Convert data to Parquet

mkdir /tmp/tpch-parquet

cargo run --release -- convert \
  --benchmark tpch \
  --input /tmp/tpch/ \
  --output /tmp/tpch-parquet/

Legal Stuff

TPC-H is Copyright © 1993-2022 Transaction Processing Performance Council. The full TPC-H specification in PDF format can be found here

TPC-DS is Copyright © 2021 Transaction Processing Performance Council. The full TPC-DS specification in PDF format can be found here

TPC, TPC Benchmark, TPC-H, and TPC-DS are trademarks of the Transaction Processing Performance Council.

Commit count: 0

cargo fmt