TD_DFFTCONV 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
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

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 rectangular or polar forms.

In the following table, 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 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.
AMPLITUDE_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_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_payload-name FLOAT

Fourier real coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX)).

IMAGINARY_payload-name FLOAT

Fourier imaginary coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX)).