SimpleMovAvg Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input Table Schema

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

Column Data Type Description
partition_column INTEGER, BIGINT, NUMERIC, or VARCHAR 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 INTEGER, BIGINT, TIME, or TIMESTAMP Column by which input table is ordered.
target_column SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION [Column appears once for each specified target_column.] Values to average.