Tagged with: reference

Pages with this tag

• API Reference
• Academic Benchmarks
• AI & ML Benchmarks
• BenchBox Experimental
• BenchBox Primitives
• Industry Benchmarks
• AI Primitives embedding_batch
• AI Primitives embedding_large_dimension
• AI Primitives embedding_single
• AI Primitives generative_complete_customer_profile
• AI Primitives generative_complete_simple
• AI Primitives generative_question_answer
• AI Primitives generative_sql_generation
• AI Primitives Query Templates
• AI Primitives nlp_classify_priority
• AI Primitives nlp_classify_segment
• AI Primitives nlp_entity_extraction
• AI Primitives nlp_sentiment_batch
• AI Primitives nlp_sentiment_single
• AI Primitives transform_grammar_fix
• AI Primitives transform_summarize_long
• AI Primitives transform_summarize_short
• AI Primitives transform_translate_comment
• AMPLab Query Templates
• AMPLab Q1 — Scan Query
• AMPLab Q1a — Scan Aggregation
• AMPLab Q2 — Join Query
• AMPLab Q2a — Join with Filter
• AMPLab Q3 — Text Search
• AMPLab Q3a — Document Analysis
• AMPLab Q4 — Country/Language Analytics
• AMPLab Q5 — Cross-Table Analytics
• ClickBench Query Templates — basic_aggregation
• ClickBench Query Templates — complex_grouping
• ClickBench Query Templates — grouping_and_ordering
• ClickBench Query Templates — mathematical_operations
• ClickBench Query Templates — string_operations
• ClickBench Query Templates — text_and_pattern_matching
• ClickBench Query Templates — time_based_analysis
• ClickBench Query Templates — user_analysis
• ClickBench Query Templates
• ClickBench — Full Scan Count
• ClickBench — Region Multi-Aggregate
• ClickBench — Mobile Phone Models
• ClickBench — Phone + Model Unique Users
• ClickBench — Top Search Phrases
• ClickBench — Search Phrase Unique Users
• ClickBench — Search Engine + Phrase
• ClickBench — Top Users
• ClickBench — User Search Activity
• ClickBench — User Search Unordered
• ClickBench — User Minute Activity
• ClickBench — Filtered Count
• ClickBench — User Point Lookup
• ClickBench — URL Google Count
• ClickBench — Google URL Search Phrases
• ClickBench — Google Title Analysis
• ClickBench — Google URL Full Rows
• ClickBench — Search Phrase by Time
• ClickBench — Search Phrase Lexicographic
• ClickBench — Search Phrase Compound Sort
• ClickBench — URL Length Analysis
• ClickBench — Domain Extraction
• ClickBench — Multi-Aggregate Scan
• ClickBench — Wide Aggregation
• ClickBench — Search Engine Client Analysis
• ClickBench — Watch Client Analysis (Filtered)
• ClickBench — Watch Client Analysis (Unfiltered)
• ClickBench — Top URLs
• ClickBench — Literal Column URL Group
• ClickBench — Derived Column Group
• ClickBench — July URL Page Views
• ClickBench — July Title Page Views
• ClickBench — URL Views with Offset
• ClickBench — Average UserID
• ClickBench — Traffic Source CASE WHEN
• ClickBench — URL Hash IN Clause
• ClickBench — Window Dimensions
• ClickBench — Minute Granularity
• ClickBench — Unique Users
• ClickBench — Unique Search Phrases
• ClickBench — Date Range
• ClickBench — AdvEngine Distribution
• ClickBench — Users by Region
• CoffeeShop Query Templates
• CoffeeShop — Product Mix
• CoffeeShop — Price Band Distribution
• CoffeeShop — Lines per Order
• CoffeeShop — Seasonal Revenue
• CoffeeShop — Daily Revenue by Region
• CoffeeShop — Top Products by Revenue
• CoffeeShop — Monthly Performance
• CoffeeShop — Revenue Share by Region
• CoffeeShop — Top Locations
• CoffeeShop — Day-Part Cadence
• CoffeeShop — Quarterly Trends
• TPC-H Data Vault Query Templates
• TPC-H Data Vault Q1 — Pricing Summary Report
• TPC-H Data Vault Q10 — Returned Item Reporting
• TPC-H Data Vault Q11 — Important Stock Identification
• TPC-H Data Vault Q12 — Shipping Modes and Order Priority
• TPC-H Data Vault Q13 — Customer Distribution
• TPC-H Data Vault Q14 — Promotion Effect
• TPC-H Data Vault Q15 — Top Supplier
• TPC-H Data Vault Q16 — Parts/Supplier Relationship
• TPC-H Data Vault Q17 — Small-Quantity-Order Revenue
• TPC-H Data Vault Q18 — Large Volume Customer
• TPC-H Data Vault Q19 — Discounted Revenue
• TPC-H Data Vault Q2 — Minimum Cost Supplier
• TPC-H Data Vault Q20 — Potential Part Promotion
• TPC-H Data Vault Q21 — Suppliers Who Kept Orders Waiting
• TPC-H Data Vault Q22 — Global Sales Opportunity
• TPC-H Data Vault Q3 — Shipping Priority
• TPC-H Data Vault Q4 — Order Priority Checking
• TPC-H Data Vault Q5 — Local Supplier Volume
• TPC-H Data Vault Q6 — Forecasting Revenue Change
• TPC-H Data Vault Q7 — Volume Shipping
• TPC-H Data Vault Q8 — National Market Share
• TPC-H Data Vault Q9 — Product Type Profit Measure
• Flight Data — Best Performing Routes by On-Time Rate
• Flight Data — Busiest Routes by Flight Count
• Flight Data — Cancellation Rates by Carrier and Cause
• Flight Data — Carrier On-Time Performance Ranking
• Flight Data — Late Aircraft (Cascade) Delay Patterns
• Flight Data — Flight Patterns by Day of Week
• Flight Data — Average Departure Delay by Origin Airport
• Flight Data — Delay Pattern by Departure Hour
• Flight Data — Delay Cause Breakdown
• Flight Data — Distance vs Delay Correlation
• Flight Data — Holiday Period Delay Impact
• Flight Data — Hub Airport Connectivity
• Flight Data — On-Time Performance Trend Over Years
• Flight Data Query Templates
• Flight Data — Carrier Market Share by Route
• Flight Data — On-Time Rate by Carrier
• Flight Data — Delay Recovery Analysis
• Flight Data — Route Reliability Ranking
• Flight Data — Seasonal Performance Trends
• Flight Data — Hourly Congestion Pattern
• Flight Data — Weather Delay Impact by Month
• H2ODB Query Templates
• H2ODB — Count
• H2ODB — Top Pickup Locations
• H2ODB — Sum and Mean
• H2ODB — Sum by Passenger Count
• H2ODB — Sum and Mean by Passenger Count
• H2ODB — Sum by Passenger and Vendor
• H2ODB — Sum and Mean by Passenger and Vendor
• H2ODB — Sum by Hour
• H2ODB — Sum by Year and Hour
• H2ODB — Percentiles by Passenger Count
• Query Templates
• JoinOrder Query Templates — queries 1-25
• JoinOrder Query Templates — queries 101-113
• JoinOrder Query Templates — queries 26-50
• JoinOrder Query Templates — queries 51-75
• JoinOrder Query Templates — queries 76-100
• JoinOrder Query Templates
• JoinOrder Q10a — American Producer Movies
• JoinOrder Q10b — Canonical JoinOrder 10b
• JoinOrder Q10c — Canonical JoinOrder 10c
• JoinOrder Q11a — Non-Polish Sequel Movies with Follow Links
• JoinOrder Q11b — Canonical JoinOrder 11b
• JoinOrder Q11c — Canonical JoinOrder 11c
• JoinOrder Q11d — Canonical JoinOrder 11d
• JoinOrder Q12a — Drama/Horror US Movies with High Ratings
• JoinOrder Q12b — Canonical JoinOrder 12b
• JoinOrder Q12c — Canonical JoinOrder 12c
• JoinOrder Q13a — Canonical JoinOrder 13a
• JoinOrder Q13b — Canonical JoinOrder 13b
• JoinOrder Q13c — Canonical JoinOrder 13c
• JoinOrder Q13d — Canonical JoinOrder 13d
• JoinOrder Q14a — Canonical JoinOrder 14a
• JoinOrder Q14b — Canonical JoinOrder 14b
• JoinOrder Q14c — Canonical JoinOrder 14c
• JoinOrder Q15a — Canonical JoinOrder 15a
• JoinOrder Q15b — Canonical JoinOrder 15b
• JoinOrder Q15c — Canonical JoinOrder 15c
• JoinOrder Q15d — Canonical JoinOrder 15d
• JoinOrder Q16a — Canonical JoinOrder 16a
• JoinOrder Q16b — Canonical JoinOrder 16b
• JoinOrder Q16c — Canonical JoinOrder 16c
• JoinOrder Q16d — Canonical JoinOrder 16d
• JoinOrder Q17a — Canonical JoinOrder 17a
• JoinOrder Q17b — Canonical JoinOrder 17b
• JoinOrder Q17c — Canonical JoinOrder 17c
• JoinOrder Q17d — Canonical JoinOrder 17d
• JoinOrder Q17e — Canonical JoinOrder 17e
• JoinOrder Q17f — Canonical JoinOrder 17f
• JoinOrder Q18a — Canonical JoinOrder 18a
• JoinOrder Q18b — Canonical JoinOrder 18b
• JoinOrder Q18c — Canonical JoinOrder 18c
• JoinOrder Q19a — Canonical JoinOrder 19a
• JoinOrder Q19b — Canonical JoinOrder 19b
• JoinOrder Q19c — Canonical JoinOrder 19c
• JoinOrder Q19d — Canonical JoinOrder 19d
• JoinOrder Q1a — Production Companies Top 250
• JoinOrder Q1b — Production Companies Bottom 10
• JoinOrder Q1c — Canonical JoinOrder 1c
• JoinOrder Q1d — Canonical JoinOrder 1d
• JoinOrder Q20a — Canonical JoinOrder 20a
• JoinOrder Q20b — Canonical JoinOrder 20b
• JoinOrder Q20c — Canonical JoinOrder 20c
• JoinOrder Q21a — Canonical JoinOrder 21a
• JoinOrder Q21b — Canonical JoinOrder 21b
• JoinOrder Q21c — Canonical JoinOrder 21c
• JoinOrder Q22a — Canonical JoinOrder 22a
• JoinOrder Q22b — Canonical JoinOrder 22b
• JoinOrder Q22c — Canonical JoinOrder 22c
• JoinOrder Q22d — Canonical JoinOrder 22d
• JoinOrder Q23a — Canonical JoinOrder 23a
• JoinOrder Q23b — Canonical JoinOrder 23b
• JoinOrder Q23c — Canonical JoinOrder 23c
• JoinOrder Q24a — Canonical JoinOrder 24a
• JoinOrder Q24b — Canonical JoinOrder 24b
• JoinOrder Q25a — Canonical JoinOrder 25a
• JoinOrder Q25b — Canonical JoinOrder 25b
• JoinOrder Q25c — Canonical JoinOrder 25c
• JoinOrder Q26a — Canonical JoinOrder 26a
• JoinOrder Q26b — Canonical JoinOrder 26b
• JoinOrder Q26c — Canonical JoinOrder 26c
• JoinOrder Q27a — Canonical JoinOrder 27a
• JoinOrder Q27b — Canonical JoinOrder 27b
• JoinOrder Q27c — Canonical JoinOrder 27c
• JoinOrder Q28a — Canonical JoinOrder 28a
• JoinOrder Q28b — Canonical JoinOrder 28b
• JoinOrder Q28c — Canonical JoinOrder 28c
• JoinOrder Q29a — Canonical JoinOrder 29a
• JoinOrder Q29b — Canonical JoinOrder 29b
• JoinOrder Q29c — Canonical JoinOrder 29c
• JoinOrder Q2a — German Company Character Name Movies
• JoinOrder Q2b — Canonical JoinOrder 2b
• JoinOrder Q2c — Canonical JoinOrder 2c
• JoinOrder Q2d — Canonical JoinOrder 2d
• JoinOrder Q30a — Canonical JoinOrder 30a
• JoinOrder Q30b — Canonical JoinOrder 30b
• JoinOrder Q30c — Canonical JoinOrder 30c
• JoinOrder Q31a — Canonical JoinOrder 31a
• JoinOrder Q31b — Canonical JoinOrder 31b
• JoinOrder Q31c — Canonical JoinOrder 31c
• JoinOrder Q32a — Canonical JoinOrder 32a
• JoinOrder Q32b — Canonical JoinOrder 32b
• JoinOrder Q33a — Canonical JoinOrder 33a
• JoinOrder Q33b — Canonical JoinOrder 33b
• JoinOrder Q33c — Canonical JoinOrder 33c
• JoinOrder Q3a — Scandinavian/German Sequel Movies
• JoinOrder Q3b — Canonical JoinOrder 3b
• JoinOrder Q3c — Canonical JoinOrder 3c
• JoinOrder Q4a — Sequel Movies with High Rating
• JoinOrder Q4b — Canonical JoinOrder 4b
• JoinOrder Q4c — Canonical JoinOrder 4c
• JoinOrder Q5a — European Theatrical Movies
• JoinOrder Q5b — Canonical JoinOrder 5b
• JoinOrder Q5c — Canonical JoinOrder 5c
• JoinOrder Q6a — Superhero Movies with Robert Downey Jr.
• JoinOrder Q6b — Canonical JoinOrder 6b
• JoinOrder Q6c — Canonical JoinOrder 6c
• JoinOrder Q6d — Canonical JoinOrder 6d
• JoinOrder Q6e — Canonical JoinOrder 6e
• JoinOrder Q6f — Canonical JoinOrder 6f
• JoinOrder Q7a — Biography Movies with Person Criteria
• JoinOrder Q7b — Canonical JoinOrder 7b
• JoinOrder Q7c — Canonical JoinOrder 7c
• JoinOrder Q8a — Japanese Dubbed Movies
• JoinOrder Q8b — Canonical JoinOrder 8b
• JoinOrder Q8c — Canonical JoinOrder 8c
• JoinOrder Q8d — Canonical JoinOrder 8d
• JoinOrder Q9a — American Voice Actress Movies
• JoinOrder Q9b — Canonical JoinOrder 9b
• JoinOrder Q9c — Canonical JoinOrder 9c
• JoinOrder Q9d — Canonical JoinOrder 9d
• Metadata acl_benchmark_role_grants
• Metadata acl_column_privileges_list
• Metadata acl_grantable_privileges
• Metadata acl_grantee_count_per_table
• Metadata acl_privilege_count_by_type
• Metadata acl_privilege_summary
• Metadata acl_role_list
• Metadata acl_role_membership
• Metadata acl_table_privileges_filtered
• Metadata acl_table_privileges_list
• Metadata acl_tables_with_grants
• Metadata column_count_by_table
• Metadata column_data_types
• Metadata column_for_table
• Metadata column_list_all
• Metadata column_nullable_analysis
• Metadata column_numeric_columns
• Metadata column_search_by_name
• Metadata column_string_columns
• Metadata complex_type_array_columns
• Metadata complex_type_column_list
• Metadata complex_type_distribution
• Metadata complex_type_map_columns
• Metadata complex_type_struct_columns
• Metadata constraint_fk_list
• Metadata constraint_pk_list
• Metadata constraint_referential_integrity
• Metadata constraint_summary
• Metadata Query Templates — acl
• Metadata Query Templates — column
• Metadata Query Templates — complex_type
• Metadata Query Templates — constraint
• Metadata Query Templates — large_catalog
• Metadata Query Templates — query
• Metadata Query Templates — schema
• Metadata Query Templates — stats
• Metadata Query Templates — view_hierarchy
• Metadata Query Templates — wide_table
• Metadata Query Templates
• Metadata large_catalog_column_count
• Metadata large_catalog_column_type_analysis
• Metadata large_catalog_pattern_search
• Metadata large_catalog_schema_summary
• Metadata large_catalog_table_count
• Metadata large_catalog_table_list
• Metadata query_explain_aggregate
• Metadata query_explain_join
• Metadata query_explain_simple
• Metadata query_list_constraints
• Metadata schema_list_schemata
• Metadata schema_list_tables_filtered
• Metadata schema_list_tables
• Metadata schema_list_views
• Metadata schema_object_types
• Metadata schema_recent_tables
• Metadata schema_search_tables
• Metadata schema_table_count
• Metadata schema_tables_by_schema
• Metadata stats_column_count_summary
• Metadata stats_data_type_summary
• Metadata stats_largest_tables
• Metadata stats_row_counts
• Metadata stats_schema_summary
• Metadata stats_table_sizes
• Metadata view_hierarchy_column_introspection
• Metadata view_hierarchy_definition_search
• Metadata view_hierarchy_depth_analysis
• Metadata view_hierarchy_list
• Metadata wide_table_column_count
• Metadata wide_table_column_list
• Metadata wide_table_column_search
• Metadata wide_table_nullable_analysis
• Metadata wide_table_type_distribution
• NYC Taxi — Airport Trips
• NYC Taxi — Borough Summary
• NYC Taxi — Distance Distribution
• NYC Taxi — Fare Distribution
• NYC Taxi — Full Scan Count
• NYC Taxi — Hourly Zone Heatmap
• NYC Taxi Query Templates
• NYC Taxi — Monthly Year-over-Year
• NYC Taxi — Passenger Count Analysis
• NYC Taxi — Rate Code Summary
• NYC Taxi — Revenue by Payment Type
• NYC Taxi — Rush Hour Analysis
• NYC Taxi — Single Day Summary
• NYC Taxi — Surcharge Revenue
• NYC Taxi — Tip Analysis
• NYC Taxi — Top Dropoff Zones
• NYC Taxi — Top Pickup Zones
• NYC Taxi — Top Routes
• NYC Taxi — Trip Duration Analysis
• NYC Taxi — Trips by Day of Week
• NYC Taxi — Trips per Day
• NYC Taxi — Trips per Hour
• NYC Taxi — Trips per Month
• NYC Taxi — Vendor Comparison
• NYC Taxi — Weekday vs Weekend
• NYC Taxi — Zone Detail
• Read Primitives — Distinct Aggregation with Group By
• Read Primitives — Distinct Aggregation
• Read Primitives — Large Cardinality Group By
• Read Primitives — Small Cardinality Group By
• Read Primitives — Subquery Materialization
• Read Primitives — Nested Aggregation
• Read Primitives — Partition Key Aggregation
• Read Primitives — Selective Aggregation
• Read Primitives — Simple Aggregation
• Read Primitives — ANY_VALUE Simple
• Read Primitives — ANY_VALUE with Filter
• Read Primitives — Approximate Distinct Count with Group By
• Read Primitives — Approximate Distinct Count
• Read Primitives — Approximate Median
• Read Primitives approx_quantiles_array
• Read Primitives approx_top_k_lineitem
• Read Primitives — Distinct Array Aggregation
• Read Primitives — Array Aggregation
• Read Primitives — Array Contains
• Read Primitives — Array Distinct
• Read Primitives — Array Length
• Read Primitives — Array Min/Max
• Read Primitives — Array of Struct
• Read Primitives — Array Slice
• Read Primitives — Array Sort
• Read Primitives — Array Unnest
• Read Primitives — ASOF Join Basic
• Read Primitives — Broadcast Join (4 tables)
• Read Primitives — Broadcast Join (3 tables)
• Read Primitives — Broadcast Join (2 tables)
• Read Primitives — Count Star
• Read Primitives — Decimal Arithmetic
• Read Primitives — Empty Build Side Join
• Read Primitives — Exchange Broadcast
• Read Primitives — Exchange Merge
• Read Primitives — Exchange Shuffle
• Read Primitives — Bigint IN List Filter
• Read Primitives — Bigint Non-Selective Filter
• Read Primitives — Bigint Selective Filter
• Read Primitives — Decimal IN List Filter
• Read Primitives — Decimal Non-Selective Filter
• Read Primitives — Decimal Selective Filter
• Read Primitives — IN Predicate with Subquery
• Read Primitives — Low Selectivity Filter
• Read Primitives — High Selectivity Filter
• Read Primitives — String LIKE Filter
• Read Primitives — String Non-Selective Filter
• Read Primitives — String Selective Filter
• Read Primitives — Boolean Text Search
• Read Primitives — Phrase Text Search
• Read Primitives — Simple Text Search
• Read Primitives Query Templates — aggregation
• Read Primitives Query Templates — array
• Read Primitives Query Templates — broadcast
• Read Primitives Query Templates — count
• Read Primitives Query Templates — decimal
• Read Primitives Query Templates — empty
• Read Primitives Query Templates — exchange
• Read Primitives Query Templates — filter
• Read Primitives Query Templates — fulltext
• Read Primitives Query Templates — groupby
• Read Primitives Query Templates — intrinsic
• Read Primitives Query Templates — json
• Read Primitives Query Templates — lambda
• Read Primitives Query Templates — limit
• Read Primitives Query Templates — long
• Read Primitives Query Templates — map
• Read Primitives Query Templates — max
• Read Primitives Query Templates — min
• Read Primitives Query Templates — olap
• Read Primitives Query Templates — optimizer
• Read Primitives Query Templates — orderby
• Read Primitives Query Templates — pivot
• Read Primitives Query Templates — predicate
• Read Primitives Query Templates — qualify
• Read Primitives Query Templates — shuffle
• Read Primitives Query Templates — statistical
• Read Primitives Query Templates — string
• Read Primitives Query Templates — struct
• Read Primitives Query Templates — timeseries
• Read Primitives Query Templates — topn
• Read Primitives Query Templates — window
• Read Primitives — GROUP BY ALL Complex
• Read Primitives — GROUP BY ALL Simple
• Read Primitives — High NDV GroupBy
• Read Primitives — Low NDV GroupBy
• Read Primitives — Primary Key GroupBy
• Read Primitives — High NDV Decimal GroupBy
• Read Primitives — Low NDV Decimal GroupBy
• Read Primitives Query Templates
• Read Primitives — Date Conversion Filter
• Read Primitives — JSON Aggregates
• Read Primitives — JSON Extract Nested
• Read Primitives — JSON Extract Simple
• Read Primitives — Ordered Limit
• Read Primitives — Simple Limit
• Read Primitives — List Filter
• Read Primitives — List Reduce
• Read Primitives — List Transform
• Read Primitives — Long Predicate
• Read Primitives — Map Access
• Read Primitives — Map Construction
• Read Primitives — Map Keys/Values
• Read Primitives — MAX_BY Complex
• Read Primitives — MAX_BY Simple
• Read Primitives — MAX_BY with Ties
• Read Primitives — MIN_BY Complex
• Read Primitives — MIN_BY Simple
• Read Primitives — MIN_BY with Ties
• Read Primitives — Min/Max Runtime Filter
• Read Primitives — OLAP CUBE Analysis
• Read Primitives — OLAP ROLLUP Analysis
• Read Primitives — Optimizer: Aggregate Pushdown
• Read Primitives — Optimizer: Column Pruning
• Read Primitives — Optimizer: Common Subexpression
• Read Primitives — Optimizer: Constant Folding
• Read Primitives — Optimizer: Distinct Elimination
• Read Primitives optimizer_exists_to_semijoin
• Read Primitives — Optimizer: Group-Join Fusion
• Read Primitives optimizer_in_to_exists
• Read Primitives — Optimizer: Join Reordering
• Read Primitives — Optimizer: Limit Pushdown
• Read Primitives — Optimizer: Predicate Pushdown
• Read Primitives — Optimizer: Runtime Filter
• Read Primitives optimizer_scalar_subquery_flattening
• Read Primitives — Optimizer: Union Optimization
• Read Primitives — ORDER BY ALL Descending
• Read Primitives — ORDER BY ALL Simple
• Read Primitives — Full Table Order By
• Read Primitives — Expression Order By
• Read Primitives — Bigint Order By
• Read Primitives — Decimal Order By
• Read Primitives — Descending Order By
• Read Primitives — Multi-Column Order By
• Read Primitives — Multi-Column Complex Order By
• Read Primitives — Short Strings Order By
• Read Primitives — Simple Order By
• Read Primitives — Basic Pivot
• Read Primitives — Predicate Ordering with GroupBy
• Read Primitives — Predicate Ordering with Aggregation
• Read Primitives — Predicate Ordering Costs
• Read Primitives — Predicate Ordering with Subquery
• Read Primitives — QUALIFY CUME_DIST
• Read Primitives — QUALIFY DENSE_RANK
• Read Primitives — QUALIFY LAG/LEAD
• Read Primitives — QUALIFY NTILE
• Read Primitives — QUALIFY PERCENT_RANK
• Read Primitives — QUALIFY ROW_NUMBER
• Read Primitives — Self Join with Hash Collision
• Read Primitives — Full Outer Join with GroupBy
• Read Primitives — Inner Join with GroupBy
• Read Primitives — Union All with GroupBy
• Read Primitives — Shuffle Join
• Read Primitives — Left Join with GroupBy
• Read Primitives — Correlation Analysis
• Read Primitives — Statistical Percentiles
• Read Primitives — Variance and StdDev
• Read Primitives — String Concatenation
• Read Primitives — String Ends With
• Read Primitives — String Equality (Case Insensitive)
• Read Primitives — String Equality
• Read Primitives — String ILIKE Suffix
• Read Primitives — String ILIKE Multi
• Read Primitives — String ILIKE Prefix
• Read Primitives — String IN Predicate
• Read Primitives — String ILIKE Center
• Read Primitives — String LIKE Center
• Read Primitives — String LIKE Suffix
• Read Primitives — String LIKE Multi
• Read Primitives — String LIKE Prefix
• Read Primitives — String LIKE
• Read Primitives — String Starts With
• Read Primitives — String Substring
• Read Primitives — Struct Field Access
• Read Primitives — Struct Construction
• Read Primitives — Timeseries Trend Analysis
• Read Primitives — TopN with Aggregation
• Read Primitives — TopN All Columns
• Read Primitives — Top-N Query
• Read Primitives — Basic Unpivot
• Read Primitives — Window Growing Frame
• Read Primitives — Window Lead/Lag
• Read Primitives — Window Moving Frame
• Read Primitives — Window Dense Rank
• Read Primitives — Window RANK
• Read Primitives — Window ROW_NUMBER
• Read Primitives — Window Running Sum
• Read Primitives — Window SUM
• Read Primitives — Window Unbounded Frame
• SSB Query Templates
• SSB — Revenue by Year
• SSB — Revenue by Year-Month
• SSB — Revenue by Week
• SSB — Revenue by Year/Brand (Category)
• SSB — Revenue by Year/Brand (Brand Range)
• SSB — Revenue by Year/Brand (Single Brand)
• SSB — Revenue by Nation/Year
• SSB — Revenue by City/Year (Nation)
• SSB — Revenue by City/Year (City Pairs)
• SSB — Revenue by City/Year-Month
• SSB — Profit by Year/Nation
• SSB — Profit by Year/Nation/Category
• SSB — Profit by Year/City/Brand
• TPC-DI A1
• TPC-DI A2
• TPC-DI A3
• TPC-DI A4
• TPC-DI A5
• TPC-DI AQ1
• TPC-DI AQ10
• TPC-DI AQ2
• TPC-DI AQ3
• TPC-DI AQ4
• TPC-DI AQ5
• TPC-DI AQ6
• TPC-DI AQ7
• TPC-DI AQ8
• TPC-DI AQ9
• TPC-DI EQ1
• TPC-DI EQ2
• TPC-DI EQ3
• TPC-DI EQ4
• TPC-DI EQ5
• TPC-DI EQ6
• TPC-DI EQ7
• TPC-DI EQ8
• TPC-DI Query Templates — queries 1-25
• TPC-DI Query Templates — queries 26-38
• TPC-DI Query Templates
• TPC-DI V1
• TPC-DI V2
• TPC-DI V3
• TPC-DI VQ1
• TPC-DI VQ10
• TPC-DI VQ11
• TPC-DI VQ12
• TPC-DI VQ2
• TPC-DI VQ3
• TPC-DI VQ4
• TPC-DI VQ5
• TPC-DI VQ6
• TPC-DI VQ7
• TPC-DI VQ8
• TPC-DI VQ9
• TPC-DS Query Templates — queries 1-25
• TPC-DS Query Templates — queries 26-50
• TPC-DS Query Templates — queries 51-75
• TPC-DS Query Templates — queries 76-99
• TPC-DS Query Templates
• TPC-DS Q1 — Customer Returns Analysis
• TPC-DS Q10 — Customer Demographics Multi-Channel
• TPC-DS Q11 — Store/Web Year-over-Year Customer Comparison
• TPC-DS Q12 — Web Sales Item Analysis
• TPC-DS Q13 — Store Sales Demographics Analysis
• TPC-DS Q14 — Cross-channel Item Sales
• TPC-DS Q15 — Catalog Sales Analysis
• TPC-DS Q16 — Catalog Multi-Warehouse Orders Not Returned
• TPC-DS Q17 — Store/Catalog Sales-Returns Statistics
• TPC-DS Q18 — Catalog Sales Demographics ROLLUP
• TPC-DS Q19 — Store Sales Item/Customer Analysis
• TPC-DS Q2 — Web/Catalog Weekly Sales Year-over-Year
• TPC-DS Q20 — Catalog Sales Item Analysis
• TPC-DS Q21 — Inventory Before/After Date
• TPC-DS Q22 — Inventory ROLLUP by Product
• TPC-DS Q23 — Frequent Items Best Customers
• TPC-DS Q24 — Store Sales Returns by Color
• TPC-DS Q25 — Store/Catalog Sales Item Analysis
• TPC-DS Q26 — Catalog Sales Promo Analysis
• TPC-DS Q27 — Store Sales Demographics ROLLUP
• TPC-DS Q28 — Store Sales Quantity Bucket Extended
• TPC-DS Q29 — Store/Catalog Sales-Returns Aggregation
• TPC-DS Q3 — Date/Item Brand Sales
• TPC-DS Q30 — Web Returns Customer Analysis
• TPC-DS Q31 — Store/Web Quarterly Sales Growth
• TPC-DS Q32 — Catalog Sales Excess Discount
• TPC-DS Q33 — Three-Channel Sales by Manufacturer
• TPC-DS Q34 — Store Sales County Household
• TPC-DS Q35 — Customer Demographics Multi-Channel Quarterly
• TPC-DS Q36 — Gross Margin ROLLUP with Rank
• TPC-DS Q37 — Item Inventory Analysis
• TPC-DS Q38 — Three-Channel Customer INTERSECT
• TPC-DS Q39 — Inventory Variance Monthly
• TPC-DS Q4 — Customer Year-over-Year Comparison
• TPC-DS Q40 — Catalog Sales Before/After Returns
• TPC-DS Q41 — Item Dimension Analysis
• TPC-DS Q42 — Date/Item Category Sales
• TPC-DS Q43 — Store Sales Day Analysis
• TPC-DS Q44 — Store Sales Item Ranking
• TPC-DS Q45 — Web Sales Customer Zip Analysis
• TPC-DS Q46 — Store Sales Household Analysis
• TPC-DS Q47 — Store Sales Rolling Average
• TPC-DS Q48 — Store Sales Quantity Demographics
• TPC-DS Q49 — Three-Channel Return Ratio Ranking
• TPC-DS Q5 — Three-Channel Sales-Returns Union with ROLLUP
• TPC-DS Q50 — Store Sales Returns Analysis
• TPC-DS Q51 — Cumulative Web/Store Sales
• TPC-DS Q52 — Date/Brand Extended Sales
• TPC-DS Q53 — Store Manufacturer Sales
• TPC-DS Q54 — Catalog+Web Customer Store Revenue Segments
• TPC-DS Q55 — Brand Manager Sales
• TPC-DS Q56 — Three-Channel Sales by Item (Color)
• TPC-DS Q57 — Catalog Sales Rolling Average
• TPC-DS Q58 — Three-Channel Item Sales Balance Check
• TPC-DS Q59 — Store Weekly Sales Year-over-Year
• TPC-DS Q6 — Customer State/Item Analysis
• TPC-DS Q60 — Three-Channel Sales by Item (Category)
• TPC-DS Q61 — Promotional Sales Ratio
• TPC-DS Q62 — Web Sales Delivery Analysis
• TPC-DS Q63 — Store Manufacturer Profit
• TPC-DS Q64 — Cross-Sales Income Band
• TPC-DS Q65 — Store Sales Item Profit
• TPC-DS Q66 — Web/Catalog Warehouse Monthly Sales
• TPC-DS Q67 — Extensive ROLLUP with Rank
• TPC-DS Q68 — Store Sales Customer Household
• TPC-DS Q69 — Customer Demographics Store-Only
• TPC-DS Q7 — Promotion Analysis
• TPC-DS Q70 — Store Sales ROLLUP with Subquery Filter
• TPC-DS Q71 — Three-Channel Sales by Brand and Time
• TPC-DS Q72 — Catalog Sales Inventory
• TPC-DS Q73 — Store Sales Household Vehicle
• TPC-DS Q74 — Store/Web Customer Year-over-Year Growth
• TPC-DS Q75 — Three-Channel Sales with Returns Year-over-Year
• TPC-DS Q76 — Three-Channel Sales with NULL Column Filter
• TPC-DS Q77 — Three-Channel Sales-Returns with Separate CTEs
• TPC-DS Q78 — Three-Channel Sales without Returns Comparison
• TPC-DS Q79 — Store Sales Customer/Store Profit
• TPC-DS Q8 — Store Sales Zip Code Net Profit
• TPC-DS Q80 — Three-Channel Sales-Returns with ROLLUP
• TPC-DS Q81 — Catalog Returns Customer Analysis
• TPC-DS Q82 — Store Sales Inventory
• TPC-DS Q83 — Cross-Channel Returns Analysis
• TPC-DS Q84 — Customer Income Band Lookup
• TPC-DS Q85 — Web Sales Returns Demographics
• TPC-DS Q86 — Web Sales ROLLUP with Rank
• TPC-DS Q87 — Three-Channel Customer EXCEPT
• TPC-DS Q88 — Store Sales Time Period Counts
• TPC-DS Q89 — Store Item Sales Profit
• TPC-DS Q9 — Store Sales Quantity Bucket Analysis
• TPC-DS Q90 — Web Sales AM/PM Ratio Analysis
• TPC-DS Q91 — Call Center Returns Analysis
• TPC-DS Q92 — Web Sales Discount
• TPC-DS Q93 — Store Sales Returns Actual Sales
• TPC-DS Q94 — Web Multi-Warehouse Orders Not Returned
• TPC-DS Q95 — Web Multi-Warehouse Orders With Returns
• TPC-DS Q96 — Store Sales Time Count
• TPC-DS Q97 — Store/Catalog Customer-Item Overlap
• TPC-DS Q98 — Store Sales Item Band
• TPC-DS Q99 — Catalog Sales Delivery Analysis
• TPC-DS-OBT Query Templates — queries 1-25
• TPC-DS-OBT Query Templates — queries 26-50
• TPC-DS-OBT Query Templates — queries 51-75
• TPC-DS-OBT Query Templates — queries 76-89
• TPC-DS-OBT Query Templates
• TPC-DS-OBT Q1 — obt_row_count
• TPC-DS-OBT Q10 — obt_high_value_sales
• TPC-DS-OBT Q11 — obt_item_channel_quantity
• TPC-DS-OBT Q12 — obt_ticket_extremes
• TPC-DS-OBT Q13 — obt_distinct_items
• TPC-DS-OBT Q14 — obt_bulk_sales
• TPC-DS-OBT Q15 — obt_coupon_sales
• TPC-DS-OBT Q16 — obt_store_summary
• TPC-DS-OBT Q17 — obt_overall_totals
• TPC-DS-OBT Q18
• TPC-DS-OBT Q19
• TPC-DS-OBT Q2 — obt_channel_distribution
• TPC-DS-OBT Q20
• TPC-DS-OBT Q23
• TPC-DS-OBT Q24
• TPC-DS-OBT Q25
• TPC-DS-OBT Q26
• TPC-DS-OBT Q27
• TPC-DS-OBT Q28
• TPC-DS-OBT Q29
• TPC-DS-OBT Q3 — obt_returns_summary
• TPC-DS-OBT Q30
• TPC-DS-OBT Q31
• TPC-DS-OBT Q32
• TPC-DS-OBT Q33
• TPC-DS-OBT Q34
• TPC-DS-OBT Q35
• TPC-DS-OBT Q36
• TPC-DS-OBT Q38
• TPC-DS-OBT Q4 — obt_channel_revenue
• TPC-DS-OBT Q40
• TPC-DS-OBT Q41
• TPC-DS-OBT Q42
• TPC-DS-OBT Q43
• TPC-DS-OBT Q44
• TPC-DS-OBT Q45
• TPC-DS-OBT Q47
• TPC-DS-OBT Q48
• TPC-DS-OBT Q49
• TPC-DS-OBT Q5 — obt_top_items_by_quantity
• TPC-DS-OBT Q50
• TPC-DS-OBT Q51
• TPC-DS-OBT Q52
• TPC-DS-OBT Q53
• TPC-DS-OBT Q54
• TPC-DS-OBT Q55
• TPC-DS-OBT Q56
• TPC-DS-OBT Q57
• TPC-DS-OBT Q58
• TPC-DS-OBT Q59
• TPC-DS-OBT Q6 — obt_avg_ticket_by_channel
• TPC-DS-OBT Q60
• TPC-DS-OBT Q61
• TPC-DS-OBT Q62
• TPC-DS-OBT Q63
• TPC-DS-OBT Q65
• TPC-DS-OBT Q66
• TPC-DS-OBT Q67
• TPC-DS-OBT Q69
• TPC-DS-OBT Q7 — obt_discounted_sales
• TPC-DS-OBT Q70
• TPC-DS-OBT Q71
• TPC-DS-OBT Q73
• TPC-DS-OBT Q74
• TPC-DS-OBT Q75
• TPC-DS-OBT Q76
• TPC-DS-OBT Q77
• TPC-DS-OBT Q78
• TPC-DS-OBT Q79
• TPC-DS-OBT Q8 — obt_profit_by_channel
• TPC-DS-OBT Q80
• TPC-DS-OBT Q81
• TPC-DS-OBT Q83
• TPC-DS-OBT Q85
• TPC-DS-OBT Q86
• TPC-DS-OBT Q87
• TPC-DS-OBT Q88
• TPC-DS-OBT Q89
• TPC-DS-OBT Q9 — obt_sales_by_channel_return_flag
• TPC-DS-OBT Q90
• TPC-DS-OBT Q91
• TPC-DS-OBT Q92
• TPC-DS-OBT Q93
• TPC-DS-OBT Q94
• TPC-DS-OBT Q95
• TPC-DS-OBT Q96
• TPC-DS-OBT Q97
• TPC-DS-OBT Q98
• TPC-DS-OBT Q99
• TPC-H Query Templates
• TPC-H Q1 — Pricing Summary Report
• TPC-H Q10 — Returned Item Reporting
• TPC-H Q11 — Important Stock Identification
• TPC-H Q12 — Shipping Modes and Order Priority
• TPC-H Q13 — Customer Distribution
• TPC-H Q14 — Promotion Effect
• TPC-H Q15 — Top Supplier
• TPC-H Q16 — Parts/Supplier Relationship
• TPC-H Q17 — Small-Quantity-Order Revenue
• TPC-H Q18 — Large Volume Customer
• TPC-H Q19 — Discounted Revenue
• TPC-H Q2 — Minimum Cost Supplier
• TPC-H Q20 — Potential Part Promotion
• TPC-H Q21 — Suppliers Who Kept Orders Waiting
• TPC-H Q22 — Global Sales Opportunity
• TPC-H Q3 — Shipping Priority
• TPC-H Q4 — Order Priority Checking
• TPC-H Q5 — Local Supplier Volume
• TPC-H Q6 — Forecasting Revenue Change
• TPC-H Q7 — Volume Shipping
• TPC-H Q8 — National Market Share
• TPC-H Q9 — Product Type Profit Measure
• TPC-H Skew Query Templates
• TPC-H Skew Q1 — Pricing Summary Report
• TPC-H Skew Q10 — Returned Item Reporting
• TPC-H Skew Q11 — Important Stock Identification
• TPC-H Skew Q12 — Shipping Modes and Order Priority
• TPC-H Skew Q13 — Customer Distribution
• TPC-H Skew Q14 — Promotion Effect
• TPC-H Skew Q15 — Top Supplier
• TPC-H Skew Q16 — Parts/Supplier Relationship
• TPC-H Skew Q17 — Small-Quantity-Order Revenue
• TPC-H Skew Q18 — Large Volume Customer
• TPC-H Skew Q19 — Discounted Revenue
• TPC-H Skew Q2 — Minimum Cost Supplier
• TPC-H Skew Q20 — Potential Part Promotion
• TPC-H Skew Q21 — Suppliers Who Kept Orders Waiting
• TPC-H Skew Q22 — Global Sales Opportunity
• TPC-H Skew Q3 — Shipping Priority
• TPC-H Skew Q4 — Order Priority Checking
• TPC-H Skew Q5 — Local Supplier Volume
• TPC-H Skew Q6 — Forecasting Revenue Change
• TPC-H Skew Q7 — Volume Shipping
• TPC-H Skew Q8 — National Market Share
• TPC-H Skew Q9 — Product Type Profit Measure
• TPC-Havoc Query Templates — queries 1-25
• TPC-Havoc Query Templates — queries 101-125
• TPC-Havoc Query Templates — queries 126-150
• TPC-Havoc Query Templates — queries 151-175
• TPC-Havoc Query Templates — queries 176-200
• TPC-Havoc Query Templates — queries 201-220
• TPC-Havoc Query Templates — queries 26-50
• TPC-Havoc Query Templates — queries 51-75
• TPC-Havoc Query Templates — queries 76-100
• TPC-Havoc Query Templates
• TPC-Havoc Q1_v1
• TPC-Havoc Q1_v10
• TPC-Havoc Q1_v2
• TPC-Havoc Q1_v3
• TPC-Havoc Q1_v4
• TPC-Havoc Q1_v5
• TPC-Havoc Q1_v6
• TPC-Havoc Q1_v7
• TPC-Havoc Q1_v8
• TPC-Havoc Q1_v9
• TPC-Havoc Q10_v1
• TPC-Havoc Q10_v10
• TPC-Havoc Q10_v2
• TPC-Havoc Q10_v3
• TPC-Havoc Q10_v4
• TPC-Havoc Q10_v5
• TPC-Havoc Q10_v6
• TPC-Havoc Q10_v7
• TPC-Havoc Q10_v8
• TPC-Havoc Q10_v9
• TPC-Havoc Q11_v1
• TPC-Havoc Q11_v10
• TPC-Havoc Q11_v2
• TPC-Havoc Q11_v3
• TPC-Havoc Q11_v4
• TPC-Havoc Q11_v5
• TPC-Havoc Q11_v6
• TPC-Havoc Q11_v7
• TPC-Havoc Q11_v8
• TPC-Havoc Q11_v9
• TPC-Havoc Q12_v1
• TPC-Havoc Q12_v10
• TPC-Havoc Q12_v2
• TPC-Havoc Q12_v3
• TPC-Havoc Q12_v4
• TPC-Havoc Q12_v5
• TPC-Havoc Q12_v6
• TPC-Havoc Q12_v7
• TPC-Havoc Q12_v8
• TPC-Havoc Q12_v9
• TPC-Havoc Q13_v1
• TPC-Havoc Q13_v10
• TPC-Havoc Q13_v2
• TPC-Havoc Q13_v3
• TPC-Havoc Q13_v4
• TPC-Havoc Q13_v5
• TPC-Havoc Q13_v6
• TPC-Havoc Q13_v7
• TPC-Havoc Q13_v8
• TPC-Havoc Q13_v9
• TPC-Havoc Q14_v1
• TPC-Havoc Q14_v10
• TPC-Havoc Q14_v2
• TPC-Havoc Q14_v3
• TPC-Havoc Q14_v4
• TPC-Havoc Q14_v5
• TPC-Havoc Q14_v6
• TPC-Havoc Q14_v7
• TPC-Havoc Q14_v8
• TPC-Havoc Q14_v9
• TPC-Havoc Q15_v1
• TPC-Havoc Q15_v10
• TPC-Havoc Q15_v2
• TPC-Havoc Q15_v3
• TPC-Havoc Q15_v4
• TPC-Havoc Q15_v5
• TPC-Havoc Q15_v6
• TPC-Havoc Q15_v7
• TPC-Havoc Q15_v8
• TPC-Havoc Q15_v9
• TPC-Havoc Q16_v1
• TPC-Havoc Q16_v10
• TPC-Havoc Q16_v2
• TPC-Havoc Q16_v3
• TPC-Havoc Q16_v4
• TPC-Havoc Q16_v5
• TPC-Havoc Q16_v6
• TPC-Havoc Q16_v7
• TPC-Havoc Q16_v8
• TPC-Havoc Q16_v9
• TPC-Havoc Q17_v1
• TPC-Havoc Q17_v10
• TPC-Havoc Q17_v2
• TPC-Havoc Q17_v3
• TPC-Havoc Q17_v4
• TPC-Havoc Q17_v5
• TPC-Havoc Q17_v6
• TPC-Havoc Q17_v7
• TPC-Havoc Q17_v8
• TPC-Havoc Q17_v9
• TPC-Havoc Q18_v1
• TPC-Havoc Q18_v10
• TPC-Havoc Q18_v2
• TPC-Havoc Q18_v3
• TPC-Havoc Q18_v4
• TPC-Havoc Q18_v5
• TPC-Havoc Q18_v6
• TPC-Havoc Q18_v7
• TPC-Havoc Q18_v8
• TPC-Havoc Q18_v9
• TPC-Havoc Q19_v1
• TPC-Havoc Q19_v10
• TPC-Havoc Q19_v2
• TPC-Havoc Q19_v3
• TPC-Havoc Q19_v4
• TPC-Havoc Q19_v5
• TPC-Havoc Q19_v6
• TPC-Havoc Q19_v7
• TPC-Havoc Q19_v8
• TPC-Havoc Q19_v9
• TPC-Havoc Q2_v1
• TPC-Havoc Q2_v10
• TPC-Havoc Q2_v2
• TPC-Havoc Q2_v3
• TPC-Havoc Q2_v4
• TPC-Havoc Q2_v5
• TPC-Havoc Q2_v6
• TPC-Havoc Q2_v7
• TPC-Havoc Q2_v8
• TPC-Havoc Q2_v9
• TPC-Havoc Q20_v1
• TPC-Havoc Q20_v10
• TPC-Havoc Q20_v2
• TPC-Havoc Q20_v3
• TPC-Havoc Q20_v4
• TPC-Havoc Q20_v5
• TPC-Havoc Q20_v6
• TPC-Havoc Q20_v7
• TPC-Havoc Q20_v8
• TPC-Havoc Q20_v9
• TPC-Havoc Q21_v1
• TPC-Havoc Q21_v10
• TPC-Havoc Q21_v2
• TPC-Havoc Q21_v3
• TPC-Havoc Q21_v4
• TPC-Havoc Q21_v5
• TPC-Havoc Q21_v6
• TPC-Havoc Q21_v7
• TPC-Havoc Q21_v8
• TPC-Havoc Q21_v9
• TPC-Havoc Q22_v1
• TPC-Havoc Q22_v10
• TPC-Havoc Q22_v2
• TPC-Havoc Q22_v3
• TPC-Havoc Q22_v4
• TPC-Havoc Q22_v5
• TPC-Havoc Q22_v6
• TPC-Havoc Q22_v7
• TPC-Havoc Q22_v8
• TPC-Havoc Q22_v9
• TPC-Havoc Q3_v1
• TPC-Havoc Q3_v10
• TPC-Havoc Q3_v2
• TPC-Havoc Q3_v3
• TPC-Havoc Q3_v4
• TPC-Havoc Q3_v5
• TPC-Havoc Q3_v6
• TPC-Havoc Q3_v7
• TPC-Havoc Q3_v8
• TPC-Havoc Q3_v9
• TPC-Havoc Q4_v1
• TPC-Havoc Q4_v10
• TPC-Havoc Q4_v2
• TPC-Havoc Q4_v3
• TPC-Havoc Q4_v4
• TPC-Havoc Q4_v5
• TPC-Havoc Q4_v6
• TPC-Havoc Q4_v7
• TPC-Havoc Q4_v8
• TPC-Havoc Q4_v9
• TPC-Havoc Q5_v1
• TPC-Havoc Q5_v10
• TPC-Havoc Q5_v2
• TPC-Havoc Q5_v3
• TPC-Havoc Q5_v4
• TPC-Havoc Q5_v5
• TPC-Havoc Q5_v6
• TPC-Havoc Q5_v7
• TPC-Havoc Q5_v8
• TPC-Havoc Q5_v9
• TPC-Havoc Q6_v1
• TPC-Havoc Q6_v10
• TPC-Havoc Q6_v2
• TPC-Havoc Q6_v3
• TPC-Havoc Q6_v4
• TPC-Havoc Q6_v5
• TPC-Havoc Q6_v6
• TPC-Havoc Q6_v7
• TPC-Havoc Q6_v8
• TPC-Havoc Q6_v9
• TPC-Havoc Q7_v1
• TPC-Havoc Q7_v10
• TPC-Havoc Q7_v2
• TPC-Havoc Q7_v3
• TPC-Havoc Q7_v4
• TPC-Havoc Q7_v5
• TPC-Havoc Q7_v6
• TPC-Havoc Q7_v7
• TPC-Havoc Q7_v8
• TPC-Havoc Q7_v9
• TPC-Havoc Q8_v1
• TPC-Havoc Q8_v10
• TPC-Havoc Q8_v2
• TPC-Havoc Q8_v3
• TPC-Havoc Q8_v4
• TPC-Havoc Q8_v5
• TPC-Havoc Q8_v6
• TPC-Havoc Q8_v7
• TPC-Havoc Q8_v8
• TPC-Havoc Q8_v9
• TPC-Havoc Q9_v1
• TPC-Havoc Q9_v10
• TPC-Havoc Q9_v2
• TPC-Havoc Q9_v3
• TPC-Havoc Q9_v4
• TPC-Havoc Q9_v5
• TPC-Havoc Q9_v6
• TPC-Havoc Q9_v7
• TPC-Havoc Q9_v8
• TPC-Havoc Q9_v9
• Transactions Query Templates
• Transactions transaction_commit_large
• Transactions transaction_commit_medium
• Transactions transaction_commit_small
• Transactions transaction_create_temp_table
• Transactions transaction_delete_insert_same_key
• Transactions transaction_insert_update_chain
• Transactions transaction_insert_with_subquery
• Transactions transaction_isolation_read_committed
• Transactions transaction_isolation_repeatable_read
• Transactions transaction_isolation_serializable
• Transactions transaction_long_running_mixed
• Transactions transaction_mixed_dml_medium
• Transactions transaction_mixed_dml_small
• Transactions transaction_multi_table_writes
• Transactions transaction_nested_subquery_updates
• Transactions transaction_read_your_writes
• Transactions transaction_rollback_after_error
• Transactions transaction_rollback_medium
• Transactions transaction_rollback_small
• Transactions transaction_savepoint_deep_nesting
• Transactions transaction_savepoint_nested
• Transactions transaction_truncate_in_transaction
• Transactions transaction_with_cte
• TSBS DevOps — Metrics by Region
• TSBS DevOps — Metrics by Service
• TSBS DevOps — CPU Max All Hosts - 1 Hour
• TSBS DevOps — CPU Max All Hosts - 8 Hours
• TSBS DevOps — Disk IOPS - 1 Hour
• TSBS DevOps — Disk Latency Analysis
• TSBS DevOps — Double GroupBy - 1 Hour
• TSBS DevOps — Double GroupBy - 5 Minutes
• TSBS DevOps — High CPU Usage - 1 Hour
• TSBS DevOps — High CPU Usage - 12 Hours
• TSBS DevOps Query Templates
• TSBS DevOps — Last Point per Host
• TSBS DevOps — Low Memory Hosts
• TSBS DevOps — Memory by Host - 1 Hour
• TSBS DevOps — Network Errors
• TSBS DevOps — Network Throughput - 1 Hour
• TSBS DevOps — Resource Utilization Summary
• TSBS DevOps — Single Host - 1 Hour
• TSBS DevOps — Single Host - 12 Hours
• Vector Search Query Templates
• Vector Search Q1
• Vector Search Q2
• Vector Search Q3
• Vector Search Q4
• Vector Search Q5
• Vector Search Q6
• Write Primitives bulk_load_append_mode
• Write Primitives bulk_load_column_subset
• Write Primitives bulk_load_csv_large_bzip2
• Write Primitives bulk_load_csv_large_gzip
• Write Primitives bulk_load_csv_large_uncompressed
• Write Primitives bulk_load_csv_large_zstd
• Write Primitives bulk_load_csv_medium_bzip2
• Write Primitives bulk_load_csv_medium_gzip
• Write Primitives bulk_load_csv_medium_uncompressed
• Write Primitives bulk_load_csv_medium_zstd
• Write Primitives bulk_load_csv_small_bzip2
• Write Primitives bulk_load_csv_small_gzip
• Write Primitives bulk_load_csv_small_uncompressed
• Write Primitives bulk_load_csv_small_zstd
• Write Primitives bulk_load_date_format_custom
• Write Primitives bulk_load_delimited_custom
• Write Primitives bulk_load_encoding_utf8
• Write Primitives bulk_load_error_handling_skip_bad_rows
• Write Primitives bulk_load_null_handling
• Write Primitives bulk_load_parallel_multi_file
• Write Primitives bulk_load_parquet_large_gzip
• Write Primitives bulk_load_parquet_large_snappy
• Write Primitives bulk_load_parquet_large_uncompressed
• Write Primitives bulk_load_parquet_large_zstd
• Write Primitives bulk_load_parquet_medium_gzip
• Write Primitives bulk_load_parquet_medium_snappy
• Write Primitives bulk_load_parquet_medium_uncompressed
• Write Primitives bulk_load_parquet_medium_zstd
• Write Primitives bulk_load_parquet_small_gzip
• Write Primitives bulk_load_parquet_small_snappy
• Write Primitives bulk_load_parquet_small_uncompressed
• Write Primitives bulk_load_parquet_small_zstd
• Write Primitives bulk_load_quoted_fields
• Write Primitives bulk_load_replace_mode
• Write Primitives bulk_load_upsert_mode
• Write Primitives bulk_load_with_transformation
• Write Primitives ddl_alter_table_add_column
• Write Primitives ddl_alter_table_drop_column
• Write Primitives ddl_alter_table_rename_column
• Write Primitives ddl_create_index_on_existing
• Write Primitives ddl_create_table_as_select_simple
• Write Primitives ddl_create_table_simple
• Write Primitives ddl_create_table_with_constraints
• Write Primitives ddl_create_table_with_index
• Write Primitives ddl_create_view_simple
• Write Primitives ddl_drop_index
• Write Primitives ddl_drop_table
• Write Primitives ddl_truncate_table_small
• Write Primitives delete_all_truncate_comparison
• Write Primitives delete_bulk_25pct
• Write Primitives delete_bulk_50pct
• Write Primitives delete_bulk_75pct
• Write Primitives delete_cascade_simulation
• Write Primitives delete_gdpr_suppliers_1pct
• Write Primitives delete_gdpr_suppliers_5pct
• Write Primitives delete_returning
• Write Primitives delete_selective_10pct
• Write Primitives delete_single_row_pk
• Write Primitives delete_with_aggregation
• Write Primitives delete_with_join
• Write Primitives delete_with_not_exists
• Write Primitives delete_with_subquery
• Write Primitives Query Templates — queries 1-25
• Write Primitives Query Templates — queries 101-112
• Write Primitives Query Templates — queries 26-50
• Write Primitives Query Templates — queries 51-75
• Write Primitives Query Templates — queries 76-100
• Write Primitives Query Templates
• Write Primitives insert_batch_values_10
• Write Primitives insert_batch_values_100
• Write Primitives insert_batch_values_1000
• Write Primitives insert_on_conflict_ignore
• Write Primitives insert_returning_clause
• Write Primitives insert_select_aggregated
• Write Primitives insert_select_from_multiple
• Write Primitives insert_select_simple
• Write Primitives insert_select_union
• Write Primitives insert_select_with_join
• Write Primitives insert_single_row
• Write Primitives insert_with_default_values
• Write Primitives merge_computed_values
• Write Primitives merge_conditional_insert
• Write Primitives merge_conditional_update
• Write Primitives merge_date_arithmetic
• Write Primitives merge_deduplication_window_function
• Write Primitives merge_error_handling
• Write Primitives merge_etl_aggregation_pattern
• Write Primitives merge_from_subquery_aggregated
• Write Primitives merge_full_overlap_all_update
• Write Primitives merge_multi_column_update
• Write Primitives merge_no_overlap_all_insert
• Write Primitives merge_overlap_10pct
• Write Primitives merge_overlap_50pct
• Write Primitives merge_overlap_90pct
• Write Primitives merge_returning_clause
• Write Primitives merge_scd_type2_basic
• Write Primitives merge_scd_type2_new_keys_only
• Write Primitives merge_scd_type2_no_change
• Write Primitives merge_simple_upsert_small
• Write Primitives merge_string_operations
• Write Primitives merge_upsert_with_delete
• Write Primitives merge_with_cte_source
• Write Primitives merge_with_join_condition
• Write Primitives update_bulk_50pct
• Write Primitives update_bulk_all
• Write Primitives update_computed_column
• Write Primitives update_conditional_multi_column
• Write Primitives update_date_arithmetic
• Write Primitives update_from_select
• Write Primitives update_returning
• Write Primitives update_selective_10pct
• Write Primitives update_set_multiple_columns
• Write Primitives update_single_row_pk
• Write Primitives update_string_manipulation
• Write Primitives update_with_aggregate
• Write Primitives update_with_case_expression
• Write Primitives update_with_join
• Write Primitives update_with_subquery
• Real-World Data Benchmarks
• Benchmark Support Status Criteria
• Time-Series Benchmarks
• TPC Standards
• Glossary
• Data & Dependencies
• DB API 2.0: Foundation of BenchBox Platform Support
• Dependency Compatibility
• Import Patterns and Lazy Loading
• Platform Development
• Primitives Query Catalog
• Read Primitives: Platform Skip Reference
• Runtime Module Architecture Overview
• BenchBox Platform Configuration Audit
• Cloud Platforms
• Platform Comparison Matrix
• DataFrame Platforms
• Multi-Platform Database Support
• SQL Platforms
• Platform Support Status
• API Reference
• CLI Command Reference
• aggregate - Aggregate Results
• auth - Hosted Submission Credentials
• Configuration
• convert - Convert Data Formats
• datagen - Data Generation
• download-answers - Answer Files
• BenchBox CLI Reference
• metrics - Performance Metrics
• platforms - Platform Management
• show-plan / plan-history - Query Plans
• report - Historical Analysis
• Results Commands
• run - Run Benchmarks
• setup - Cloud Credentials
• shell - Interactive SQL Shell
• submit - Submit Results
• Tuning Commands
• Utility Commands
• visualize - Generate Charts
• Common Workflows
• Reference Documentation
• MCP Server Reference
• Additional Utilities API
• Base Benchmark API
• Benchmark API Reference
• AMPLab Big Data Benchmark API
• ClickBench Benchmark API
• CoffeeShop Benchmark API
• Data Vault Benchmark API
• FlightData Benchmark API
• H2O.ai Database Benchmark API
• Benchmark APIs
• Join Order Benchmark API
• MetadataPrimitives Benchmark API
• Shared Benchmark Facade Mixins
• NYCTaxi Benchmark API
• Read Primitives Benchmark API
• SSB (Star Schema Benchmark) API
• TPC-DI Benchmark API
• TPCDSOBT Benchmark API
• TPC-DS Benchmark API
• TPC-H Skew API
• TPC-H Benchmark API
• TPC-Havoc API
• Transaction Primitives API
• TSBS DevOps API
• Vector Search API
• Write Primitives Benchmark API
• Cloud Storage Integration API
• Configuration, Registry and Lifecycle API
• Data Validation Utilities API
• DataFrame Query Registries
• DataFrame Contexts and Tuning
• DataFrame query registries
• Python API Reference
• Performance Monitoring Utilities API
• Platform API Reference
• BigQuery Platform Adapter
• ClickHouse Platform Adapter
• Common platform adapter API
• Databricks Platform Adapter
• Apache DataFusion Platform Adapter
• DuckDB Platform Adapter
• Polars Platform Adapter
• Amazon Redshift Platform Adapter
• Snowflake Platform Adapter
• SQLite Platform Adapter
• Result Analysis API
• Results API
• Tuning Configuration API
• Utilities & Helpers
• Utility Functions API
• Result Export Formats
• Benchmark Result Schema (v1.1, Legacy)
• BenchBox CLI quick reference
• Examples Directory Guide
• Chart Types
• CLI Reference: benchbox visualize
• Templates