Working with Arrays in ClickHouse
Mark Needham
Principal Product Marketing Manager, ClickHouse In this video, we'll learn all about working with arrays in ClickHouse. Starting with an overview of the array functions documentation, we dive into practical examples using a weather measurements dataset. Key topics include querying, grouping, and manipulating arrays to extract valuable insights like maximum and minimum temperatures, weather conditions, and more. The functions covered in this video include array_slice, array_max, array_min, array_filter, array_join, array_flatten, array_compact, and array_distinct.
Recent videos
View all Videos
How to
CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse
Marta Paes, Senior Product Manager at ClickHouse
How to
Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries
Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse
ClickHouse Cloud, How to
LogHouse, Observability for ClickHouse Cloud
Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.
ClickHouse, How to
Powering Feature Stores with ClickHouse
Mark Needham Principal Product Marketing Engineer, ClickHouse
Follow us
