FFT Example 1: 1D Signal - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

In this example, the signals are one-dimensional (1D).

Input

InputTable: fft_input
id1 timestep value1
1 1 1
2 1 2
2 2 3
3 1 4
3 2 5
3 3 6
3 4 7

SQL Call

CREATE MULTISET TABLE fft_output1 AS (
  SELECT * FROM FFT (
    ON fft_input AS inputtable PARTITION BY id1 ORDER BY timestep
    USING
    ValueColumns ('value1')
  ) AS dt
) WITH DATA;

Output

The first row represents the input sequence of length one. Its FFT is the single value in the sequence (1).

The second and third rows represent the input sequence of length two. Its FFT has only real values.

The final four rows represent the input sequence of length four. Its FFT has conjugal symmetry.

fft_output_1
id1_0 timestep real_value1 imag_value1
1 1 1 0
2 1 5 0
2 2 -1 0
3 1 22 0
3 2 -2 2
3 3 -2 0
3 4 -2 -2