[SPARK-40501] Add PushProjectionThroughLimit for Optimizer

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Pan Bingkun
• Reporter: Pan Bingkun
• Created: 20/Sep/22 09:22
• Updated: 26/Sep/22 07:50
• Resolved: 26/Sep/22 07:50

Description

It took a long time to fetch out, still running after 20 minutes...

when run as follow code in spark-shell:

spark.sql("select * from xxx where event_day = '20220919' limit 1").show()

Issue Links

• links to: [Github] Pull Request #37941 (panbingkun)