[GitHub] [arrow-datafusion] ygf11 opened a new issue, #4442: Add support for non-column key for equijoin in eliminating cross join to inner join

[GitBox <gi...@apache.org>]

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: github-unsubscribe@arrow.apache.org.apache.org

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

[GitHub] [arrow-datafusion] alamb closed issue #4442: Add support for non-column key for equijoin when eliminating cross join to inner join

[GitBox <gi...@apache.org>]

alamb closed issue #4442: Add support for non-column key for equijoin when eliminating cross join to inner join  
URL: https://github.com/apache/arrow-datafusion/issues/4442


-- 
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