ygf11 opened a new issue, #4442: URL: https://github.com/apache/arrow-datafusion/issues/4442
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Currently datafusion support to rewrite cross join to inner join. For example: ```sql select * from test0 as t0 cross join test1 as t1 where t0.a = t1.a; select * from test0 as t0 cross join test1 as t1 where t0.b = t1.b; ... ``` But only when the join keys are column, so the following sql will not rewrite to `inner join`. ```sql select * from test0 as t0 cross join test1 as t1 where t0.a + 1 = t1.a * 2; select * from test0 as t0 cross join test1 as t1 where t0.a * 2 = t1.a - 1; ... ``` **Describe the solution you'd like** Add support for non-column key for equijoin in eliminating cross join to inner 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]
