ClickHouse source code is published under the Apache 2.0 License. Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

logo_without_text.svg

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Subscribe to our newsletter

icon-github.svg

icon-slack.svg

icon-telegram.svg

icon-twitter.svg

Join the ClickHouse conversation on

ClickHouse

ClickHouse Cloud

Download

PRODUCT

Documentation

Training

Support

Comparison

Use cases

RESOURCES

Blog

Our story

Careers

Contact us

News and events

COMPANY

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.

Mark Needham
Principal Product Marketing Manager, ClickHouse

Working with Arrays in ClickHouse

Linux, macOS, FreeBSD

In this video, we'll learn how to transform log entries using ClickHouse materialized views. We start with a bunch of log files in S3 and then show how to pull out the individual components using a regular expression and store them in a MergeTree table. We conclude by seeing that our solution can also handle any new files added to the S3 bucket.

Transforming log data with ClickHouse materialized views

In this video, we'll learn about conducting funnel analysis using ClickHouse. With the help of a UK weather dataset, we'll explore the UK's changeable weather, searching for the number of times that different combinations of weather conditions have happened over the last few years.

Videos / How to

Funnel Analysis with ClickHouse

Mark Needham Principal Product Marketing Manager, ClickHouse

Recent videos