7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
WMAVG Input Table Schema
Column Name Data Type Description
partition_column INTEGER, BIGINT, NUMERIC, or VARCHAR Column by which to partition the input. Input data must be partitioned such that each partition contains all values whose weighted moving average is to be calculated.
order_by_column INTEGER, BIGINT, TIME, or TIMESTAMP Column by which to order the input.
target_column INTEGER, BIGINT, or NUMERIC Column whose weighted moving average is to be computed (if specified with the InputColumns argument). The function copies this column to the output table.