The aggregate functions are either fully parallel (FP) aggregates or single-threaded (ST) aggregates, depending on how they are evaluated. FP aggregates do not require the entire set of data to be present in order to compute the result. Rather, the result is computed by evaluating the aggregation on small subsets of the data in parallel and then computing a final aggregation of the intermediate results. ST aggregates require the entire set of data to be present in order to compute the result.
You can use the following aggregate functions on time series data in PTI tables by using the GROUP BY TIME clause and in non-PTI tables by using the GROUP BY TIME clause with the USING TIMECODE option. For information on these functions, see Teradata Vantage™ Time Series Tables and Operations, B035-1208.
- AVERAGE
- COUNT
- KURTOSIS
- MAXIMUM
- MINIMUM
- RANK (ANSI)
- SKEW
- STANDARD DEVIATION OF A POPULATION (STDDEV_POP)
- STANDARD DEVIATION OF A SAMPLE (STDDEV_SAMP)
- SUM
- VARIANCE OF A POPULATION (VAR_POP)
- VARIANCE OF A SAMPLE (VAR_SAMP)