16.20 - Parallel and Single Threaded Aggregate Functions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)
Last Update
2019-05-02

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)