AS Clause
Introduces a CCL query to a derived element.
AUTOGENERATE Clause
Specify one or more columns that will contain an automatically generated sequence number in records sent to an input stream or input window.
CASE Clause
Conditional processing evaluates set conditions to determine a result.
FROM Clause
Identifies the stream(s) or window(s) or both that will provide the input to the query.
GROUP BY Clause
Specifies the expressions on which to perform an aggregation operation.
GROUP FILTER Clause
Filters data in a group before the aggregation operation is performed.
GROUP ORDER BY Clause
Orders the data in a group before applying the GROUP FILTER clause and aggregating the data.
HAVING Clause
Filters rows that have been grouped by a grouping clause.
IN Clause
Used in the LOAD MODULE statement to bind inputs in the module to inputs in the parent scope.
KEEP Clause
Specify either a maximum number of records to retain in a window, or a length of time to retain them.
MATCHING Clause
This is used within a query for pattern matching, which allows detection of patterns of events across one or more sources.