Compare streams with windows and observe the differences between local and output windows.
The example creates a schema named TradeSchema, then an input window named TradeWindow that references TradeSchema. The File CSV Input adapter is attached to TradeWindow.
The example then creates a series of local and output streams and windows. The output stream and window are public; they communicate with external data sources using adapters. Local streams and windows are viewed only internally and cannot have adapters attached to them.
CREATE LOCAL STREAM LocalStream AS SELECT * FROM TradeWindow ; CREATE OUTPUT STREAM OutputStream AS SELECT * FROM TradeWindow ; CREATE LOCAL WINDOW LocalWindow PRIMARY KEY DEDUCED AS SELECT * FROM TradeWindow ; CREATE OUTPUT WINDOW OutputWindow PRIMARY KEY DEDUCED AS SELECT * FROM TradeWindow ;