1.1 - 8.10 - IFFT Example: 2D Signal - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

In this example, the signal is two-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
    TargetColumns ('real_value1', 'imag_value1')
    Dimensions (2)
    RealValuedSignal ('false')
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM ifft_output_table2;
 id_0 timestep real_real_value1 imag_real_value1 
 ---- -------- ---------------- ---------------- 
    1        3              3.0              0.0
    1        4              4.0              0.0
    1        2              2.0              0.0
    1        1              1.0              0.0

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.