Materialized Views and Projections Under the Hood

[zingsting]

This should be one of the first videos to be presented to clickhouse noobs as it contains the very basic concept of parts and merges that are not very well introduced in the written documentation. Either update the docs or change the title of the video to intro to clickhouse.

[joesligo]

Extremely helpful video, particularly explaining the concepts on agg mergetrees in theory never merging to a single file. It was very counterintuitive for me at first.

[belferman]

Fantastic explanation, made it very simple. Thanks!

[mayankpant]

Projection is great. if you have very defined use-case, it abstracts away all the complexity of materialized view. Will we be able to create separate indexes on projection queries too?

[karthikvk]

If i create a projection on a table that has data, will the project process both existing and new data to that table or just only new inserts?

[fille.imgnry]

Great explanations, except that the avg price example in the materialized view is actually showing the sum of the prices. 😮