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
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.