Explicitly deleted specified rows from a named window.
on_clause |
A row arriving on the stream or window specified here triggers the deletion. See ON Clause: Trigger Syntax for more information. |
when_clause |
A condition limiting when the rows are deleted. See WHEN Clause for more information. |
window_name |
The name of the window from which rows are deleted. |
where_clause |
A filter limiting which rows are deleted. See WHERE Clause for more information. |
ON
WHEN
WHERE
In this example the deletion is triggered from named window NW1, whenever a row arrives on StreamA. Every time the trigger occurs, all rows where the value in the ID column of the window is the same as the value in StreamA's ID column are deleted.
ON StreamA DELETE FROM NW1 WHERE StreamA.ID = NW1.ID;