▲ | Sesse__ 12 hours 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 10 hours ago | parent [-] | |
It's great being able to use an any join (and the counterpart anti join) in Clickhouse to deal with these operations. |