Yuming Wang created SPARK-39217: ----------------------------------- Summary: Makes DPP support the pruning side has Union Key: SPARK-39217 URL: https://issues.apache.org/jira/browse/SPARK-39217 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.4.0 Reporter: Yuming Wang
Support the following case: {noformat} SELECT f.store_id, f.date_id, s.state_province FROM (SELECT 4 AS store_id, date_id, product_id FROM fact_sk WHERE date_id >= 1300 UNION ALL SELECT store_id, date_id, product_id FROM fact_stats WHERE date_id <= 1000) f JOIN dim_store s ON f.store_id = s.store_id WHERE s.country IN ('US', 'NL') {noformat} -- This message was sent by Atlassian Jira (v8.20.7#820007) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org