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

[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