Input - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

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.