Default HashJoin Not Thread-Safe; Performance Issues with Large Right Tables
Official CH changelog text
The default HashJoin is not thread safe for inserting right table's rows and run it in a single thread. When the right table is large, the join process is too slow with low cpu utilization. #36415 (lgbo).