1.0 - 8.00 - IFFT Example 1: 1D 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 (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