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
How to build a unified data stack with Postgres and ClickHouse
ClickHouse
ClickPipes와 Materialized View로 구현하는 실시간 데이터 변환과 평탄화 기반 분석 실현
Ken Lee, Solution Architect, ClickHouse
ClickHouse Cloud, ClickHouse
What Benchmarks Miss: Measuring the True Cost of Real-Time Analytics
Follow us
