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 consists of an arbitrary number of grouping columns and a single value column that contains the data set to be matched to the specified distributions. The syntax shown includes clauses that create two tables from the input table. One table ranks the data and the other table counts the number of points in each group.

For continuous distributions, if your input table already includes a rank column, replace the clause ON (SELECT RANK()... with the clause ON SELECT * FROM input_table .

Distribution Matching Input Table Schema
Column Name Data Type Description
column Any Column used to partition or identify the values. The table can have several such columns.
value_column INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION Contains the values of the sample data set.