[ https://issues.apache.org/jira/browse/SPARK-26854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mingcong Han updated SPARK-26854: --------------------------------- Summary: Support ANY/SOME subquery (was: Support ANY subquery) > Support ANY/SOME 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org