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.