TD_CONVOLVE Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
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 generation of the result series is as follows:
  • When both input sources have the same content type, univariate or multivariate:
    • For univariate, the first input source is convolved with the second input source to form a univariate result series.
    • 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 series.
  • When the first input source is a univariate series and the second input is a multivariate series:
    • The first input source is convolved individually with each of the fields in the second input to form a multivariate result series.
  • When the first input is a multivariate series and the second input is a univariate series:
    • Each field of the first input source is individually convolved with the univariate second input source to form a result field, such that the final product is a multivariate result series.
The payload content associated with the result series is determined as follows:
  • If both input time series are REAL or COMPLEX, then the new time series is COMPLEX.
  • If either input time series is MULTIVAR_REAL or MULTIVAR_COMPLEX, then the new time series is MULTIVAR_COMPLEX.

This function only produces a primary result set, ARTPRIMARY. No other auxiliary layers are returned by this function.

Display the RETURNS TABLE with a SELECT statement.

RETURNS TABLE Schema

In the following table, dominant-payload-name depends on the input source payload content type. If the input source payload content type is COMPLEX or MULTIVAR_COMPLEX, then this is the payload name associated the complex components in rectangular form. If the input source payload content is AMPL_PHASE or MULTIVAR_AMPL_PHASE, then this is the payload name associated with the complex component in polar form.

Name Data Type Description
derived-series-identifier Varies The resultant series identifier inherited from the SERIES_ID.
ROW_I INTEGER Row identifier of the series.
REAL_dominant-payload-name FLOAT Real component of the complex number.
IMAGINARY_dominant-payload-name FLOAT Imaginary component of the complex number.