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

Open House
Scaling ClickHouse to petabytes of logs at OpenAI

Open House
How ClickHouse helps Anthropic scale observability

Open House, User stories
How Capital One Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.