[SPARK-24838] Support uncorrelated IN/EXISTS subqueries for more operators

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.3.1
• Component/s: SQL
• Labels: bulk-closed
• Target Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Qifan Pu
• Created: 17/Jul/18 20:58
• Updated: 08/Oct/19 05:44
• Resolved: 08/Oct/19 05:44

Description

Currently, CheckAnalysis allows IN/EXISTS subquery only for filter operators. Running a query:

select name in (select * from valid_names)
from all_names

returns error:

Error in SQL statement: AnalysisException: IN/EXISTS predicate sub-queries can only be used in a Filter