Repository navigation
Commit 0d3fb77
Add h2o SQL benchmark (apache#22660)
## Which issue does this PR close?
Part of apache#21706
## Rationale for this change
Continue work on sql benchmark migration.
## What changes are included in this PR?
h2o sql benchmark
## Are these changes tested?
Yes
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=small
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=small
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=small
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=small
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=small
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=small
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=medium
H2O_FILE_TYPE=parquet cargo bench --bench sql`
I was unable to run the following because of limited memory:
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=big
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=groupby H2O_BENCH_SIZE=big
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=big H2O_FILE_TYPE=csv
cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=join H2O_BENCH_SIZE=big
H2O_FILE_TYPE=parquet cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=big
H2O_FILE_TYPE=csv cargo bench --bench sql`
`BENCH_NAME=h2o BENCH_SUBGROUP=window H2O_BENCH_SIZE=big
H2O_FILE_TYPE=parquet cargo bench --bench sql`
## Are there any user-facing changes?
No
---------
Co-authored-by: Andrew Lamb <[email protected]>1 parent 1465d6f commit 0d3fb77
45 files changed
Lines changed: 709 additions & 0 deletions
File tree
- benchmarks/sql_benchmarks/h2o
- benchmarks
- groupby
- join
- window
- init
Some content is hidden
Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| 21 | + | |
| 22 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
| 19 | + | |
| 20 | + | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
| 1 | + | |
| 2 | + | |
| 3 | + | |
| 4 | + | |
| 5 | + | |
| 6 | + | |
| 7 | + | |
| 8 | + | |
| 9 | + | |
| 10 | + | |
| 11 | + | |
| 12 | + | |
| 13 | + | |
| 14 | + | |
| 15 | + | |
| 16 | + | |
| 17 | + | |
| 18 | + | |
0 commit comments