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
Follow us
X imageBluesky imageSlack image
GitHub imageTelegram imageMeetup image
Rss image