Is your feature request related to a problem or challenge?

See the discussion at Comet: apache/datafusion-comet#194 (comment)

Yea, in DataFusion, only left side could be the build side. But in Spark, the HashJoin operator has a build side parameter to indicate which side is build side. The operator will do right thing accordingly internally. So currently we cannot just create a DataFusion HashJoin operator with right side as build side.

It can be swapped between left and right side, only if we also swap outputs and also column binding in joining keys and joining filter. I'd like to relax the build side constraint in DataFusion instead of doing the swap in Comet.

Describe the solution you'd like

HashJoin supports build right option.

Describe alternatives you've considered

No response

Additional context

No response