1.1 - 8.10 - KNN Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

By default, the KNN function outputs a table to the screen. If you specify an output table name, the function outputs a message to the screen and creates an output table with the specified name.

Output Message Schema

Column Data Type Description
message VARCHAR Reports that final result is stored in table specified in OutputTable syntax element.

OutputTable Schema

Column Data Type Description
test_id_column Same as in test table Unique test data object identifier.
category VARCHAR Category from TrainingData response_column to which function mapped test data object.
prob DOUBLE PRECISION Probability that observation belongs to predicted category, which is based on weighted voting (categories) of k nearest neighbors.
accumulate_column Same as in input table Column copied from TrainingTable.