1.1 - 8.10 - KNN Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
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.