7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
Last Update

The input table must have the rows described in the following table. The table can have additional rows, but the function ignores them.

EMAVG Input Table Schema
Column Name Data Type Description
partition_column Any Column by which the input table is partitioned. Each partition must include all rows of an entity. For example, to compute the exponential moving average of a particular stock share price, all transactions of that stock must be in the same partition.
order_column TIME, TIMESTAMP, INTEGER, SMALLINT, or BIGINT Column by which to order the input.
input_column INTEGER, SMALLINT, BIGINT, or DOUBLE PRECISION Input column for which the exponential moving average is to be computed.