mingmwang commented on PR #3912: URL: https://github.com/apache/arrow-datafusion/pull/3912#issuecomment-1303047208
> > We are also considering a range optimization on hash join, on queries like > > ```sql > SELECT ... > FROM left, right > WHERE left.x > right.y AND > left.x + left.y < right.x + 10 AND > left.z = left.x > ``` > > and it paves the way for a streaming execution of the `HashJoinExec`. We’d like to collaborate on this PR. I guess a google doc would be the perfect medium to share ideas @isidentical. Why this SQL can run `HashJoinExec` ? Could you please explain a bit? Since there is no equal-join conditions, we can not derive any equal join conditions from the original expression either. -- 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]
