Skip to main content

or (Aggregate Function)

eturns the results of OR operation for all the events.

Syntax

    <BOOL> or(<BOOL> arg)

QUERY PARAMETERS

NameDescriptionDefault ValuePossible Data TypesOptionalDynamic
argThe value that needs to be OR operation.BOOLNoYes

Example 1

    insert into alertStream
select or(isFraud) as isFraudTransaction
from cscStream WINDOW TUMBLING_LENGTH(10);

This returns the result for OR operation of isFraud values as a boolean value for event chunk expiration by window length batch.