1.0 - 8.00 - IFFT Example 3: 3D Signal - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

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