[jira] [Commented] (ARROW-10819) [Rust] [DataFusion] Implement EXISTS operator

["Andy Grove (Jira)" <ji...@apache.org>]

    [ 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)