IFFT 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

SQL Call

CREATE MULTISET TABLE ifft_output_table1 AS (
  SELECT * FROM IFFT (
    ON fft_output1 AS inputtable PARTITION BY id_0 ORDER BY timestep
    USING
      ValueColumns ('real_value1', 'imag_value1')
      NumDimensions (1)
      IsSignalRealValued ('false')
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM ifft_output_table1 ORDER BY id_0, timestep;
ifft_output_table1
id_0 timestep real_real_value1 imag_real_value1
1 1 1 0
2 1 2 0
2 2 3 0
3 1 4 0
3 2 5 5.72118872610983e-18
3 3 6 0
3 4 7 -5.72118872610983e-18