Skip to content

appian

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

appian

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
q1.sql
q1.sql
 
 
q2.sql
q2.sql
 
 
q3.sql
q3.sql
 
 
q4.sql
q4.sql
 
 
q5.sql
q5.sql
 
 
q6.sql
q6.sql
 
 
q7.sql
q7.sql
 
 
q8.sql
q8.sql
 
 

README.md

Appian benchmark

Mirrors the queries from DuckDB's in-tree appian_benchmarks suite — a real-world business-application workload (customers, orders, addresses) with selective filters and joins over camelCase-named columns.

The eight queries live in this directory (q1.sql ... q8.sql). Upstream ships the data as a single .duckdb blob (~593 MB); the harness downloads it once and projects each table into Parquet with lowercased column names so that DataFusion and DuckDB resolve the verbatim queries identically — see src/appian for the details.

CI variant

CI runs this suite from local NVMe as the Appian on NVME PR comment, comparing DataFusion and DuckDB over Parquet and Vortex files (plus a native DuckDB baseline).

Running locally

vx-bench run appian --engine datafusion,duckdb --format parquet,vortex