Can you PIVOT in ClickHouse?
Mark Needham, Product Marketing Engineer
ClickHouse doesn't have a PIVOT clause, but we can get close to this functionality using aggregate function combinators. This video will show how to do this using the UK housing prices dataset.
Docs - https://clickhouse.com/docs/en/sql-reference/aggregate-functions/combinators#-map
ClickHouse, ClickHouse Cloud
Cyber in Real Time: How Seemplicity & Reco Supercharged Their Security Analytics
Watch a live webinar with Seemplicity & Reco on building the future of cybersecurity with ClickHouse.
ClickHouse Cloud, ClickHouse
Milliseconds Matter: Best Practices for Real-Time Analytics
Learn best practices for architecting scalable, low-latency analytics with ClickHouse.
ClickHouse
The ClickHouse MCP Server
Mark Needham
Follow us
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.