local table join and insert for distributed table

[aflyflyv2]

Make sure to check documentation https://clickhouse.com/docs/en/ first. If the question is concise and probably has a short answer, asking it in Telegram chat https://telegram.me/clickhouse_en is probably the fastest way to find the answer. For more complicated questions, consider asking them on StackOverflow with "clickhouse" tag https://stackoverflow.com/questions/tagged/clickhouse

If you still prefer GitHub issues, remove all this text and ask your question here.

[aflyflyv2]

The same requirement as this post: https://stackoverflow.com/questions/72270323/how-can-clickhouse-local-join-and-local-insert-on-distributed-tables

I have several tables with the same shard key(id), and want to perform table join(prefer local table join) and insert into local table on the same shard, so that all the join can be done within the same shard.

can it be done as below?

insert into t_user_flat_local             -- use local
select * 
from t_user_info_all               t1      -- use   all
left join t_user_event_local    t2      -- use   local
on t1.user_id = t2.user_id

[den-crane]

It's impossible currently