TD_CONVOLVE2 Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

The generated result matrix is the source matrix with the filter applied to it. It is the result of the two-dimension convolution of the two source matrixes.

The generation of the result matrixes is as follows:
  • When both input sources have the same payload content type, univariate (REAL, COMPLEX) or multivariate (MULTIVAR_REAL, MULTIVAR_COMPLEX):
    • For univariate, the first input source is convolved with the second input source to form a univariate result matrix.
    • For multivariate, each field of the first input source is convolved with the corresponding field in the second input source to yield a multivariate result matrix.
  • When the first input source is a univariate matrix and the second input is a multivariate matrix:
    • The first input source is convolved individually with each of the fields in the second input, to form a multivariate result matrix.
  • When the first input is a multivariate matrix, and the second input is a univariate matrix:
    • If both input matrixes were REAL or COMPLEX, then the new result matrix is COMPLEX.
    • If either input matrixes were MULTIVAR_REAL or MULTIVAR_COMPLEX, then the new result matrix is MULTIVAR_COMPLEX.

The function produces a primary result set, ARTPRIMARY. No other layers are returned by the function.

RETURNS TABLE Schema

Display the RETURNS TABLE with a SELECT statement.

Name Data Type Description
derived-matrix-identifier Varies The resultant series identifier inherited from the SERIES_ID.
ROW_I INTEGER Row identifier of the matrix.
COLUMN_I INTEGER Column identifier of the matrix.
REAL_content-name FLOAT Real component of the complex number.

This field is shown when using complex Fourier coefficients for the filter.

IMAGINARY_content-name FLOAT Imaginary component of the complex number.

This field is shown when using complex Fourier coefficients for the filter.

AMPLITUDE_content-name FLOAT The amplitude of the image.

This field is shown when using amplitude-phase Fourier coefficients for the filter.

PHASE_content-name FLOAT The phase of the image.

This field is shown when using amplitude-phase Fourier coefficients for the filter.