TD_KNN Neighbors Example | kNN | Teradata Vantage - Example: Using TD_KNN with Neighbors - Teradata Vantage

TD_KNN Input training table and test table

The following example displays the nearest neighbors for each data point:

Example: TD_KNN SQL Call for Neighbors

SELECT * FROM TD_KNN(
ON housing_train AS TestTable PARTITION BY ANY
ON housing_train AS TrainingTable DIMENSION
USING     
k(5)
InputColumns('[1:5]') 
IDColumn('sn')     
ModelType('Neighbors')  
) AS dt;   

TD_KNN Output Table for Neighbors