francis0407 opened a new pull request #23783: [SPARK-26854][SQL] Support ANY/SOME subquery URL: https://github.com/apache/spark/pull/23783 ## What changes were proposed in this pull request? This PR adds `ANY` subquery support in SQL. ANY syntax: ``` SQL SELECT column(s) FROM table WHERE column(s) operator ANY (SELECT column(s) FROM table WHERE condition) ``` The implementation is based on `IN` subquery. `IN` subquery can be regarded as a special case of `ANY` subquery whose operator should be "=". As `IN` subquery will be rewrote as semi/anti join, the only difference between them is that `ANY` subquery should change the `comparisonExpression`. This PR adds a new class `SubqueryPredicate`, which can be implemented by `InSubquery`, `AnySubquery` and also `AllSubquery`. ## How was this patch tested? Added simple unit tests.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
