How materialized view works in Clickhouse

Question

I am trying to know how MV works when i insert batch with 10000 records.

How many times MV will work ? 1 time for all records or 10000 time?

And if another client insert in the same time what will happen?

Can anyone explain the mechanism. Thanks.

score 1 · Accepted Answer · answered Mar 16 '21 at 02:16

1

in general 1 time per insert.

Mat. view never reads a base table. Every insert propagates inserted block into MV.

answered Mar 16 '21 at 02:16

Denny Crane

1 Answers1