TD_CONVOLVE Syntax Elements | Teradata Vantage - TD_CONVOLVE Syntax Elements - 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
lifecycle
latest
SERIES_SPEC (time_series)
The time series to be filtered. Input source contains univariate series instances or multivariate series instances.
SERIES_SPEC (filter_series)
The series that is the filter. Input source contains univariate series instances or multivariate series instances.
The series in the two inputs are not required to have the same number of entries.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
ALGORITHM String [Optional] Options are CONV_SUMMATION or CONV_DFFT. By default, the function selects the best option based on the number of entries present in the two inputs, and their types ( REAL, COMPLEX, and so on.) CONV_SUMMATION only supports:
  • REAL,REAL
  • REAL, MULTIVAR_REAL
  • MULTIVAR_REAL,REAL
  • MULTIVAR_REAL,MULTIVAR_REAL

If the CONV_SUMMATION option is passed in when the first input is greater than 64 entries or the second input is greater than 63 entries, then CONV_DFFT is used instead.

This parameter is mostly used for testing.

INPUT_FMT
Mandatory specification. The INPUT_MODE parameter has the following options:
  • ONE2ONE: Both the primary and secondary series specifications include a WHERE filter clause identifying one series instance to serve as the input series for the mathematical operation.
  • MANY2ONE: The primary input SERIES_SPEC references MANY series instances. The secondary input SERIES_SPEC includes a WHERE filter clause identifying a single series instance. When applying the mathematical operation, the secondary input single series is reused as many times as necessary to match the number of series instances found in the primary input.
  • MATCH: A series instance residing in the primary input whose SERIES_ID matches the SERIES_ID of a series instance in the secondary input, has the mathematical operation applied to produce a result series. For those instances in one input who have no corresponding SERIES_ID partner in the other input, the series is skipped over.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.