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
ft:locale
en-US
ft:lastEdition
2025-04-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.