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

User stories, Meetups
ClickHouse at DoorDash
How DoorDash monitors TCP and DNS traffic helping their observability team take care of their kubernetes infrastructure.

Open House
Open House NYC: Keynote
Keynote from Open House Roadshow NYC 2025.

Open House
Open House NYC: ClickHouse for AI/ML
Zach Naimon, Principal Product Manager at ClickHouse
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.