Hi everyone,
I recently published a technical blog on Z-Ordering vs Liquid Clustering in Delta Lake, covering the internals of both techniques in detail.
Rather than focusing only on the syntax, the blog goes deeper into:
The origin of Z-Ordering โ tracing back to Morton's space-filling curve from 1966
How bit interleaving works and how Z-values are computed
Why Z-Ordering degrades over time on live, continuously loaded tables
How Liquid Clustering addresses this using the Hilbert Curve
What CLUSTER BY AUTO does internally โ query pattern tracking and frequency scoring
Why partitioning and Liquid Clustering are incompatible per the official documentation
Practical recommendations from real Supply Chain ATP implementations
The blog is built around a Supply Chain Available to Promise scenario to keep the concepts grounded in a real-world context.
Would appreciate any feedback or thoughts from the community.
https://medium.com/@pmanoj0104/z-ordering-vs-liquid-clustering-a79a12ad0038
