Skip to content
BenchBox
Home
Docs
Blog
Results
GitHub
Run benchmark
Search
Search docs and blog
Close
Docs
Benchmarks
Query Templates
ClickBench Query Templates
ClickBench Query Templates — text_and_pattern_matching
Menu
Getting Started
BenchBox Documentation
Installation and environment setup
Getting Started in 5 Minutes
BenchBox CLI quick reference
MCP Integration Guide
Tutorials
Tutorials
Your First Benchmark
Understanding Benchmark Results
Comparing Platforms
DataFrame Benchmarking Quickstart
User Guide
Configuration Handbook
Data Generation
Dry Run Mode
Examples Directory Guide
Understanding Benchmark Results
Troubleshooting Guide
Frequently Asked Questions (FAQ)
Concepts
Concepts
BenchBox Architecture
Benchmarking Workflows
Data Model
Glossary
Database Benchmarking Tools Compared
Benchmarks
TPC Standards
TPC Standards
TPC-H Benchmark
TPC-DS Benchmark
TPC-DI Benchmark
TPC benchmarks and trademarks
Academic Benchmarks
Academic Benchmarks
Star Schema Benchmark (SSB)
AMPLab Big Data Benchmark
Join Order Benchmark
Industry Benchmarks
Industry Benchmarks
ClickBench (ClickHouse Analytics Benchmark)
H2O DB Benchmark
CoffeeShop Example Dataset
Real-World Data Benchmarks
Real-World Data Benchmarks
NYC Taxi OLAP Example Dataset
Flight Data Benchmark
Time-Series Benchmarks
Time-Series Benchmarks
TSBS DevOps Benchmark
BenchBox Primitives
BenchBox Primitives
Read Primitives Benchmark
Write Primitives Benchmark
Transaction Primitives Benchmark
Metadata Primitives Benchmark
AI/ML Primitives Benchmark
AI & ML Benchmarks
AI & ML Benchmarks
Vector Search Benchmark
BenchBox Experimental
BenchBox Experimental
TPC-Havoc Benchmark
TPC-H Skew Benchmark
TPC-DS-OBT Benchmark
TPC-H Data Vault Benchmark
Platforms
Platform Selection Guide
Multi-Platform Database Support
Platform Comparison Matrix
SQL Platforms
SQL Platforms
DuckDB Platform
ClickHouse Local Mode
ClickHouse Server Platform
Apache DataFusion Platform Guide
CedarDB Platform
PostgreSQL Platform
SQLite Platform
pg_duckdb Platform
pg_mooncake Platform
Trino Platform
PrestoDB Platform Guide
Apache Spark Platform
Apache Doris Platform
StarRocks Platform
LakeSail Sail Platform
Apache Gluten + Velox Platform
SingleStore Platform
TimescaleDB Platform
InfluxDB
QuestDB Platform
DataFrame Platforms
DataFrame Platforms
DataFrame Platforms
Polars Platform
Pandas DataFrame Platform
PySpark Platform (SQL & DataFrame)
DataFusion DataFrame Platform
Migrating from the Modin DataFrame platform
Dask DataFrame Platform
cuDF DataFrame Platform
Databricks DataFrame Platform
Cloud Platforms
Cloud Platforms
Snowflake Platform
Databricks Platform
BigQuery Platform
ClickHouse Cloud Platform
Redshift Platform
Amazon Athena Platform
Azure Analytics Platforms
Microsoft Fabric
Microsoft Fabric Lakehouse SQL
Firebolt Platform
Databend Platform
MotherDuck Platform
Starburst Platform
Onehouse Quanton Platform
AWS Glue Platform
Amazon EMR Serverless Platform
Amazon Athena for Apache Spark Platform
Google Cloud Dataproc Platform
Google Cloud Dataproc Serverless Platform
Microsoft Fabric Spark Platform
Azure Synapse Analytics Spark Platform
Snowpark Connect for Spark
Guides
TPC Benchmark Guides
TPC Benchmark Guides
TPC-H Official Benchmark Guide
TPC-DS Official Benchmark Guide
TPC-DI Deployment Guide
TPC-DI ETL Implementation Guide
TPC Maintenance Phase: Complete Guide
TPC Patterns Usage Guide
TPC Test Result Validation System
Table Format Guides
Table Format Guides
Parquet Deep Dive
Delta Lake Guide
Apache Iceberg Guide
Vortex Guide
Platform Comparison Guide
Cloud Storage Support
Data Compression in BenchBox
Advanced Topics
Advanced Topics
Power Run Iterations and Concurrent Query Execution
Optimizer Sniff Test Queries
Performance Monitoring
Advanced Performance Optimization Guide
Performance & Tuning
Performance & Tuning
Performance Monitoring
Advanced Performance Optimization Guide
Power Run Iterations and Concurrent Query Execution
Open Table Formats Guide
Custom Benchmarks
CI/CD Integration Guide
Customization & Extensions
Customization & Extensions
Custom Benchmarks
Optimizer Sniff Test Queries
BenchBox Visualization Architecture
BenchBox Visualization Architecture
Chart Generation Guide
Chart Types
Customization
Templates
CLI Reference: benchbox visualize
Contributing
Contributing Benchmark Results
Reference
BenchBox CLI Reference
BenchBox CLI Reference
run - Run Benchmarks
convert - Convert Data Formats
shell - Interactive SQL Shell
platforms - Platform Management
Utility Commands
Tuning Commands
Results Commands
submit - Submit Results
auth - Hosted Submission Credentials
visualize - Generate Charts
report - Historical Analysis
metrics - Performance Metrics
aggregate - Aggregate Results
datagen - Data Generation
setup - Cloud Credentials
show-plan / plan-history - Query Plans
download-answers - Answer Files
Configuration
Common Workflows
Python API Reference
Python API Reference
Base Benchmark API
Configuration, Registry and Lifecycle API
Benchmark API Reference
Benchmark API Reference
Benchmark APIs
Shared Benchmark Facade Mixins
TPC-H Benchmark API
TPC-DS Benchmark API
TPC-Havoc API
TPC-DI Benchmark API
SSB (Star Schema Benchmark) API
ClickBench Benchmark API
CoffeeShop Benchmark API
Join Order Benchmark API
AMPLab Big Data Benchmark API
H2O.ai Database Benchmark API
Read Primitives Benchmark API
Write Primitives Benchmark API
Transaction Primitives API
TPC-H Skew API
TSBS DevOps API
Vector Search API
Data Vault Benchmark API
FlightData Benchmark API
MetadataPrimitives Benchmark API
NYCTaxi Benchmark API
TPCDSOBT Benchmark API
DataFrame Query Registries
DataFrame Contexts and Tuning
Results API
Result Analysis API
DataFrame query registries
Common platform adapter API
DuckDB Platform Adapter
Apache DataFusion Platform Adapter
SQLite Platform Adapter
ClickHouse Platform Adapter
Databricks Platform Adapter
BigQuery Platform Adapter
Snowflake Platform Adapter
Amazon Redshift Platform Adapter
Polars Platform Adapter
Cloud Storage Integration API
Data Validation Utilities API
Utilities & Helpers
Utilities & Helpers
Utility Functions API
Tuning Configuration API
Cloud Storage Integration API
Result Analysis API
Data Validation Utilities API
Performance Monitoring Utilities API
Additional Utilities API
Additional Utilities API
Performance Monitoring Utilities API
Tuning Configuration API
MCP Server Reference
Result Export Formats
Benchmark Result Schema (v1.1, Legacy)
API Reference
Development
Getting Started with Development
Getting Started with Development
Development Guide
BenchBox Testing Guide
Live Integration Tests
Architecture & Design
Architecture & Design
Design & Architecture
Design & Architecture
BenchBox Architecture
BenchBox Repository Structure
BenchBox Architecture
BenchBox Repository Structure
Import Patterns and Lazy Loading
Platform Development
Platform Development
Adding New Platform Adapters
Adding a New DataFrame Platform
TPC-DS DataFrame parity
Runtime Module Architecture Overview
DB API 2.0: Foundation of BenchBox Platform Support
BenchBox Architecture
Testing Documentation
Testing Documentation
End-to-End (E2E) Testing Guide
Docker Integration Tests
Live Integration Tests
Browse by Tag
By Audience
By Audience
beginner (19)
intermediate (95)
advanced (30)
contributor (34)
By Benchmark
By Benchmark
tpc-h (13)
tpc-ds (10)
tpc-di (5)
tpc-havoc (1)
tpch-skew (1)
ssb (16)
clickbench (54)
h2odb (13)
join-order (1)
amplab (10)
nyctaxi (28)
coffeeshop (14)
datavault (25)
tsbs-devops (1)
read-primitives (1)
write-primitives (1)
transaction-primitives (1)
metadata-primitives (2)
ai-primitives (1)
custom-benchmark (23)
By Platform
By Platform
duckdb (4)
sqlite (2)
postgresql (2)
datafusion (1)
snowflake (3)
databricks (3)
bigquery (2)
redshift (1)
motherduck (1)
starburst (1)
clickhouse (3)
trino (1)
presto (1)
firebolt (1)
timescaledb (2)
influxdb (1)
athena (1)
aws-glue (1)
emr-serverless (1)
athena-spark (1)
dataproc (1)
dataproc-serverless (1)
azure (1)
fabric (1)
fabric-spark (1)
synapse-spark (1)
spark (2)
pyspark (1)
pandas (1)
polars (3)
dask (1)
modin (1)
cudf (1)
datafusion-df (1)
By Platform Type
By Platform Type
sql-platform (33)
dataframe-platform (19)
cloud-platform (22)
embedded-platform (2)
cloud-storage (3)
By Content Type
By Content Type
guide (116)
tutorial (5)
reference (1357)
concept (32)
quickstart (4)
By Feature
By Feature
architecture (4)
cli (26)
cloud (6)
e2e (1)
python-api (55)
configuration (3)
data-generation (3)
performance (11)
tuning (3)
validation (14)
testing (7)
visualization (7)
ClickBench Query Templates — text_and_pattern_matching
All ClickBench query groups
Query
Name
Q21
URL Google Count
Q22
Google URL Search Phrases
Q23
Google Title Analysis
Q24
Google URL Full Rows
Q25
Search Phrase by Time
Q26
Search Phrase Lexicographic
Q27
Search Phrase Compound Sort