> Does it matter which table is a steam? if the "STREAM" query runs > continuously, the output (table) from the query is a stream, and likely > this stream gives you delta updates periodically.
In my understanding, it does. If both tables are a stream, you get a change stream from both. You're joining two change streams. So if there's a change in product name, a change event will occur and the change event should be joined to all previous (and future) change events on order_items matching that product. Similarly if there's a new order_item, it should be joined with all previous change events on the matching product. The paper doesn't discuss queries with joins at all. But it's unclear to me how it's supposed to work. Maybe if you could give an example for the above query and what happens when there's a change in order_item and when in product. Viliam -- This message contains confidential information and is intended only for the individuals named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version. -Hazelcast
