SERIES_SPEC Element | Teradata Vantage - Series Specifications - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

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.