You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2026/06/09 12:27:16 UTC
(datafusion) 01/01: Add tpcds SQL benchmark (#22801)
This is an automated email from the ASF dual-hosted git repository.
github-merge-queue[bot] pushed a commit to branch gh-readonly-queue/main/pr-22801-a63fd489e62dd67a88a830f099e980c22f9e1e76
in repository https://gitbox.apache.org/repos/asf/datafusion.git
commit 33eba619721f75525c8827fb09d46f15a3b67bd1
Author: Bruce Ritchie <br...@gmail.com>
AuthorDate: Tue Jun 9 08:26:53 2026 -0400
Add tpcds SQL benchmark (#22801)
## Which issue does this PR close?
Part of #21706
## Rationale for this change
Continue work on sql benchmark migration.
## What changes are included in this PR?
tpcds sql benchmark
## Are these changes tested?
Yes
`BENCH_NAME=tpcds cargo bench --bench sql`
## Are there any user-facing changes?
No
---
.../sql_benchmarks/tpcds/benchmarks/q01.benchmark | 16 ++++++++
.../sql_benchmarks/tpcds/benchmarks/q02.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q03.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q04.benchmark | 16 ++++++++
.../sql_benchmarks/tpcds/benchmarks/q05.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q06.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q07.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q08.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q09.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q10.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q11.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q12.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q13.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q14.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q15.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q16.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q17.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q18.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q19.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q20.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q21.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q22.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q23.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q24.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q25.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q26.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q27.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q28.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q29.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q30.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q31.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q32.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q33.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q34.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q35.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q36.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q37.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q38.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q39.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q40.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q41.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q42.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q43.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q44.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q45.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q46.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q47.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q48.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q49.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q50.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q51.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q52.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q53.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q54.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q55.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q56.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q57.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q58.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q59.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q60.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q61.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q62.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q63.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q64.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q65.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q66.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q67.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q68.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q69.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q70.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q71.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q72.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q73.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q74.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q75.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q76.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q77.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q78.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q79.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q80.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q81.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q82.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q83.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q84.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q85.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q86.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q87.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q88.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q89.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q90.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q91.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q92.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q93.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q94.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q95.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q96.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q97.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q98.benchmark | 15 +++++++
.../sql_benchmarks/tpcds/benchmarks/q99.benchmark | 15 +++++++
benchmarks/sql_benchmarks/tpcds/init/cleanup.sql | 47 ++++++++++++++++++++++
benchmarks/sql_benchmarks/tpcds/init/load.sql | 47 ++++++++++++++++++++++
101 files changed, 1581 insertions(+)
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q01.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q01.benchmark
new file mode 100644
index 0000000000..f3a7cb1b45
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q01.benchmark
@@ -0,0 +1,16 @@
+name Q01
+group tpcds
+
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/1.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/1.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q02.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q02.benchmark
new file mode 100644
index 0000000000..4b68a1829d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q02.benchmark
@@ -0,0 +1,15 @@
+name Q02
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/2.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/2.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q03.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q03.benchmark
new file mode 100644
index 0000000000..74c8e78584
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q03.benchmark
@@ -0,0 +1,15 @@
+name Q03
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/3.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/3.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q04.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q04.benchmark
new file mode 100644
index 0000000000..dbd2a88797
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q04.benchmark
@@ -0,0 +1,16 @@
+name Q04
+group tpcds
+
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/4.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/4.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q05.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q05.benchmark
new file mode 100644
index 0000000000..49bbfbda23
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q05.benchmark
@@ -0,0 +1,15 @@
+name Q05
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/5.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/5.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q06.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q06.benchmark
new file mode 100644
index 0000000000..b2349eda36
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q06.benchmark
@@ -0,0 +1,15 @@
+name Q06
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/6.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/6.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q07.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q07.benchmark
new file mode 100644
index 0000000000..1e354cf1b0
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q07.benchmark
@@ -0,0 +1,15 @@
+name Q07
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/7.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/7.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q08.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q08.benchmark
new file mode 100644
index 0000000000..b9a511dbe0
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q08.benchmark
@@ -0,0 +1,15 @@
+name Q08
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/8.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/8.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q09.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q09.benchmark
new file mode 100644
index 0000000000..15cf4226ac
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q09.benchmark
@@ -0,0 +1,15 @@
+name Q09
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/9.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/9.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q10.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q10.benchmark
new file mode 100644
index 0000000000..401bd3dea2
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q10.benchmark
@@ -0,0 +1,15 @@
+name Q10
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/10.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/10.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q11.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q11.benchmark
new file mode 100644
index 0000000000..f54ba637be
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q11.benchmark
@@ -0,0 +1,15 @@
+name Q11
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/11.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/11.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q12.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q12.benchmark
new file mode 100644
index 0000000000..16d3530dd6
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q12.benchmark
@@ -0,0 +1,15 @@
+name Q12
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/12.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/12.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q13.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q13.benchmark
new file mode 100644
index 0000000000..7ef0d003d0
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q13.benchmark
@@ -0,0 +1,15 @@
+name Q13
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/13.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/13.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q14.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q14.benchmark
new file mode 100644
index 0000000000..748e110835
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q14.benchmark
@@ -0,0 +1,15 @@
+name Q14
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/14.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/14.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q15.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q15.benchmark
new file mode 100644
index 0000000000..3a5c1d6c34
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q15.benchmark
@@ -0,0 +1,15 @@
+name Q15
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/15.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/15.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q16.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q16.benchmark
new file mode 100644
index 0000000000..e9cf989f4f
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q16.benchmark
@@ -0,0 +1,15 @@
+name Q16
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/16.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/16.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q17.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q17.benchmark
new file mode 100644
index 0000000000..5a9eb9ab11
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q17.benchmark
@@ -0,0 +1,15 @@
+name Q17
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/17.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/17.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q18.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q18.benchmark
new file mode 100644
index 0000000000..eca4093edc
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q18.benchmark
@@ -0,0 +1,15 @@
+name Q18
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/18.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/18.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q19.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q19.benchmark
new file mode 100644
index 0000000000..385524636d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q19.benchmark
@@ -0,0 +1,15 @@
+name Q19
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/19.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/19.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q20.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q20.benchmark
new file mode 100644
index 0000000000..f05d816382
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q20.benchmark
@@ -0,0 +1,15 @@
+name Q20
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/20.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/20.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q21.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q21.benchmark
new file mode 100644
index 0000000000..98ed74677a
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q21.benchmark
@@ -0,0 +1,15 @@
+name Q21
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/21.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/21.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q22.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q22.benchmark
new file mode 100644
index 0000000000..e1eccfc852
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q22.benchmark
@@ -0,0 +1,15 @@
+name Q22
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/22.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/22.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q23.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q23.benchmark
new file mode 100644
index 0000000000..47153714ac
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q23.benchmark
@@ -0,0 +1,15 @@
+name Q23
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/23.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/23.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q24.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q24.benchmark
new file mode 100644
index 0000000000..05540a4606
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q24.benchmark
@@ -0,0 +1,15 @@
+name Q24
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/24.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/24.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q25.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q25.benchmark
new file mode 100644
index 0000000000..0c0a0f8ce8
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q25.benchmark
@@ -0,0 +1,15 @@
+name Q25
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/25.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/25.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q26.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q26.benchmark
new file mode 100644
index 0000000000..8481c3b660
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q26.benchmark
@@ -0,0 +1,15 @@
+name Q26
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/26.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/26.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q27.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q27.benchmark
new file mode 100644
index 0000000000..2357a8aae8
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q27.benchmark
@@ -0,0 +1,15 @@
+name Q27
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/27.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/27.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q28.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q28.benchmark
new file mode 100644
index 0000000000..f4cbce1430
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q28.benchmark
@@ -0,0 +1,15 @@
+name Q28
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/28.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/28.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q29.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q29.benchmark
new file mode 100644
index 0000000000..77b9b05812
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q29.benchmark
@@ -0,0 +1,15 @@
+name Q29
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/29.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/29.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q30.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q30.benchmark
new file mode 100644
index 0000000000..e7c144674d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q30.benchmark
@@ -0,0 +1,15 @@
+name Q30
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/30.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/30.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q31.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q31.benchmark
new file mode 100644
index 0000000000..84f2b0ba5e
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q31.benchmark
@@ -0,0 +1,15 @@
+name Q31
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/31.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/31.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q32.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q32.benchmark
new file mode 100644
index 0000000000..42b995ac66
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q32.benchmark
@@ -0,0 +1,15 @@
+name Q32
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/32.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/32.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q33.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q33.benchmark
new file mode 100644
index 0000000000..ad3c21990c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q33.benchmark
@@ -0,0 +1,15 @@
+name Q33
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/33.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/33.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q34.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q34.benchmark
new file mode 100644
index 0000000000..af74cd4abd
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q34.benchmark
@@ -0,0 +1,15 @@
+name Q34
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/34.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/34.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q35.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q35.benchmark
new file mode 100644
index 0000000000..62ae55e6b8
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q35.benchmark
@@ -0,0 +1,15 @@
+name Q35
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/35.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/35.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q36.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q36.benchmark
new file mode 100644
index 0000000000..c1d1ee9ebc
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q36.benchmark
@@ -0,0 +1,15 @@
+name Q36
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/36.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/36.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q37.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q37.benchmark
new file mode 100644
index 0000000000..47dfb92293
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q37.benchmark
@@ -0,0 +1,15 @@
+name Q37
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/37.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/37.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q38.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q38.benchmark
new file mode 100644
index 0000000000..14616a6abf
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q38.benchmark
@@ -0,0 +1,15 @@
+name Q38
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/38.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/38.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q39.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q39.benchmark
new file mode 100644
index 0000000000..12c02d8135
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q39.benchmark
@@ -0,0 +1,15 @@
+name Q39
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/39.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/39.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q40.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q40.benchmark
new file mode 100644
index 0000000000..c5e787bbb0
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q40.benchmark
@@ -0,0 +1,15 @@
+name Q40
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/40.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/40.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q41.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q41.benchmark
new file mode 100644
index 0000000000..bc1daf4f55
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q41.benchmark
@@ -0,0 +1,15 @@
+name Q41
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/41.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/41.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q42.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q42.benchmark
new file mode 100644
index 0000000000..1054b6223c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q42.benchmark
@@ -0,0 +1,15 @@
+name Q42
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/42.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/42.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q43.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q43.benchmark
new file mode 100644
index 0000000000..902ebcbe0d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q43.benchmark
@@ -0,0 +1,15 @@
+name Q43
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/43.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/43.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q44.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q44.benchmark
new file mode 100644
index 0000000000..620b7c4f9e
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q44.benchmark
@@ -0,0 +1,15 @@
+name Q44
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/44.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/44.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q45.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q45.benchmark
new file mode 100644
index 0000000000..7d5cc3d05d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q45.benchmark
@@ -0,0 +1,15 @@
+name Q45
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/45.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/45.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q46.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q46.benchmark
new file mode 100644
index 0000000000..398921d091
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q46.benchmark
@@ -0,0 +1,15 @@
+name Q46
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/46.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/46.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q47.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q47.benchmark
new file mode 100644
index 0000000000..7a14ecf23c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q47.benchmark
@@ -0,0 +1,15 @@
+name Q47
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/47.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/47.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q48.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q48.benchmark
new file mode 100644
index 0000000000..c60972b34d
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q48.benchmark
@@ -0,0 +1,15 @@
+name Q48
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/48.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/48.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q49.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q49.benchmark
new file mode 100644
index 0000000000..ebfdce644c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q49.benchmark
@@ -0,0 +1,15 @@
+name Q49
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/49.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/49.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q50.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q50.benchmark
new file mode 100644
index 0000000000..bf8056b7d1
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q50.benchmark
@@ -0,0 +1,15 @@
+name Q50
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/50.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/50.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q51.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q51.benchmark
new file mode 100644
index 0000000000..90982ca601
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q51.benchmark
@@ -0,0 +1,15 @@
+name Q51
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/51.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/51.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q52.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q52.benchmark
new file mode 100644
index 0000000000..ed9d4ea86b
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q52.benchmark
@@ -0,0 +1,15 @@
+name Q52
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/52.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/52.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q53.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q53.benchmark
new file mode 100644
index 0000000000..b77eac22c9
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q53.benchmark
@@ -0,0 +1,15 @@
+name Q53
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/53.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/53.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q54.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q54.benchmark
new file mode 100644
index 0000000000..83bb72e103
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q54.benchmark
@@ -0,0 +1,15 @@
+name Q54
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/54.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/54.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q55.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q55.benchmark
new file mode 100644
index 0000000000..41ce8b54e4
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q55.benchmark
@@ -0,0 +1,15 @@
+name Q55
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/55.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/55.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q56.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q56.benchmark
new file mode 100644
index 0000000000..5fead000b5
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q56.benchmark
@@ -0,0 +1,15 @@
+name Q56
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/56.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/56.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q57.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q57.benchmark
new file mode 100644
index 0000000000..78368b6057
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q57.benchmark
@@ -0,0 +1,15 @@
+name Q57
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/57.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/57.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q58.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q58.benchmark
new file mode 100644
index 0000000000..6d3e80b4bf
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q58.benchmark
@@ -0,0 +1,15 @@
+name Q58
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/58.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/58.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q59.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q59.benchmark
new file mode 100644
index 0000000000..33bcd35d3f
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q59.benchmark
@@ -0,0 +1,15 @@
+name Q59
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/59.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/59.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q60.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q60.benchmark
new file mode 100644
index 0000000000..766e1eb101
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q60.benchmark
@@ -0,0 +1,15 @@
+name Q60
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/60.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/60.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q61.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q61.benchmark
new file mode 100644
index 0000000000..0c41e1ef0c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q61.benchmark
@@ -0,0 +1,15 @@
+name Q61
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/61.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/61.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q62.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q62.benchmark
new file mode 100644
index 0000000000..e097f807d2
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q62.benchmark
@@ -0,0 +1,15 @@
+name Q62
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/62.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/62.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q63.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q63.benchmark
new file mode 100644
index 0000000000..b2cee6313e
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q63.benchmark
@@ -0,0 +1,15 @@
+name Q63
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/63.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/63.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q64.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q64.benchmark
new file mode 100644
index 0000000000..5116830e58
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q64.benchmark
@@ -0,0 +1,15 @@
+name Q64
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/64.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/64.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q65.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q65.benchmark
new file mode 100644
index 0000000000..eb33f20a55
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q65.benchmark
@@ -0,0 +1,15 @@
+name Q65
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/65.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/65.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q66.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q66.benchmark
new file mode 100644
index 0000000000..f9bedd5474
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q66.benchmark
@@ -0,0 +1,15 @@
+name Q66
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/66.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/66.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q67.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q67.benchmark
new file mode 100644
index 0000000000..1d387a7fb6
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q67.benchmark
@@ -0,0 +1,15 @@
+name Q67
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/67.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/67.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q68.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q68.benchmark
new file mode 100644
index 0000000000..e5303d6543
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q68.benchmark
@@ -0,0 +1,15 @@
+name Q68
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/68.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/68.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q69.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q69.benchmark
new file mode 100644
index 0000000000..bc0e043af2
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q69.benchmark
@@ -0,0 +1,15 @@
+name Q69
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/69.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/69.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q70.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q70.benchmark
new file mode 100644
index 0000000000..345a17db0b
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q70.benchmark
@@ -0,0 +1,15 @@
+name Q70
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/70.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/70.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q71.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q71.benchmark
new file mode 100644
index 0000000000..4dd7d2f90e
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q71.benchmark
@@ -0,0 +1,15 @@
+name Q71
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/71.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/71.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q72.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q72.benchmark
new file mode 100644
index 0000000000..15faf7eb4c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q72.benchmark
@@ -0,0 +1,15 @@
+name Q72
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/72.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/72.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q73.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q73.benchmark
new file mode 100644
index 0000000000..5579742338
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q73.benchmark
@@ -0,0 +1,15 @@
+name Q73
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/73.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/73.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q74.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q74.benchmark
new file mode 100644
index 0000000000..a40113a16f
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q74.benchmark
@@ -0,0 +1,15 @@
+name Q74
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/74.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/74.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q75.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q75.benchmark
new file mode 100644
index 0000000000..6e11461c2f
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q75.benchmark
@@ -0,0 +1,15 @@
+name Q75
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/75.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/75.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q76.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q76.benchmark
new file mode 100644
index 0000000000..281d651290
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q76.benchmark
@@ -0,0 +1,15 @@
+name Q76
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/76.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/76.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q77.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q77.benchmark
new file mode 100644
index 0000000000..42d3518239
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q77.benchmark
@@ -0,0 +1,15 @@
+name Q77
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/77.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/77.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q78.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q78.benchmark
new file mode 100644
index 0000000000..03ea2b583b
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q78.benchmark
@@ -0,0 +1,15 @@
+name Q78
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/78.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/78.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q79.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q79.benchmark
new file mode 100644
index 0000000000..151ee27b39
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q79.benchmark
@@ -0,0 +1,15 @@
+name Q79
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/79.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/79.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q80.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q80.benchmark
new file mode 100644
index 0000000000..9f6809fa36
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q80.benchmark
@@ -0,0 +1,15 @@
+name Q80
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/80.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/80.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q81.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q81.benchmark
new file mode 100644
index 0000000000..bd5bfec578
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q81.benchmark
@@ -0,0 +1,15 @@
+name Q81
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/81.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/81.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q82.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q82.benchmark
new file mode 100644
index 0000000000..7fce855ac6
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q82.benchmark
@@ -0,0 +1,15 @@
+name Q82
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/82.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/82.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q83.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q83.benchmark
new file mode 100644
index 0000000000..c39cf514a9
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q83.benchmark
@@ -0,0 +1,15 @@
+name Q83
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/83.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/83.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q84.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q84.benchmark
new file mode 100644
index 0000000000..8debc4f705
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q84.benchmark
@@ -0,0 +1,15 @@
+name Q84
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/84.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/84.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q85.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q85.benchmark
new file mode 100644
index 0000000000..050e1efcdc
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q85.benchmark
@@ -0,0 +1,15 @@
+name Q85
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/85.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/85.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q86.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q86.benchmark
new file mode 100644
index 0000000000..53b65089e3
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q86.benchmark
@@ -0,0 +1,15 @@
+name Q86
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/86.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/86.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q87.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q87.benchmark
new file mode 100644
index 0000000000..71021946c8
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q87.benchmark
@@ -0,0 +1,15 @@
+name Q87
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/87.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/87.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q88.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q88.benchmark
new file mode 100644
index 0000000000..49e07041e4
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q88.benchmark
@@ -0,0 +1,15 @@
+name Q88
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/88.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/88.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q89.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q89.benchmark
new file mode 100644
index 0000000000..2256006201
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q89.benchmark
@@ -0,0 +1,15 @@
+name Q89
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/89.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/89.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q90.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q90.benchmark
new file mode 100644
index 0000000000..d95d5ff3e2
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q90.benchmark
@@ -0,0 +1,15 @@
+name Q90
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/90.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/90.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q91.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q91.benchmark
new file mode 100644
index 0000000000..e82bfc5d4c
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q91.benchmark
@@ -0,0 +1,15 @@
+name Q91
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/91.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/91.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q92.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q92.benchmark
new file mode 100644
index 0000000000..bc7b9236bf
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q92.benchmark
@@ -0,0 +1,15 @@
+name Q92
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/92.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/92.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q93.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q93.benchmark
new file mode 100644
index 0000000000..0b9645f9cb
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q93.benchmark
@@ -0,0 +1,15 @@
+name Q93
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/93.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/93.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q94.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q94.benchmark
new file mode 100644
index 0000000000..f5932537fd
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q94.benchmark
@@ -0,0 +1,15 @@
+name Q94
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/94.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/94.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q95.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q95.benchmark
new file mode 100644
index 0000000000..3eda91c9ba
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q95.benchmark
@@ -0,0 +1,15 @@
+name Q95
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/95.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/95.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q96.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q96.benchmark
new file mode 100644
index 0000000000..caef1b7155
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q96.benchmark
@@ -0,0 +1,15 @@
+name Q96
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/96.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/96.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q97.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q97.benchmark
new file mode 100644
index 0000000000..c81446698b
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q97.benchmark
@@ -0,0 +1,15 @@
+name Q97
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/97.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/97.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q98.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q98.benchmark
new file mode 100644
index 0000000000..b598baa846
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q98.benchmark
@@ -0,0 +1,15 @@
+name Q98
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/98.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/98.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/benchmarks/q99.benchmark b/benchmarks/sql_benchmarks/tpcds/benchmarks/q99.benchmark
new file mode 100644
index 0000000000..d017d447bc
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/benchmarks/q99.benchmark
@@ -0,0 +1,15 @@
+name Q99
+group tpcds
+
+load sql_benchmarks/tpcds/init/load.sql
+
+assert I
+SELECT COUNT(*) > 0 from web_site;
+----
+true
+
+run ../datafusion/core/tests/tpc-ds/99.sql
+
+result sql_benchmarks/tpcds/results/sf${BENCH_SIZE:-1}/99.csv
+
+cleanup sql_benchmarks/tpcds/init/cleanup.sql
diff --git a/benchmarks/sql_benchmarks/tpcds/init/cleanup.sql b/benchmarks/sql_benchmarks/tpcds/init/cleanup.sql
new file mode 100644
index 0000000000..2a6ed79c51
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/init/cleanup.sql
@@ -0,0 +1,47 @@
+DROP TABLE IF EXISTS call_center;
+
+DROP TABLE IF EXISTS catalog_page;
+
+DROP TABLE IF EXISTS catalog_returns;
+
+DROP TABLE IF EXISTS catalog_sales;
+
+DROP TABLE IF EXISTS customer;
+
+DROP TABLE IF EXISTS customer_address;
+
+DROP TABLE IF EXISTS customer_demographics;
+
+DROP TABLE IF EXISTS date_dim;
+
+DROP TABLE IF EXISTS household_demographics;
+
+DROP TABLE IF EXISTS income_band;
+
+DROP TABLE IF EXISTS inventory;
+
+DROP TABLE IF EXISTS item;
+
+DROP TABLE IF EXISTS promotion;
+
+DROP TABLE IF EXISTS reason;
+
+DROP TABLE IF EXISTS ship_mode;
+
+DROP TABLE IF EXISTS store;
+
+DROP TABLE IF EXISTS store_returns;
+
+DROP TABLE IF EXISTS store_sales;
+
+DROP TABLE IF EXISTS time_dim;
+
+DROP TABLE IF EXISTS warehouse;
+
+DROP TABLE IF EXISTS web_page;
+
+DROP TABLE IF EXISTS web_returns;
+
+DROP TABLE IF EXISTS web_sales;
+
+DROP TABLE IF EXISTS web_site;
diff --git a/benchmarks/sql_benchmarks/tpcds/init/load.sql b/benchmarks/sql_benchmarks/tpcds/init/load.sql
new file mode 100644
index 0000000000..6b89199646
--- /dev/null
+++ b/benchmarks/sql_benchmarks/tpcds/init/load.sql
@@ -0,0 +1,47 @@
+CREATE EXTERNAL TABLE call_center STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/call_center.parquet';
+
+CREATE EXTERNAL TABLE catalog_page STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/catalog_page.parquet';
+
+CREATE EXTERNAL TABLE catalog_returns STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/catalog_returns.parquet';
+
+CREATE EXTERNAL TABLE catalog_sales STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/catalog_sales.parquet';
+
+CREATE EXTERNAL TABLE customer STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/customer.parquet';
+
+CREATE EXTERNAL TABLE customer_address STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/customer_address.parquet';
+
+CREATE EXTERNAL TABLE customer_demographics STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/customer_demographics.parquet';
+
+CREATE EXTERNAL TABLE date_dim STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/date_dim.parquet';
+
+CREATE EXTERNAL TABLE household_demographics STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/household_demographics.parquet';
+
+CREATE EXTERNAL TABLE income_band STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/income_band.parquet';
+
+CREATE EXTERNAL TABLE inventory STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/inventory.parquet';
+
+CREATE EXTERNAL TABLE item STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/item.parquet';
+
+CREATE EXTERNAL TABLE promotion STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/promotion.parquet';
+
+CREATE EXTERNAL TABLE reason STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/reason.parquet';
+
+CREATE EXTERNAL TABLE ship_mode STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/ship_mode.parquet';
+
+CREATE EXTERNAL TABLE store STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/store.parquet';
+
+CREATE EXTERNAL TABLE store_returns STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/store_returns.parquet';
+
+CREATE EXTERNAL TABLE store_sales STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/store_sales.parquet';
+
+CREATE EXTERNAL TABLE time_dim STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/time_dim.parquet';
+
+CREATE EXTERNAL TABLE warehouse STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/warehouse.parquet';
+
+CREATE EXTERNAL TABLE web_page STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/web_page.parquet';
+
+CREATE EXTERNAL TABLE web_returns STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/web_returns.parquet';
+
+CREATE EXTERNAL TABLE web_sales STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/web_sales.parquet';
+
+CREATE EXTERNAL TABLE web_site STORED AS PARQUET LOCATION '${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/web_site.parquet';
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org