[SPARK-25154] Support NOT IN sub-queries inside nested OR conditions.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Dilip Biswal
• Reporter: Dilip Biswal
• Created: 18/Aug/18 22:14
• Updated: 10/Apr/20 23:31
• Resolved: 10/Apr/20 23:31

Description

Currently NOT IN subqueries (predicated null aware subquery) are not allowed inside OR expressions. We currently catch this condition in checkAnalysis and throw an error.

We need to extend our subquery rewrite frame work to support this type of queries.

Issue Links

• links to: [Github] Pull Request #22141 (dilipbiswal)
• links to: GitHub Pull Request #22141
• links to: GitHub Pull Request #28158