Sobes.tech

Data Engineer

Will a CTE be materialized if it is used only once for a JOIN with the final result?

5

What will happen to the final storefront built from a materialized view of the RAW layer if an existing row in the RAW table changes after the spill?

4

How would you handle high-load data transformations?

3

Data has been loaded into a ReplacingMergeTree table; what will happen during reading if the merge has not yet occurred, and how to get the latest version of the records?

2

Is it possible to combine deduplication and subsequent data spill without using separate tables; and if so, how?

2