[SEDONA-56] Broadcast join doesn't work with AQE enabled

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Adam Binford
• Created: 05/Aug/21 14:22
• Updated: 09/Aug/21 22:25
• Resolved: 09/Aug/21 22:25

Description

If you have AQE enabled (spark.sql.adaptive.enabled=true), broadcast joins fail with a MatchError due to: https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/execution/adaptive/AdaptiveSparkPlanExec.scala#L533-L560. This is because SpatialJoinExec extends `Exchange`, but doesn't implement BroadcastExchangeLike. It needs to be updated to either not extend Exchange, or make direct use of `BroadcastExchangeExec` instead of doing the broadcast itself. 

Current workaround is disable AQE, which is the current default but will be enabled by default  starting in Spark 3.2.

Issue Links

• links to: GitHub Pull Request #534