TPC-Havoc Query Templates

TPC-Havoc overview

Representative SQL and DataFrame renderings for each of the 220 TPC-Havoc 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 groups

• queries 1-25 (25)
• queries 26-50 (25)
• queries 51-75 (25)
• queries 76-100 (25)
• queries 101-125 (25)
• queries 126-150 (25)
• queries 151-175 (25)
• queries 176-200 (25)
• queries 201-220 (20)