What could be an implication of using a regular in...
# troubleshooting
s
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?
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.