Tagged with: query-template
Pages with this tag
- 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