TD_DFFT Output - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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).