SERIES_SPEC Element | Teradata Vantage - Series Specifications - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

A series is a one-dimensional array. Series are the basic input and output units of UAF functions. A series is identified by its SERIES_ID fields, and indexed by its ROW_AXIS field.

Series are passed to and returned from UAF functions in groupings known as wavelets. Wavelets are collections of rows, grouped by one or more series identifier fields, and ordered or indexed on the ROW_AXIS field.

A SERIES_SPEC can be used to reference any Teradata accessible table or view, a derived-table, or a particular layer residing within an ART. When used to reference a layer of an ART, the LAYER parameter must be included, except the case in which the layer is ARTPRIMARY, in which case the LAYER parameter can be omitted.

The identifier and PAYLOAD fields can be renamed using AS clauses. However, this may not affect the output field names for the PAYLOAD fields because the PAYLOAD fields are input fields. The output payload field name is only affected if the function uses the input payload field name as the output field name or as part of the output field name.