Original link: https://timemachine.icu/posts/56052ea3/
foreword
Materialized View (Materialized View) is essentially a kind of pre-computation, that is, the results of some time-consuming operations (such as JOIN, AGGREGATE) are saved for direct reuse during query, so as to avoid these time-consuming operations, and finally achieve The purpose of speeding up the query. As a retrieval acceleration technology, it is used in many olap engines. This article takes Doris as an example to mainly introduce Doris’s materialized view implementation, application scenarios, and how to check whether the materialized view is hit, and if not, what are the reasons.
This article is reproduced from: https://timemachine.icu/posts/56052ea3/
This site is for inclusion only, and the copyright belongs to the original author.