In this article
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this Snap to apply aggregate functions on input data using the Group By support. You can calculate perform This Snap enables you to calculate an aggregate function on a set of values to return a single scalar value.
This Snap does not support
list
andmap
objects referenced in the JSON paths.If the input documents areunsorted and GROUP-BY fields are used, you must use the Sort Snap upstream of the Aggregate Snap to presort the input document stream and set the Sorted stream field Ascending or Descending to prevent the
out-of-memory
error. Learn more about presorting unsorted input documents to be processed by the Aggregate Snap. However, if the total size of input documents is expected to be relatively small compared to the available memory, then Sort Snap is not required upstream.
...
The following are the commonly used SQL Aggregate functions:
...
The following example pipeline demonstrates how to use the Aggregate Snap to count the occurrences of a given product name.
...
Downloads
Info |
---|
|
...