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
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
wne1515028094879.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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)