7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
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.