TD_DFFTCONV 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
ART_SPEC
An ART that was produced by the TD_DFFT function. The ART_SPEC is required to contain the ART_SPEC parameters TABLE_NAME, and PAYLOAD with FIELDS and CONTENT. Do not use any other ART_SPEC parameters.

See ART_SPEC Syntax Elements

SERIES_SPEC
A series containing Fourier coefficients that is passed in to the TD_DFFTCONV.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
CONV String The type of conversion to be performed by the TD_DFFTCONV function. Options are:
  • HR_TO_RAW: Convert from human readable to raw form.
  • RAW_TO_HR: Convert from raw form to human readable form.
HERTZ_SAMPLE_RATE FLOAT [Optional] The sample rate as a floating point constant, in hertz. Only valid with FREQ_STYLE(K_HERTZ). A value of 10000.0 indicates that the sample points were obtained by sampling at a rate of 10,000 hertz.
FREQ_STYLE String

[Optional] The format or values associated with the x-axis of the output.

Choices are:
  • K_INTEGRAL: Integer representation.
  • K_SAMPLE_RATE: Integer normalized to number entries, with ranges from -0.5 to +0.5.
  • K_RADIANS: Radian ranges from -π to +π.
  • K_HERTZ: Frequency in hertz. Must be used in conjunction with HERTZ_SAMPLE_RATE.

The default is K_INTEGRAL.

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.