TD_CONVOLVE 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 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.