|
| 1 | +echo Loading tpch items sorted: ${BENCH_SORTED:-false} |
| 2 | + |
| 3 | +# |
| 4 | +# Sort queries with different characteristics: |
| 5 | +# - Sort key with fixed length or variable length (VARCHAR) |
| 6 | +# - Sort key with different cardinality |
| 7 | +# - Different number of sort keys |
| 8 | +# - Different number of payload columns (thin: 1 additional column other |
| 9 | +# than sort keys; wide: all columns except sort keys) |
| 10 | +# |
| 11 | +# DataSet is `lineitem` table in TPCH dataset (16 columns, 6M rows for |
| 12 | +# scale factor 1.0, cardinality is counted from SF1 dataset) |
| 13 | +# |
| 14 | +# Key Columns: |
| 15 | +# - Column `l_linenumber`, type: `INTEGER`, cardinality: 7 |
| 16 | +# - Column `l_suppkey`, type: `BIGINT`, cardinality: 10k |
| 17 | +# - Column `l_orderkey`, type: `BIGINT`, cardinality: 1.5M |
| 18 | +# - Column `l_comment`, type: `VARCHAR`, cardinality: 4.5M (len is ~26 chars) |
| 19 | +# |
| 20 | +# Payload Columns: |
| 21 | +# - Thin variant: `l_partkey` column with `BIGINT` type (1 column) |
| 22 | +# - Wide variant: all columns except for possible key columns (12 columns) |
| 23 | + |
| 24 | +name Q08 |
| 25 | +group sort_tpch |
| 26 | +subgroup sf${BENCH_SIZE:-1} |
| 27 | + |
| 28 | +echo Loading sort_tpch sf ${BENCH_SIZE:-1} data |
| 29 | + |
| 30 | +load sql_benchmarks/sort_tpch/init/load.sql |
| 31 | + |
| 32 | +assert I |
| 33 | +SELECT COUNT(*) > 0 from lineitem; |
| 34 | +---- |
| 35 | +true |
| 36 | + |
| 37 | +run |
| 38 | +-- Q8: 4 sort keys {(BIGINT, 1.5M), (BIGINT, 10k), (INTEGER, 7), (VARCHAR, 4.5M)} + no payload column |
| 39 | +SELECT l_orderkey, l_suppkey, l_linenumber, l_comment |
| 40 | +FROM lineitem |
| 41 | +ORDER BY l_orderkey, l_suppkey, l_linenumber, l_comment |
| 42 | +${LIMIT:-false|LIMIT 100| } |
| 43 | + |
| 44 | +result sql_benchmarks/sort_tpch/results/sf${BENCH_SIZE:-1}/q08.csv |
0 commit comments