Skip to content

tpcds

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

tpcds

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
01.sql
01.sql
 
 
02.sql
02.sql
 
 
03.sql
03.sql
 
 
04.sql
04.sql
 
 
05.sql
05.sql
 
 
06.sql
06.sql
 
 
07.sql
07.sql
 
 
08.sql
08.sql
 
 
09.sql
09.sql
 
 
10.sql
10.sql
 
 
11.sql
11.sql
 
 
12.sql
12.sql
 
 
13.sql
13.sql
 
 
14.sql
14.sql
 
 
15.sql
15.sql
 
 
16.sql
16.sql
 
 
17.sql
17.sql
 
 
18.sql
18.sql
 
 
19.sql
19.sql
 
 
20.sql
20.sql
 
 
21.sql
21.sql
 
 
22.sql
22.sql
 
 
23.sql
23.sql
 
 
24.sql
24.sql
 
 
25.sql
25.sql
 
 
26.sql
26.sql
 
 
27.sql
27.sql
 
 
28.sql
28.sql
 
 
29.sql
29.sql
 
 
30.sql
30.sql
 
 
31.sql
31.sql
 
 
32.sql
32.sql
 
 
33.sql
33.sql
 
 
34.sql
34.sql
 
 
35.sql
35.sql
 
 
36.sql
36.sql
 
 
37.sql
37.sql
 
 
38.sql
38.sql
 
 
39.sql
39.sql
 
 
40.sql
40.sql
 
 
41.sql
41.sql
 
 
42.sql
42.sql
 
 
43.sql
43.sql
 
 
44.sql
44.sql
 
 
45.sql
45.sql
 
 
46.sql
46.sql
 
 
47.sql
47.sql
 
 
48.sql
48.sql
 
 
49.sql
49.sql
 
 
50.sql
50.sql
 
 
51.sql
51.sql
 
 
52.sql
52.sql
 
 
53.sql
53.sql
 
 
54.sql
54.sql
 
 
55.sql
55.sql
 
 
56.sql
56.sql
 
 
57.sql
57.sql
 
 
58.sql
58.sql
 
 
59.sql
59.sql
 
 
60.sql
60.sql
 
 
61.sql
61.sql
 
 
62.sql
62.sql
 
 
63.sql
63.sql
 
 
64.sql
64.sql
 
 
65.sql
65.sql
 
 
66.sql
66.sql
 
 
67.sql
67.sql
 
 
68.sql
68.sql
 
 
69.sql
69.sql
 
 
70.sql
70.sql
 
 
71.sql
71.sql
 
 
72.sql
72.sql
 
 
73.sql
73.sql
 
 
74.sql
74.sql
 
 
75.sql
75.sql
 
 
76.sql
76.sql
 
 
77.sql
77.sql
 
 
78.sql
78.sql
 
 
79.sql
79.sql
 
 
80.sql
80.sql
 
 
81.sql
81.sql
 
 
82.sql
82.sql
 
 
83.sql
83.sql
 
 
84.sql
84.sql
 
 
85.sql
85.sql
 
 
86.sql
86.sql
 
 
87.sql
87.sql
 
 
88.sql
88.sql
 
 
89.sql
89.sql
 
 
90.sql
90.sql
 
 
91.sql
91.sql
 
 
92.sql
92.sql
 
 
93.sql
93.sql
 
 
94.sql
94.sql
 
 
95.sql
95.sql
 
 
96.sql
96.sql
 
 
97.sql
97.sql
 
 
98.sql
98.sql
 
 
99.sql
99.sql
 
 
README.md
README.md
 
 

README.md

TPC-DS benchmark

The industry-standard TPC-DS decision-support benchmark: 99 analytical queries (01.sql ... 99.sql) over a retail snowflake schema. Compared to TPC-H it has many more queries, a wider schema, and heavier use of joins, subqueries, and window functions, making it a broad regression net for scan and pushdown behavior.

The benchmark harness lives in src/tpcds.

CI variant

CI runs this suite at scale factor 1 from local NVMe as the TPC-DS SF=1 on NVME PR comment, comparing DataFusion and DuckDB over Parquet, Vortex, and vortex-compact files (plus a native DuckDB baseline).

Running locally

vx-bench run tpcds --engine datafusion,duckdb --format parquet,vortex --opt scale-factor=1.0