Top
Interstage Big DataComplex Event Processing Server V1.1.0 Developer's Reference
FUJITSU Software

1.2.4 GROUP BY Clause

The GROUP BY clause splits the output of a complex event processing statement into groups. The output can be split in accordance with event properties or in accordance with expression calculation results.

Syntax:

group by groupingExpression [,groupingExpression] [, ...]

In a groupingExpression, specify the property, or an expression that includes properties, that is the basis for splitting into groups. The groupingExpression cannot include the aggregate function. Event properties used by the aggregate function within a SELECT clause can also not be included in a groupingExpression.