TD_POWERSPEC Output - 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

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.