TD_DFFT 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

The result series is a series with the same content type as the original SERIES_SPEC. A univariate input returns a univariate output, and a multivariate input returns a multivariate output.

RETURNS TABLE Schema

This function returns a primary result set (ARTPRIMARY). Depending on the OUTPUT_FMT used in the function, the Fourier Coefficients returned are complex numbers in either rectangular or polar forms.

In the following table, dominant_payload_name depends on the input source payload content type. If the input source payload content type is COMPLEX or MULTIVAR_COMPLEX, then the payload name is associated with the complex components in rectangular form. If the input source payload content is AMPL_PHASE or MULTIVAR_AMPL_PHASE, then the payload name is associated with the complex component in polar form.

Display the RETURNS TABLE with a SELECT statement.

Name Data Type Description
derived-series-identifier Varies The resultant series identifier inherited from the SERIES_ID.
ROW_I INTEGER Row identifier of the ordered result sets.
AMPLITUDE_ dominant_payload_name FLOAT Fourier amplitude coefficient corresponding to ROW_I index.
Only output when using the following output or content:
  • OUTPUT_FMT(CONTENT(AMPL_PHASE_DEGREES)
  • CONTENT(AMPL_PHASE_RADIANS)
  • CONTENT(AMPL_PHASE)
  • CONTENT(MULTIVAR_AMPL_PHASE_DEGREES)
  • CONTENT(MULTIVAR_AMPL_PHASE_RADIANS)
  • CONTENT(MULTIVAR_AMPL_PHASE)
PHASE_dominant_payload_name FLOAT

Fourier phase coefficient corresponding to ROW_I index.

Only output when using the following output or content:
  • OUTPUT_FMT(CONTENT(AMPL_PHASE_DEGREES)
  • CONTENT(AMPL_PHASE_RADIANS)
  • CONTENT(AMPL_PHASE)
  • CONTENT(MULTIVAR_AMPL_PHASE_DEGREES)
  • CONTENT(MULTIVAR_AMPL_PHASE_RADIANS)
  • CONTENT(MULTIVAR_AMPL_PHASE)
REAL_dominant_payload_name FLOAT

Fourier real coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX).

IMAGINARY_dominant_payload_name FLOAT

Fourier imaginary coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX).