Skip to main content

FIRST

This is a window that holds only the first set of unique events according to the unique key parameter. When a new event arrives with a key that is already in the window, that event is not processed by the window.

Syntax​

    WINDOW UNIQUE:FIRST(<INT|LONG|FLOAT|BOOL|DOUBLE|STRING> unique.key)
    WINDOW UNIQUE:FIRST(<INT|LONG|FLOAT|BOOL|DOUBLE|STRING> unique.key, <INT|LONG|FLOAT|BOOL|DOUBLE|STRING> ...)

Query Parameters​

NameDescriptionDefault ValuePossible Data TypesOptionalDynamic
unique.keyThe attribute that should be checked for uniqueness. If there is more than one parameter to check for uniqueness, it can be specified as an array separated by commas.INT LONG FLOAT BOOL DOUBLE STRINGNoYes

Example 1​

    CREATE STREAM LoginEvents (timeStamp long, ip string);

    INSERT INTO UniqueIps 
    FROM LoginEvents WINDOW UNIQUE:FIRST(ip);

This returns the first set of unique items that arrive from the LoginEvents stream, and returns them to the UniqueIps stream. The unique events are only those with a unique value for the ip attribute.