Is your feature request related to a problem? Please describe.
Native broadcast hash joins previously restricted residual conditions to inner joins. Other supported join types must evaluate the condition before updating match state or producing unmatched rows.
Duplicate keys can also produce large candidate sets that need to be evaluated in bounded batches.
Describe the solution you'd like
- Integrate the shared join-condition evaluator into native broadcast hash joins.
- Apply residual conditions before finalizing outer, semi, anti, and existence join results.
- Bound candidate batches within duplicate-key ranges while preserving match state across batches.
- Preserve projected schemas, condition-only columns, and row counts for zero-column output.
- Pass output projections through the sort-merge fallback.
- Enable residual conditions for supported broadcast hash join types and add native and Spark regression tests.
Is your feature request related to a problem? Please describe.
Native broadcast hash joins previously restricted residual conditions to inner joins. Other supported join types must evaluate the condition before updating match state or producing unmatched rows.
Duplicate keys can also produce large candidate sets that need to be evaluated in bounded batches.
Describe the solution you'd like