1.1 - 8.10 - ExponentialMovAvg Input - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

Input Table Schema

The table can have additional columns, but the function ignores them.

Column Data Type Description
partition_column Any Column by which input data is partitioned. This column must contain all rows that contain entity to average. For example, if function is to return exponential moving average of a particular stock share price, all transactions of that stock must be in one partition.
order_column TIME, TIMESTAMP, INTEGER, SMALLINT, or BIGINT Column by which input table is ordered.
target_column INTEGER, SMALLINT, BIGINT, or DOUBLE PRECISION [Column appears once for each specified target_column.] Values to average.