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
ClickPipes와 Materialized View로 구현하는 실시간 데이터 변환과 평탄화 기반 분석 실현
Ken Lee, Solution Architect, ClickHouse
ClickHouse Cloud, ClickHouse
What Benchmarks Miss: Measuring the True Cost of Real-Time Analytics
ClickHouse, ClickHouse Cloud
Maximizando a produtividade dos seus Agentes de IA com ClickHouse
Follow us
