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.