Тёмный

Building Real-time Applications with ClickHouse Materialized Views 

ClickHouse
Подписаться 8 тыс.
Просмотров 7 тыс.
50% 1

Dale McDiarmid from ClickHouse explored the concept of building real-time applications using materialized views. Emphasizing ClickHouse's strength in handling fast queries across billions of rows, he explained how materialized views can be used to summarize data, significantly enhancing query performance.
#realtimeanalytics #clickhouse

Наука

Опубликовано:

 

2 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 6   
@user-gg3ss6ey7p
@user-gg3ss6ey7p 9 месяцев назад
This is wonderful! Curious if there's an end-to-end course we can take with clickhouse to learn how to make these demos?
@ClickHouseDB
@ClickHouseDB 9 месяцев назад
clickhouse.com/learn
@donnasblissfulbeads9392
@donnasblissfulbeads9392 7 месяцев назад
Is there a link to see the full materialize views and dictionaries used for the flight demo?
@ClickHouseDB
@ClickHouseDB 7 месяцев назад
There isn't at the moment. The code is a bit complex and would need to be cleaned up. We'll see if we can come up with something else that combines MVs and dictionaries so that you can see how they work together.
@donnasblissfulbeads9392
@donnasblissfulbeads9392 7 месяцев назад
@@ClickHouseDB Thanks for that! I am trying to use a combination of materialize views and dictionaries to be able to simulate data moving based on in and out of a condition. For example , given a plane, I would send a message in Kafka when the airplane "IS_IN_FLIGHT" and when the flight is finished "IS_NOT_OPERATING_A_FLIGHT". Or maybe you send a Kafka message, when the plane is IN_PORTUGAL and OUT_OF_PORTUGAL. Not sure how to simulate this yet, but probably the flight demo would give me an idea. Thanks again!
@beastmanrage
@beastmanrage 7 месяцев назад
@@ClickHouseDBwhat library are you using for the spinning Earth view? Can you elaborate more on the “geo dictionaries” that are used?
Далее
Materialized Views and Projections Under the Hood
22:46
In-depth: ClickHouse vs PostgreSQL
7:33
Просмотров 10 тыс.
An intro to Materialized Views in ClickHouse
6:44
Просмотров 4,2 тыс.
ClickHouse at Scale
26:44
Просмотров 11 тыс.
Kafka in 100 Seconds
2:35
Просмотров 830 тыс.
Вредные советы ClickHouse
32:04
Просмотров 6 тыс.
ПОКУПКА ТЕЛЕФОНА С АВИТО?🤭
1:00