[
https://issues.apache.org/jira/browse/ARROW-10819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17257088#comment-17257088
]
Andy Grove commented on ARROW-10819:
------------------------------------
The example given here is a correlated subquery that can be translated into a
join.
Here is a random stackoverflow discussion on this for reference (I have not
reviewed it)
https://stackoverflow.com/questions/1772609/procedurally-transform-subquery-into-join
> [Rust] [DataFusion] Implement EXISTS operator
> ---------------------------------------------
>
> Key: ARROW-10819
> URL: https://issues.apache.org/jira/browse/ARROW-10819
> Project: Apache Arrow
> Issue Type: New Feature
> Components: Rust - DataFusion
> Reporter: Mike Seddon
> Priority: Major
> Fix For: 3.0.0
>
>
> The TPC-H queries include use of the EXISTS which is used to test for the
> existence of any record in a subquery. For example:
> and *exists* (
> select
> *
> from
> lineitem
> where
> l_orderkey = o_orderkey
> and l_commitdate < l_receiptdate
> )
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
