IFFT Example 2: 2D 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 (2D).

Input

SQL Call

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

Output

This query returns the following table:

SELECT * FROM ifft_output_table2 ORDER BY id_0, timestep;
ifft_output_table2
id_0 timestep real_real_value1 imag_real_value1
1 1 1 0
1 2 2 0
1 3 3 0
1 4 4 0