Can you PIVOT in ClickHouse?
Previous videoMaximising Analytics with ClickHouse and Kafka IntegrationNext videoAn intro to Refreshable Materialized Views
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
Recent videos
View all Videos
Open House, ClickHouse
How to build a great database (Alexey Milovidov)
The principles behind building a great database, and the new frontiers shaping the field.
ClickHouse, ClickHouse Cloud
Data Architecture Blueprints featuring Zappi
ClickHouse
Measuring the True Cost of Real-Time Analytics
In this webinar, we’ll follow the full path from incoming events to materialized views to live analytics, comparing ClickHouse with other cloud data warehouses to reveal which systems deliver the most real-time performance per dollar when the data never stops moving.
ClickHouse, ClickHouse Cloud
How to build a unified data stack with Postgres and ClickHouse
Follow us
