Videos / ClickHouse
Can you PIVOT in ClickHouse?
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
Follow us
Products
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.