Make sure you have following packages install in your system: gcc, make, flex, bison, byacc, git, time
sudo apt-get install gcc make flex bison byacc git time
Make sure the ByConity client are installed. You can install the package from this page, and then find clickhouse binary and move it to bin folder in the project. Or you can copy the binary from any existing installations. E.g. an existing ByConity docker container.
cp config.sh.tpl config.sh
Edit config.sh to set up paramaters. Please refer to the comments in the file.
chmod a+x *.sh
Run the command to build TPD-DS tools, the tool will be generated to build folder
./build.sh
Run the command to generated TPD-DS data files. In the command, $1 is the data size. The data generation is run in parallel, using the PARALLEL setting in the config.sh. The data file will be generated into data_tpcds_{data_size} folder. The data generation takes time. There is no output about progress during the data generation. If you want to see the progress, please watch the files generated in the folder.
./gen_data.sh 100
Run the command to populate the TPD-DS data from the data files to ByConity. $1 is the data size.
./populate_data.sh 100
Run TPD-DS benchmark on ByConity. $1 is the data size.
./benchmark.sh 100
In the logs folder, check the result.csv for the result of TPC-DS, the format is ['Query ID', 'Time in ms', 'Status' (0 is normal)] Check trace.log for the detail of queries running in the benchmark.
THE SOFTWARE “byconity-tpcds” PROVIDED TO YOU BY TRANSACTION PROCESSING PERFORMANCE COUNCIL ("TPC") WILL BE SUBJECT TO THE TERMS AND CONDITIONS OF THIS EULA