You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/04/23 14:59:11 UTC

[GitHub] [arrow-datafusion] alamb opened a new issue, #123: Implement EXISTS operator

alamb opened a new issue, #123:
URL: https://github.com/apache/arrow-datafusion/issues/123

   *Note*: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-10819
   
   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 is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] xudong963 commented on issue #123: Implement EXISTS operator

Posted by GitBox <gi...@apache.org>.
xudong963 commented on issue #123:
URL: https://github.com/apache/arrow-datafusion/issues/123#issuecomment-1107516541

   Close the dup issue


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] xudong963 closed issue #123: Implement EXISTS operator

Posted by GitBox <gi...@apache.org>.
xudong963 closed issue #123:   Implement EXISTS operator
URL: https://github.com/apache/arrow-datafusion/issues/123


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] alamb commented on issue #123: Implement physical plan for EXISTS subquery

Posted by GitBox <gi...@apache.org>.
alamb commented on issue #123:
URL: https://github.com/apache/arrow-datafusion/issues/123#issuecomment-1287351002

   In case anyone is curious -- we support correlated versions of these queries (via a join) but if there is no correlation (not super useful) we do not
   
   ```
   ❯ create table foo as select * from (values (1), (2), (NULL)) as sql
   ;
   0 rows in set. Query took 0.022 seconds.
   3 rows in set. Query took 0.007 seconds.
   ❯ create table bar as select * from (values (1), (2), (NULL)) as sql;
   0 rows in set. Query took 0.000 seconds.
   ❯ select * from foo where exists (select column1 from bar);
   NotImplemented("Physical plan does not support logical expression EXISTS (<subquery>)")
   ❯ select * from foo where exists (select column1 from bar where foo.column1 = bar.column1);
   +---------+
   | column1 |
   +---------+
   | 2       |
   | 1       |
   +---------+
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org