[SPARK-33337] Support subexpression elimination in branches of conditional expressions

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: L. C. Hsieh
• Reporter: L. C. Hsieh
• Created: 04/Nov/20 06:14
• Updated: 13/Nov/20 20:49
• Resolved: 11/Nov/20 00:17

Description

Currently we skip subexpression elimination in branches of conditional expressions including If, CaseWhen, and Coalesce. Actually we can do subexpression elimination for such branches if the subexpression is common across all branches.

Issue Links

• links to: [Github] Pull Request #30245 (viirya)
• links to: [Github] Pull Request #30371 (viirya)