How can I add column from one table to another in Clickhouse?

Question

I have a table having following columns: (id, col1,col2). I need to add col3 from a temporary table having (id,col3). So that after the operation table 1 should be: (id,col1,col2,col3) . After this, I drop the temporary table. How can this be done in Clickhouse?

I know of an approach that uses join table engine. However, join table data is stored in memory and I have memory resitrictions. How can I achieve the same result by not creating a in-memory table?

Answer 1

There is no magic in this realm. And the spoon does exists.

You can use that approach with samples and make many updates. Piece by piece by 10% for example.