Can you PIVOT in ClickHouse?

Name: Can you PIVOT in ClickHouse?
Uploaded: 2024-11-27T11:42:54.066Z
Description: 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

Previous videoScaling ClickHouse to petabytes of logs at OpenAI

Next 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

ClickHouse

Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries

This webinar explores how organizations use ClickHouse Materialized Views and Dictionaries.

ClickHouse

Building the Future Data Lakehouse: Iceberg & ClickHouse

Erlebe, wie du Performance, Offenheit und Governance in deiner Datenplattform vereinst

ClickHouse, ClickHouse Cloud, ClickStack

Introducing ClickStack: The Future of Observability on ClickHouse

Tristan Ahmadi, Solution Architect, ClickHouse