Aggregates Returning More than One Result | Teradata Vantage - 17.00 - Aggregates That Return More Than One Result - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K
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.