16.20 - Aggregates That Return More Than One Result - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update
Some aggregate functions can create multiple results. For example, when computing the MODE of a set of data, if there is more than one value which is the most frequently observed (a tie of two or more values) each is considered the MODE of the data. The following general rule applies to any aggregates which return more than one result:
  • If a query has only one aggregate function with multiple results, all results are returned. There will be more than one result row for at least one timebucket, where the only value which differs in the result rows is the result of the function which had multiple results.
  • If more than one aggregate function has more than one result, only one result per timebucket is returned, along with a warning that this occurred. In this case, there is no way of predicting which result will be processed first. This type of request can be seen in Example: Multiple Results Found for One or More Time Series Aggregate Functions.