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, ClickHouse Cloud

Maximizando a produtividade dos seus Agentes de IA com ClickHouse

ClickHouse

How to Remain Competitive in the AI Era of Software Engineering

Alexey Milovidov, CTO, ClickHouse

Langfuse, ClickHouse

Observing and Improving AI Agents with Langfuse

AI agents are moving from prototypes into production. Teams still struggle to understand what agents are doing, why they fail, and how to improve them systematically.