[SPARK-36112] Enable DecorrelateInnerQuery for IN/EXISTS subqueries

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Andrey Gubichev
• Reporter: Allison Wang
• Created: 13/Jul/21 04:20
• Updated: 14/Oct/23 00:22
• Resolved: 05/Oct/23 14:45

Description

Currently, `DecorrelateInnerQuery` is only enabled for scalar and lateral subqueries. We should enable `DecorrelateInnerQuery` for IN/EXISTS subqueries. Note we need to add the logic to rewrite domain joins in `RewritePredicateSubquery`.

Issue Links

• links to: GitHub Pull Request #43111