TD_POWERSPEC Output - 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
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

The output depends on the input source. A univariate series input produces a univariate series output. A multivariate series input produces a multivariate series output.

The output value type depends on the PAYLOAD CONTENT value of the input series:

Input Type Output Type
REAL or COMPLEX REAL
MULTIVAR_REAL or MULTIVAR_COMPLEX MULTIVAR_REAL

RETURNS TABLE Schema

Name Data Type Description
derived-series-identifier VARCHAR The resultant series identifier inherited from the SERIES_ID.
ROW_I Varies The index associated with the result series. The data type varies based on the chosen FREQ_STYLE.
SPECTRAL_DENSITY_field FLOAT The magnitude based on the line spectrum.
The name-label associated with the field varies depending on the payload-content associated with the input. Input is real (REAL, MULTIVAR_REAL) or complex (COMPLEX, MULTIVAR_COMPLEX).
  • For REAL and MULTIVAR_REAL: The field name-label is the same, and in the same order as the field names associated with the input PAYLOAD-FIELDS.
  • For COMPLEX and MULTIVAR_COMPLEX: Each complex input pair has a result column name of PAYLOADx formed using x is 1,2,3, …, m, and indicates the complex-pairs position in the input list. For example, if input payload-fields list has 4 members, meaning two complex pairs, then the output fields are named SPECTRAL_DENSITY_PAYLOAD1 and SPECTRAL_DENSITY_PAYLOAD2.