TD_IDFFT2 Syntax Elements - 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
MATRIX_SPEC (TD_DFFT2_RETURNS_TABLE)
A matrix containing Fourier coefficients that is passed in to the TD_IDFFT2.

See Matrix Specifications and TD_DFFT2 Output.

ART_SPEC
An ART that was produced by the TD_DFFT2 function. The ART_SPEC is required to contain the ART_SPEC parameter TABLE_NAME,. The parameter PAYLOAD with FIELDS and CONTENT is optional. Do not use any other ART_SPEC parameters.

See ART_SPEC Syntax Elements

FUNC_PARAMS
Name Data Type Description
HUMAN_READABLE INTEGER

[Dependencies: This is used when the input rows are in the raw, non-human-readable, format. The parameter is optional.]

Indicator that the DFFT2 coefficient rows are in human-readable or plottable form, or the output is in the raw form. Human- readable output is symmetric around 0, such as -3, -2, -1, 0, 1, 2, 3. Raw output is sequential, starting at zero, such as 0, 1, 2, 3.

A value of 1 means true and the output is in human readable form. A value of 0 means false and the output is in raw form. The default is 1.

ALGORITHM Enum, String

[Optional] The user-defined algorithm that bypasses the internal IDFFT2 planner, and influences the IDFFT2 algorithm associated with the primary IDFFT2 calculation.

Options are COOLEY_TUKEY, or SINGLETON. The default when this parameter is not present is that the internal IDFFT2 planner selects the most efficient algorithm for the operation.

INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT

A complex number that can be in rectangular (real, imaginary) or polar (amplitude, phase) form. The output options for univariate series are the following:

  • COMPLEX
  • AMPL_PHASE_DEGREES
  • AMPL_PHASE_RADIANS

The default is COMPLEX.

The OUTPUT_FMT CONTENT output for multivariate series are the following:
  • MULTIVAR_COMPLEX
  • MULTIVAR_AMPL_PHASE_DEGREES
  • MULTIVAR_AMPL_PHASE_RADIANS
  • MULTIVAR_AMPL_PHASE

The default is MULTIVAR_COMPLEX.