TPC-H Data Vault Query Templates
Representative SQL and DataFrame renderings for each of the 22 TPC-H Data Vault queries. Every page also shows how to extract the exact query for a given platform and scale.
TPC Benchmark, TPC-H, TPC-DS, and TPC-DI are trademarks of the Transaction Processing Performance Council. Query text shown here is derived from TPC materials.
| Query | Name |
|---|---|
| Q1 | Pricing Summary Report |
| Q2 | Minimum Cost Supplier |
| Q3 | Shipping Priority |
| Q4 | Order Priority Checking |
| Q5 | Local Supplier Volume |
| Q6 | Forecasting Revenue Change |
| Q7 | Volume Shipping |
| Q8 | National Market Share |
| Q9 | Product Type Profit Measure |
| Q10 | Returned Item Reporting |
| Q11 | Important Stock Identification |
| Q12 | Shipping Modes and Order Priority |
| Q13 | Customer Distribution |
| Q14 | Promotion Effect |
| Q15 | Top Supplier |
| Q16 | Parts/Supplier Relationship |
| Q17 | Small-Quantity-Order Revenue |
| Q18 | Large Volume Customer |
| Q19 | Discounted Revenue |
| Q20 | Potential Part Promotion |
| Q21 | Suppliers Who Kept Orders Waiting |
| Q22 | Global Sales Opportunity |