Qifan Pu created SPARK-24838:
--------------------------------
Summary: Support uncorrelated IN/EXISTS subqueries for more
operators
Key: SPARK-24838
URL: https://issues.apache.org/jira/browse/SPARK-24838
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 2.3.1
Reporter: Qifan Pu
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:
{code:java}
Error in SQL statement: AnalysisException: IN/EXISTS predicate sub-queries can
only be used in a Filter
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
