[AUDIT][SPARK-36612][SQL] Support left outer join build left or right outer join build right in shuffled hash join

[cindyyuanjiang]

This change adds support for shuffled hash join in these scenarios:

• left outer join with left-side build
• right outer join with right-side build

We support GpuShuffledHashJoinExec. I am filing this to raise visibility.

Apache commit: apache/spark@0effbec16e

[revans2]

I'm not sure how critical this is. We will fall back to the CPU if we see this happen, and ShuffledHashJoins are off by default in Spark, so it is more likely to be a sort merge join that we see, and because we don't have any info about the side of the join, we just pick a build side that works for us.

[res-life]

A customer needs this, I'm working on this.