Optimize high-performance SQL queries
clickhouse-ioskillsetup L3★0
Sheshiyer/skill-clusters ↗What it does
Query massive structured logs with SQL at scale
Best for
Sub-second queries on terabyte-scale immutable logs (OLAP, not OLTP).
Inputs
- · SQL queries
- · log table (JSON, CSV, Parquet)
Outputs
- · Query results (JSON, CSV, Parquet)
- · execution time
Requires
- · ClickHouse database
- · ClickHouse client
Preconditions
ClickHouse server running, tables created, network access
Failure modes
SQL syntax error, table not found, query timeout on 100B+ rows
Trust signals
- · Columnar compression
- · Vectorized execution
- · Parallel query