Hi, Julian,
Thanks for the reply. I want to make sure that I understand your
explanation on windows in JOIN more explicitly.
For the following case:
Q.1) SELECT STREAM id, cost, value, Shipments.rowtime as shiptime FROM
Orders OVER (ORDER BY rowtime RANGE '3' min PROCEDING)
JOIN Shipments
Hi, Julian,
I am writing down some detailed examples of join and need your further help
in understanding the semantic meaning of the following example:
SELECT id, value, cost FROM Orders OVER (ROWS 3 PRECEDING) JOIN Shipments
OVER (ROWS 3 PROCEDING) ON Orders.id = Shipments.id
In this example,