16.20 - MovingAverage Output - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

Output Table Schema

Column Data Type Description
partition_column Same as in input table Column by which input data is partitioned.
order_column Same as in input table Column by which input table is ordered.
target_column Same as in input table Column copied from input table.
target_column_typemavg DOUBLE PRECISION Moving average of target_column values when row was added to data set, where type is value of MAvgType syntax element.