tree: 0a7967c508628301866b35a202fe5d971a2cf126 [path history] [tgz]
  1. bin/
  2. conf/
  3. ddl/
  4. queries/
  5. README.md
tools/tpch-tools/README.md

Usage

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

1. build tpc-h dbgen tool.

./bin/build-tpch-dbgen.sh

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

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

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

./bin/create-tpch-tables.sh

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

./bin/load-tpch-data.sh

5. run tpc-h queries.

./bin/run-tpch-queries.sh

NOTICE: At present, Doris's query optimizer and statistical information functions are not complete, so we rewrite some queries in TPC-H to adapt to Doris' execution framework, but it does not affect the correctness of the results. The rewritten SQL is marked with "Modified" in the corresponding .sql file.

A new query optimizer will be released in subsequent releases.