Local Windows and Output Windows

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 ;