Yuming Wang created SPARK-36444: ----------------------------------- Summary: Remove OptimizeSubqueries from batch of PartitionPruning Key: SPARK-36444 URL: https://issues.apache.org/jira/browse/SPARK-36444 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.3.0 Reporter: Yuming Wang
To support this case: {code:sala} sql( """ |SELECT date_id, product_id FROM fact_sk f |JOIN (select store_id + 3 as new_store_id from dim_store where country = 'US') s |ON f.store_id = s.new_store_id """.stripMargin) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org