v.25.6New Feature

Support functions to read WKB

Official CH changelog text
Support functions to read WKB ("Well-Known Binary" is a format for binary encoding of various geometry types, used in GIS applications). See #43941. #80139 (scanhex12).
Added support for functions to read WKB (Well-Known Binary) geometry data format in ClickHouse.

Why it matters

This feature enables users to import and process spatial data encoded in the WKB format, commonly used in GIS applications. It solves the problem of handling binary geometry data natively in ClickHouse, improving interoperability and expanding spatial data support.

How to use it

Users can now use the new WKB reading functions to parse binary-encoded geometry data directly within their SQL queries. This allows seamless integration of WKB data without external conversion.

Related resources

PreviousNext