Z-Ordering VS Liquid Clustering

ManojSampath — Tue, 09 Jun 2026 07:48:40 GMT

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

topic Z-Ordering VS Liquid Clustering in Community Articles

Z-Ordering VS Liquid Clustering