Skip to main content

and (Aggregate Function)

Returns the results of AND operation for all the events.


    <BOOL> and(<BOOL> arg)

Query Parameters

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

Example 1

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

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