What could be an implication of using a regular inner join with fine-tuned Idle State retention time instead of Lookup join for kafka-stream-to-postgres-table relation?
It seems regular join doesn't require a primary key to be a join operand, then what is a benefit of Lookup Join over regular one?
Sergey Rachev
09/06/2024, 4:55 PM
Nevermind, I found an answer.
Regular join does not take into account update of backed table.
It runs fine, but when the operator is finished, it does not rescan for updates.