TD_DFFT2CONV Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

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