KEEP Clause

The example creates an input window named TradesWindow and an output window named KeepCountWindow. KeepCountWindow has a KEEP clause that keeps 10 rows at a time in the window.

CREATE  OUTPUT  WINDOW KeepCountWindow
	SCHEMA ( Symbol STRING, Ts bigdatetime )
	PRIMARY KEY (Ts) 
	KEEP 10 ROWS 
AS 
	SELECT  TradesWindow.Symbol AS Symbol, TradesWindow.Ts AS Ts
	FROM TradesWindow 
;

The example attaches a File CSV Input adapter named InConn to TradesWindow, and a File CSV Output adapter named OutConn to KeepCountWindow.