Feature request: theta joins, advanced joins

[ipazin]

Hello @Ema,

some use cases can be addressed with Binner (Dictionary) node. Also here is nice topic in case you missed:

Efficient way of doing a JOIN ... WHERE ...

I have two tables table_a and table_b the first table has a time span data in stored as two columns start_date and end_date the second table has time point data. I want to join those table in such a way that only those rows match where the time point lies within the time span. My current way if a two step. (1) do a cross join, than (2) apply a row filter. This is super inefficient. I have something like 300’000 rows in one table and 4*365 (4 years each having 365 days) in the other one. The re…

Will add +1 to already existing ticket mentioned in linked topic.

Br,
Ivan