Star Schema Benchmark: ClickHouse® on Nirvana × Altinity
Can a single ClickHouse BYOC node stay responsive across 3 billion rows? Our ClickHouse Star Schema Benchmark measured selective query latency as low as 34 ms.
Pipeline Optimization for ClickHouse® Distributed Tables with Synchronous Inserts
Using materialized views to process data from Kafka into ClickHouse® is a common architecture. See how changing where a materialized view wrote its rows reduced ingestion lag by more than 50%.
The Antalya Playground and ClickHouse® Demo Apps
Last year, Project Antalya arrived, integrating ClickHouse® with Iceberg data lakes to bring low-cost object storage to real-time analytics. Now you can try out these features yourself in the new Antalya Playground.
Transforming ClickHouse® into a DataLake Query Engine with Antalya Swarms
Antalya swarms are clusters of stateless ClickHouse servers that can give you real-time query performance for Parquet files and Iceberg catalogs. See how standalone swarms add even more flexibility.
The S3Queue Keeper Case: Lag, Pressure, and the Fix That Held
ClickHouse ingestion lag can have many causes. In this case, creating a separate Keeper for S3Queues solved the problem. See how we found the culprit, designed a solution, pushed it into ClickHouse, and delivered it to the customer.
OAuth Alert! Token-based Authentication Lands in Altinity Antalya Builds
Altinity Antalya’s support for token authentication lets you use OAuth to manage access to your ClickHouse server with any OIDC-compliant identity provider.
The Hidden Timezone Rules of DateTime in ClickHouse®
Understand how ClickHouse parses and displays DateTime values, manages timezones, and handles DST to prevent unexpected query results and filtering errors.