v.24.6New Feature

Added support for LINESTRING geometry in WKT format with readWKTLineString function

Official CH changelog text
Added support for reading LINESTRING geometry in the WKT format using function readWKTLineString. #62519 (Nikita Mikhaylov).
Added support for reading LINESTRING geometry from WKT (Well-Known Text) format using the function readWKTLineString.

Why it matters

This feature enables users to parse and ingest LINESTRING geometries directly from WKT strings, facilitating spatial data analysis and manipulation within ClickHouse.

How to use it

Use the function readWKTLineString by passing a WKT-formatted LINESTRING string as an argument, for example:

SELECT readWKTLineString('LINESTRING(30 10, 10 30, 40 40)')

Related resources

PreviousNext