spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Apache Spark (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (SPARK-26854) Support ANY subquery
Date Thu, 14 Feb 2019 02:29:00 GMT

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

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

    Assignee:     (was: 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
>            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


Mime
View raw message