ClickHouse 25.7 adds GeoParquet support

Mark Needham

This video explores an exciting new feature introduced in ClickHouse 25.7: the ability to read and write geotypes when working with Parquet files. We'll explore how this functionality works, demonstrate its practical applications, and even examine a real-world dataset from Overture maps.

Throughout the tutorial, we'll cover:

• Writing various geotypes to a Parquet file and examining the results
• Understanding the limitations of Geo type support in Parquet, particularly with ring types
• Using the 'parq' tool to inspect Parquet file metadata
• Working with the Overture maps dataset to showcase real-world Geo type handling
• Creating and running queries on Geo types data stored in Parquet format