v.22.10New Feature
Adds Morton Coding (ZCurve) Encode/Decode Functions
Adds Morton Coding (ZCurve) encode/decode functions. #41753 (Constantine Peresypkin).
Why it matters
This feature introduces Morton Coding (ZCurve) functions, which enable efficient spatial indexing by interleaving bits of coordinates. It helps users perform spatial queries and data organization more effectively using space-filling curves.How to use it
Use the new Morton Coding functions in your SQL queries to encode coordinates into Morton codes or decode Morton codes back into coordinates. These functions can be applied directly inSELECT statements or during data transformations to facilitate spatial data processing.