KEEP ALL Clause

The example creates a schema named TradeSchema. The example creates an input window named TradeWindow that references TradeSchema, to which it attaches a File CSV Input adapter.

The example creates an output window named KeepAllWindow, which uses the KEEP ALL clause to retain all data from TradeWindow and group the results by Symbol.

CREATE OUTPUT WINDOW KeepAllWindow 
		SCHEMA (Symbol string, RowCount INTEGER)
  PRIMARY KEY DEDUCED KEEP all 
AS 
	SELECT TradeWindow.Symbol as Symbol, count(TradeWindow.Symbol) as RowCount
	FROM TradeWindow 
		group by TradeWindow.Symbol
;