Videos / ClickHouse
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 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
ClickHouse
The ClickHouse monitoring dashboard
Mark Needham, Product Marketing Engineer
Follow us
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.