7.00.02 - 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
zuk1466006200888

The following table describes the required columns of the input table. The input table can have additional columns, but the function ignores them.

CMAVG Input Table Schema
Column Name Data Type Description
partition_column INTEGER, BIGINT, NUMERIC, or VARCHAR Column on which the input data is partitioned. This column must contain all rows that contain the entity to be averaged. For example, if the function is to return the cumulative moving average of a particular stock share price, all transactions of that stock must be in one partition.
cma_column INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION Column whose values are to be averaged.
order_by_column INTEGER, BIGINT, TIMESTAMP, TIME Column by which the input table is ordered.