v.25.11New Feature

Geometry Data Type

Official CH changelog text
Introduce Geometry type. Support reading WKB and WKT formats for it. In previous versions, the Geometry type was aliased to String, but now it is a full-featured type. #83344 (scanhex12).
Introduce a dedicated Geometry data type in ClickHouse with support for reading Well-Known Binary (WKB) and Well-Known Text (WKT) formats, replacing the previous alias to String.

Why it matters

Previously, the Geometry type was merely an alias for String, which limited spatial data handling capabilities. This new implementation provides a full-featured Geometry type that enables more accurate and efficient processing of spatial data by directly supporting standard geometry formats like WKB and WKT.

How to use it

Users can define columns with the Geometry type to store spatial data. Data in WKB or WKT formats can be read directly into this type without manual conversion. This enhances compatibility with spatial data sources and allows leveraging ClickHouse's spatial functions and indexing capabilities.

Related resources

PreviousNext