search

substrait-io / substrait

A cross platform way to express data transformation, relational algebra, standardized record expression and plans.
https://substrait.io
Apache License 2.0
1.11k stars 147 forks source link

feat: add single match join #623

Closed EpsilonPrime closed 3 months ago

EpsilonPrime commented 3 months ago

This establishes the physical single join relation. Similar to other joins it uses an expression to compare the left and right inputs. What sets it apart from other joins is that it requires that each row be involved in at most one match. This kind of join is commonly used in unnesting arbitrary subqueries.

EpsilonPrime commented 3 months ago

As noted above we already have a single join, closing this one as unneeded.