Symmetric hash join
Appearance
The symmetric hash join is a special type of hash join designed for data streams.[1][2]
Algorithm
- For each input create a hash table
- For each new record hash and insert into inputs hash table
- Test if input is equal to a pre defined set of other inputs
- If so then output the records
- Test if input is equal to a pre defined set of other inputs