ygf11 opened a new issue, #4724:
URL: https://github.com/apache/arrow-datafusion/issues/4724
**Is your feature request related to a problem or challenge? Please describe
what you are trying to do.**
This sql works in datafusion:
```sql
> select * from t1 where t1_id in (select t2_id from t2);
```
but following sql does not works:
```sql
> select * from t1 where t1_id + 11 in (select t2_id from t2);
NotImplemented("Physical plan does not support logical expression
CAST(t1.t1_id AS Int64) + Int64(11) IN (<subquery>)")
```
**Describe the solution you'd like**
We can rewrite these subquery to join.
**Describe alternatives you've considered**
**Additional context**
--
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]
