In this example, the signal is three-dimensional (3D).
Input
The InputTable has one time sequence of 3D signals of length 8, represented by this 2x2x2 matrix in the value1 column: ( ( (1, 2) (3, 4) ) ( (5, 6) (7, 8) ) )
| id1 | timestep | value1 |
|---|---|---|
| 1 | 1 | 1 |
| 1 | 2 | 2 |
| 1 | 3 | 3 |
| 1 | 4 | 4 |
| 1 | 5 | 5 |
| 1 | 6 | 6 |
| 1 | 7 | 7 |
| 1 | 8 | 8 |
SQL Call
CREATE MULTISET TABLE fft_output_3 AS (
SELECT * FROM FFT (
ON fft_input3 AS InputTable PARTITION BY id1 ORDER BY timestep
USING
TargetColumns ('value1')
Dimensions (3)
) AS dt
) WITH DATA;
Output
SELECT * FROM fft_output_3;
id_0 timestep real_value1 imag_value1
---- -------- ----------- -----------
1 3 -8.0 0.0
1 5 -16.0 0.0
1 6 0.0 0.0
1 7 0.0 0.0
1 8 0.0 0.0
1 4 0.0 0.0
1 2 -4.0 0.0
1 1 36.0 0.0
Download a zip file of all examples and a SQL script file that creates their input tables.