17.05 - MovingAverage Output - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

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.