Math Games in ClickHouse® — Solving Project Euler Problems
ClickHouse is an extremely versatile DBMS. When presenting it to newbies, I sometimes describe it as a combination of four “F”-s: Fast, Flexible, Fun and Free. We often benchmark ClickHouse in different scenarios to demonstrate how fast it is. Case…
New Tips and Tricks that Every ClickHouse® Developer Should Know
Discover seven advanced ClickHouse® developer tips from Altinity CEO Robert Hodges, covering fast S3 data reads with named collections, codec-based compression, ORDER BY optimization, ReplacingMergeTree deduplication, RBAC replication via ZooKeeper, TTL recompression, and using aggregation to replace costly joins.
Deep Dive on ClickHouse®: Sharding and Replication Webinar
This talk walks you through sharding and replication, showing how Altinity experts enable clusters that deliver fast queries over petabytes of data. Starting with basic definitions of each, then moving to practical issues.
Altinity Quickstart for ClickHouse®: Creating Your First Application
ClickHouse quickstart: columnar storage, MergeTree tables, loading from CSV and S3, countIf and argMax aggregates, hash joins, and codec compression tips.
Size Matters: Best Practices for Trillion Row Datasets on ClickHouse®
Schema design, codecs, conditional aggregation, array-based join simulation, and MV indexing for sub-second queries on trillion-row ClickHouse tables.
All about JSON and ClickHouse®: Tips, tricks, and new features!
JSON in ClickHouse: loading via JSONEachRow, string blobs, materialized columns, paired arrays, Map type, and the new JSON data type with codecs.
Webinar: Tips and tricks every ClickHouse® user should know.
New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We’ll talk about…