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

Input

SQL Call

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

Output

This query returns the following table:

SELECT * FROM ifft_output_table3 ORDER BY id_0, timestep;
ifft_output_table3
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
1 5 5 0
1 6 6 0
1 7 7 0
1 8 8 0