tpcds-kit

The official TPC-DS tools can be found at tpc.org.

This version is based on v2.10.0 and has been modified to:

• Allow compilation under macOS (commit 2ec45c5)
• Address obvious query template bugs like
  • query22a: #31
  • query77a: #43
• Rename

  s_web_returns

  column

  wret_web_site_id

  to

  wret_web_page_id

  to match specification. See #22 & #42.

To see all modifications, diff the files in the master branch to the version branch. Eg:

master

v2.10.0

Setup

Linux

Make sure the required development tools are installed:

Ubuntu:

sudo apt-get install gcc make flex bison byacc git

CentOS/RHEL:

sudo yum install gcc make flex bison byacc git

Then run the following commands to clone the repo and build the tools:

git clone https://github.com/gregrahn/tpcds-kit.git
cd tpcds-kit/tools
make OS=LINUX

macOS

Make sure the required development tools are installed:

xcode-select --install

Then run the following commands to clone the repo and build the tools:

git clone https://github.com/gregrahn/tpcds-kit.git
cd tpcds-kit/tools
make OS=MACOS

Using the TPC-DS tools

Data generation

Data generation is done via

dsdgen

dsdgen -help

dsdgen

tools/

-DISTRIBUTIONS /.../tpcds-kit/tools/tpcds.idx

-DIR

dsdgen

Query generation

Query generation is done via

dsqgen

dsqgen -help

The following command can be used to generate all 99 queries in numerical order (

-QUALIFY

-SCALE

-DIALECT

/tmp/query_0.sql

-OUTPUT_DIR

dsqgen \
-DIRECTORY ../query_templates \
-INPUT ../query_templates/templates.lst \
-VERBOSE Y \
-QUALIFY Y \
-SCALE 10000 \
-DIALECT netezza \
-OUTPUT_DIR /tmp