Visualizing Collatz Sequences with ClickHouse® and Grafana
Generate and visualize Collatz sequences in ClickHouse using recursive CTEs and arrayFold — all visualized in Grafana.
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.
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…
Harnessing the Power of ClickHouse® Arrays – Part 3
This final article completes our tour of array capabilities. We’ll survey functions for array map and reduce operations, demonstrating behavior and commenting on performance. This is an opportunity to dig further into lambdas, which are critical for using arrays effectively.
Harnessing the Power of ClickHouse® Arrays – Part 2
ClickHouse arrays combine neatly with GROUP BY aggregation. We show how arrays track sequences and offer a couple of ways to do funnel analysis.
Harnessing the Power of ClickHouse® Arrays – Part 1
ClickHouse contributors regularly add analytic features that go beyond standard SQL. This design approach is common in successful open source projects and reflects a bias toward solving real-world problems creatively. Arrays are a great example.
Introduction to High-Velocity Analytics Using ClickHouse® Arrays
Arrays are a prominent ClickHouse SQL extension that can accelerate query speed up to 100x in well-chosen use cases. This webinar introduces ClickHouse arrays and shows how to use them effectively. We provide examples of idiomatic usage and guides you…