TD_LINESPEC 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
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
lifecycle
latest

The output value type depends on the PAYLOAD CONTENT value of the input time_series. A univariate input (REAL or COMPLEX) produces a univariate output (REAL). A multivariate input (MULTIVAR_REAL or MULTIVAR_COMPLEX) produces a multivariate output (MULTIVAR_REAL).

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

RETURNS TABLE Schema

The primary layer result series is returned by using a SELECT statement, and consists of the following:

Name Data Type Description
derived-series-identifier Varies 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 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.