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
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
ClickHouse
ClickPipes와 Materialized View로 구현하는 실시간 데이터 변환과 평탄화 기반 분석 실현
Ken Lee, Solution Architect, ClickHouse
Follow us
