TD_DFFT2CONV 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

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

RETURNS TABLE Schema

Name Data Type Description
derived-series-identifier Varies The resultant series identifier inherited from the SERIES_ID.
ROW_I INTEGER or FLOAT ROW_I is dependent upon the type of discrete series passed to the function. Options are as follows:
  • Passed-in series was a time series: ROW_I is the integral temporal frequency, such as 1HZ, 2HZ, and 3HZ.
  • Passed-in series was a spatial series: ROW_I is the integral spatial frequency, also known as the wave number, such as 1, 2, and 3.
  • Passed-in series was an arbitrary discrete series: ROW_I is an arbitrary integral frequency, also referred to as a wave number.
COLUMN_I INTEGER or FLOAT COLUMN_I depends on the type of discrete series passed to the function. Options are as follows:
  • Passed-in series was a time series: ROW_I is the integral temporal frequency, such as 1HZ, 2HZ, and 3HZ.
  • Passed-in series was a spatial series: ROW_I is the integral spatial frequency, also known as the wave number, such as 1, 2, and 3.
  • Passed-in series was an arbitrary discrete series: COLUMN_I is an arbitrary integral frequency, also known as a wave number.
AMPLITUDE_dominant-payload-name FLOAT Fourier Amplitude coefficient corresponding to ROW_I index.
Only output with the following output settings:
  • 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 with the following output settings:
  • 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)).