Aggregate UDFs - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantageā„¢

When an SQL statement specifies an aggregate UDF, Vantage invokes the Java method that implements the aggregate UDF once for each item in the group, passing the detail values of a group through the input arguments.

In addition to the parameters that map to the input arguments of the UDF when it is specified in an SQL statement, the method signature for an aggregate UDF includes two special parameters for arguments that Vantage passes in. One of the arguments that Vantage passes in tells the method which aggregation phase it was invoked in so that the method knows how to combine the data passed in. Another argument provides a context for the method to retain intermediate results that it accumulates during the aggregation phases.