The result set can be produced with Fourier Coefficients being realized in the form of complex numbers or in polar form with amplitude and phase number pairs. This affects the composition of the produced output columns. For complex numbers use the following output formats:
- CONTENT(COMPLEX)
- CONTENT(MULTIVAR_COMPLEX)
For polar form use the following:
- CONTENT(AMPL_PHASE_RADIANS)
- CONTENT(AMPL_PHASE_DEGREES)
- CONTENT(AMPL_PHASE)
- CONTENT(MULTIVAR_AMPL_PHASE_RADIANS)
- CONTENT(AMPL_PHASE_RADIANS
- CONTENT(MULTIVAR_AMPL_PHASE)
RETURNS TABLE Schema
In the following table, dominant_payload_name depends on its content.
Depending on the OUTPUT_FMT used in the function, the Fourier Coefficients returned are complex numbers in either rectangular or polar forms.
| Name | Data Type | Description |
|---|---|---|
| derived-series-identifier | VARCHAR | The resultant series identifier inherited from the SERIES_ID. |
| ROW_I | INTEGER | Row identifier of the ordered result sets. |
| COLUMN_I | INTEGER | Column identifier of the ordered result set. |
| AMPLITUDE_ dominant_payload_name | FLOAT | Fourier amplitude coefficient corresponding to ROW_I index. Only output when using polar form. |
| PHASE_dominant_payload_name | FLOAT | Fourier phase coefficient corresponding to ROW_I index. Only output when using polar form. |
| REAL_dominant_payload_name | FLOAT | Fourier real coefficient corresponding to ROW_I index. Only output when using complex form. |
| IMAGINARY_dominant_payload_name | FLOAT | Fourier imaginary coefficient corresponding to ROW_I index. Only output when using complex form. |