Use the UNION clause to merge data from two streams or windows and produce a derived element (stream, window, or delta stream).
- Create a new window:
CREATE WINDOW name
You can also create a new stream or delta stream.
- Specify the primary key:
- Specify the first derived element in the union:
SELECT * FROM StreamWindow1
- Add the UNION clause:
- Specify the second derived element in the union:
SELECT * FROM StreamWindow2