7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The KNN function has two input tables, a training table and a test table.

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

KNN Training Table Schema
Column Name Data Type Description
id_column Any Contains unique row identifiers.
df_column INTEGER, BIGINT, SMALLINT, or NUMERIC Column that the function uses to compute the distance between a test object and the training objects. The testing table must have a column with the same name and data type.
response_column VARCHAR Column that contains the class label or classification of the classified data objects.

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

KNN Test Table Schema
Column Name Data Type Description
df_column INTEGER, BIGINT, SMALLINT, or NUMERIC Column that the function uses to compute the distance between a test object and the training objects. The training table must have a column with the same name and data type.
test_id_column Any Contains unique test data object identifiers.