forked from hyrise/hyrise
-
Notifications
You must be signed in to change notification settings - Fork 0
How to run the file based benchmark
Jonathan Janetzki edited this page May 28, 2019
·
2 revisions
First, generate the TPC-DS data and all required TPC-DS queries by following these steps.
Copy the generated tables into resources/benchmark/tpcds/tables/ and the queries to resources/benchmark/tpcds/queries/.
Change the file endings of the tables from .dat to .csv:
cd resources/benchmark/tpcds/tables/
rename 's/\.dat$/\.csv/' *.dat
cd ../../../../
Benchmark a single query (query_0.sql):
build/hyriseBenchmarkFileBased --query_path resources/benchmark/tpcds/queries/query_0.sql --table_path resources/benchmark/tpcds/tables/ -o resources/benchmark/tpcds/benchmark_result.json --cache_binary_tables
Benchmark all queries of the directory resources/benchmark/tpcds/queries/:
build/hyriseBenchmarkFileBased --query_path resources/benchmark/tpcds/queries/ --table_path resources/benchmark/tpcds/tables/ -o resources/benchmark/tpcds/benchmark_result.json --cache_binary_tables