Joins tuple from two input streams iff their timestamps are overlapping and if the optional predicate validates to true.
predicate:
The predicate to evaluate over each incoming tuple from left and rightcard:
ONE_ONE, ONE_MANY, MANY_ONE, MANY_MANY (same as empty, see below)SweepAreaName:
Overwrite the default rule for using sweepAreas (e.g. TIJoinSA is used if the predicate contains other operations than "==", HashJoinSA is used if the predicate only contains "==")
The card parameter describes how input elements can be joined. This optional information can be used to optimize processing (i.e. using less memory, because elements can earlier be discarded).
output = join({predicate = 'auction_id = auction'}, left, right) |
SELECT * FROM left, right WHERE auction_id = auction |