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

   ### Describe the bug
   
   DataFusion CLI v21.0.0
   
   ```
   CREATE EXTERNAL TABLE t1 (a INT, b INT) STORED AS CSV LOCATION 'data.csv';
   CREATE EXTERNAL TABLE t2 (a INT, b INT) STORED AS CSV LOCATION 'data.csv';
   SELECT a, b FROM t1 WHERE EXISTS (SELECT count(*) FROM t2);
   ```
   return:
   This feature is not implemented: Physical plan does not support logical 
expression EXISTS (<subquery>)
   
   DataFusion CLI v19.0.0  worked.
   
   
   ### To Reproduce
   
   create data.csv
   
   `echo "1,2" > data.csv`
   
   use datafusion-cli
   ```
   
   CREATE EXTERNAL TABLE t1 (a INT, b INT) STORED AS CSV LOCATION 'data.csv';
   CREATE EXTERNAL TABLE t2 (a INT, b INT) STORED AS CSV LOCATION 'data.csv';
   SELECT a, b FROM t1 WHERE EXISTS (SELECT count(*) FROM t2);
   
   ```
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to