[jira] [Assigned] (SPARK-26854) Support ANY subquery

["Apache Spark (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-26854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Apache Spark reassigned SPARK-26854:
------------------------------------

    Assignee: Apache Spark

> Support ANY subquery
> --------------------
>
>                 Key: SPARK-26854
>                 URL: https://issues.apache.org/jira/browse/SPARK-26854
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 2.4.0
>            Reporter: Mingcong Han
>            Assignee: Apache Spark
>            Priority: Minor
>
> ANY syntax
> {quote}
> SELECT column(s)
> FROM table
> WHERE column(s) operator ANY
>     (SELECT column(s) FROM table WHERE condition);
> {quote}
> `ANY` subquery can be regarded as a generalization of `IN` subquery. And `IN` subquery is a special case of `ANY` subquery whose operator should be "=". The expression evaluates to `true` if the comparison between `column(s)` and any row in the subquery's result set returns `true`.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org