Skip to content

Commit 11caa4c

Browse files
Omega359adriangbCopilot
authored
Add clickbench SQL benchmark (apache#22633)
## Which issue does this PR close? <!-- We generally require a GitHub issue to be filed for all bug fixes and enhancements and this helps us generate change logs for our releases. You can link an issue to this PR using the GitHub syntax. For example `Closes apache#123` indicates that this PR will close issue apache#123. --> Part of apache#21706 ## Rationale for this change Continue work on sql benchmark migration. ## What changes are included in this PR? Clickbench sql benchmark. ## Are these changes tested? Yes BENCH_NAME=clickbench CLICKBENCH_TYPE=single cargo bench --bench sql BENCH_NAME=clickbench CLICKBENCH_TYPE=partitioned cargo bench --bench sql ## Are there any user-facing changes? no --------- Co-authored-by: Adrian Garcia Badaracco <[email protected]> Co-authored-by: Copilot Autofix powered by AI <[email protected]>
1 parent 031360d commit 11caa4c

46 files changed

Lines changed: 805 additions & 0 deletions

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q00
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT COUNT(*)
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q00.csv
Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,18 @@
1+
name Q01
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT COUNT(*)
15+
FROM hits
16+
WHERE "AdvEngineID" <> 0;
17+
18+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q01.csv
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q02
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT SUM("AdvEngineID"), COUNT(*), AVG("ResolutionWidth")
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q02.csv
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q03
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT AVG("UserID")
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q03.csv
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q04
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT COUNT(DISTINCT "UserID")
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q04.csv
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q05
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT COUNT(DISTINCT "SearchPhrase")
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q05.csv
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
name Q06
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT MIN("EventDate"), MAX("EventDate")
15+
FROM hits;
16+
17+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q06.csv
Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
name Q07
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT "AdvEngineID", COUNT(*)
15+
FROM hits
16+
WHERE "AdvEngineID" <> 0
17+
GROUP BY "AdvEngineID"
18+
ORDER BY COUNT(*) DESC;
19+
20+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q07.csv
Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
name Q08
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT "RegionID", COUNT(DISTINCT "UserID") AS u FROM hits GROUP BY "RegionID" ORDER BY u DESC LIMIT 10;
15+
16+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q08.csv
Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
name Q09
2+
group clickbench
3+
4+
init sql_benchmarks/clickbench/init/set_config.sql
5+
6+
load sql_benchmarks/clickbench/init/load-${CLICKBENCH_TYPE:-single}.sql
7+
8+
assert I
9+
SELECT COUNT(*) > 0 from hits;
10+
----
11+
true
12+
13+
run
14+
SELECT "RegionID", SUM("AdvEngineID"), COUNT(*) AS c, AVG("ResolutionWidth"), COUNT(DISTINCT "UserID") FROM hits GROUP BY "RegionID" ORDER BY c DESC LIMIT 10;
15+
16+
result sql_benchmarks/clickbench/results/${CLICKBENCH_TYPE:-single}/q09.csv

0 commit comments

Comments
 (0)