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
Language
English (United States)
Last Update
2023-12-08
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.