Building Real-time Applications with ClickHouse Materialized Views

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

[@user-gg3ss6ey7p]

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]

clickhouse.com/learn

[@donnasblissfulbeads9392]

Is there a link to see the full materialize views and dictionaries used for the flight demo?

[@ClickHouseDB]

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]

@@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]

@@ClickHouseDBwhat library are you using for the spinning Earth view? Can you elaborate more on the “geo dictionaries” that are used?