Data Lake Query Acceleration using Standalone Antalya Swarms
Antalya standalone swarms allow any ClickHouse® server to accelerate data lake queries and lower costs. Learn how to set up standalone swarms and use them.
The Future Has Arrived: Parquet on Iceberg Finally Outperforms MergeTree
Recent developments in ClickHouse® and Project Antalya elevate Iceberg support to a new level – matching and in some cases outperforming MergeTree, while enabling cheap object storage and scalable, shared data systems.
Learning to appreciate monotonic functions in ClickHouse®
Introduction ClickHouse has an amazing number of optimizations that enable it to fetch data quickly, often involving math concepts that don’t sound particularly interesting to most users. One such optimization involves monotonically increasing functions (say that five times fast). Deep…
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 2)
We continue learning SQL by solving math puzzles from Project Euler. This article shows how to extend ClickHouse capabilities with a user defined function (UDF) written in C++.
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 1)
Solving math puzzles from Project Euler is a great way to learn about ClickHouse SQL, especially array functions. Math can also help you speed up queries by orders of magnitude.
ClickHouse® MergeTree on S3 – Keeping Storage Healthy and Future Work
The final article of our series on managing large datasets in ClickHouse MergeTree covers how to clean up orphan S3 files. We conclude with ideas for future improvements to S3 storage management.
ClickHouse® MergeTree on S3 – Administrative Best Practices
Our series on managing large datasets in ClickHouse MergeTree tables continues. In Part 2 we discuss best practices for S3 bucket configuration, storage policies, and MergeTree table administration.
ClickHouse® ReplacingMergeTree Explained: The Good, The Bad, and The Ugly
How much do you know about ClickHouse ReplacingMergeTree? Learn about this powerful engine, how it works, and all its functionalities | old and new | so you can build real-time synchronization pipelines from OLTP databases like MySQL.
Ultra-Fast AWS Graviton Instances in Altinity.Cloud®
AWS introduced new instance type families, powered by Graviton3 ARM processors: m7g and r7g. We tested m7g’s performance using the ClickHouse SSB workload and found it’s 35% faster its older brother m6g, and 15% faster than Intel m6i instance! Learn…
How much does Altinity.Cloud® cost?
Altinity.Cloud has a simple, flexible billing model. Learn how billing works and how to tune resources for cost-efficient analytics.
{ ClickHouse®: “JSON data type”, version: 22.6 }
JSON data type is one of the most popular ClickHouse additions of 2022. It offers simple storage and easy query syntax. What’s not to like?
Momentum Dash is Building a More Centered Work Environment with PostHog and Altinity
Momentum Dash uses PostHog and Altinity to understand the needs of their two million users. Read how ClickHouse analytics drive product development.