Major Description
How to reproduce:
sql(
"""
|SELECT s.store_id, f.product_id
|FROM (SELECT DISTINCT * FROM fact_sk) f
| JOIN (SELECT
| *,
| ROW_NUMBER() OVER (PARTITION BY store_id ORDER BY state_province DESC) AS rn
| FROM dim_store) s
| ON f.store_id = s.store_id
|WHERE s.country = 'DE' AND s.rn = 1
|""".stripMargin).show
Caused by: java.lang.UnsupportedOperationException: WholeStageCodegen (3) does not implement doExecuteBroadcast at org.apache.spark.sql.execution.SparkPlan.doExecuteBroadcast(SparkPlan.scala:297) at org.apache.spark.sql.execution.adaptive.AdaptiveSparkPlanExec.doExecuteBroadcast(AdaptiveSparkPlanExec.scala:323) at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeBroadcast$1(SparkPlan.scala:192) at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:217) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:214) at org.apache.spark.sql.execution.SparkPlan.executeBroadcast(SparkPlan.scala:188)
