Z-order or Hilbert Curve, which is better

brickster_2018 — Fri, 25 Jun 2021 22:45:55 GMT

For Optimize on Delta table, there is support for 2 spatial curve algorithms. Which is better. Which one to choose for my workload.

Re: Z-order or Hilbert Curve, which is better

amr — Mon, 28 Jun 2021 17:57:32 GMT

The OPTIMIZE ZORDER operation now uses Hilbert space-filling curves by default. This approach provides better clustering characteristics than Z-order in higher dimensions. For Delta tables using OPTIMIZE ZORDER with many columns, Hilbert curves can speed up read queries by skipping more data than Z-order. For details, see Z-Ordering (multi-dimensional clustering).

topic Z-order or Hilbert Curve, which is better in Data Engineering

Z-order or Hilbert Curve, which is better

Re: Z-order or Hilbert Curve, which is better