Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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.