[CH] Support using left side as the build table for the left anti/semi join

apache / incubator-gluten

Gluten is a middle layer responsible for offloading JVM-based SQL engines' execution to native engines.

https://gluten.apache.org/

Apache License 2.0

1.22k stars 437 forks source link

[CH] Support using left side as the build table for the left anti/semi join #7971

Closed zzcclp closed 1 day ago

zzcclp commented 3 days ago

Description

Now Vanilla Spark does not support the right anti/semi join, but CH backend does. According to the runtime statistics, it can convert the A left anti/semi join B to B right anti/semi join A when AQE is on and the side ot A table is the smaller than B table.