2 ms·
Yes, I would certainly prefer if you could write SELECT * FROM t1 SEMIJOIN t2 USING (x); although it creates some extra problems for the join optimizer.
by Sesse__ 1y ago
Yes, I would certainly prefer if you could write
SELECT * FROM t1 SEMIJOIN t2 USING (x);
although it creates some extra problems for the join optimizer.
- Little_Kitty 1y agoIt's great being able to use an any join (and the counterpart anti join) in Clickhouse to deal with these operations.