Re: [I] ASOF join support / Specialize Range Joins [datafusion]

["xudong963 (via GitHub)" <gi...@apache.org>]

xudong963 commented on issue #318:
URL: https://github.com/apache/datafusion/issues/318#issuecomment-2405492685

   Leaving aside the asof join syntax.
   
   For range join, which contains non-equivalent join conditions, e.g. `t1.a > t2.b`, but no equivalent conditions, (timing scenario) such SQLs usually endure huge performance issues.
   
   We can solve some of these scenarios by introducing **iejoin**, you can refer to this paper https://wayang.apache.org/assets/pdf/paper/iejoin.pdf, which I have previously implemented in databend, can achieve impressive performance gains, https://github.com/databendlabs/databend/ pull/11412.
   
   If you plan to implement this, feel free to invite me to participate in the review!


-- 
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@datafusion.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org