This performance test uses 100 GB of TPC-H data as test data and uses DBGEN to generate sample data.

Download the TPC-H data generation tool DBGEN from the TPC official website and compile the downloaded file to generate a binary executable file named dbgen.

./dbgen -s $scale -C $chunks -S $i -f
  • -s: specifies the scale factor (SF), which indicates the database size. A value of 100 indicates 100 GB. A value of 1000 indicates 1 TB.
  • -C: specifies the total number of chunks.
  • -S: specifies the serial number of the chunk that the current statement generates.
    Note One statement can generate only one chunk.

For more information about how to use DBGEN, see tpch-dbgen.