Re:SQL Anti-Patterns You Should Avoid
by Little_Kitty on Saturday October 18, 2025 @04:04PM
(#45630005)
It's great being able to use an any join (and the counterpart anti join) in Clickhouse to deal with these operations.
SELECT * FROM t1 SEMIJOIN t2 USING (x);
although it creates some extra problems for the join optimizer.