KNN Example - Teradata Vantage

Input

The TrainingData table has as dimensions five attributes of personal computers—price, speed, hard disk size, RAM, and screen size. The table has 5008 rows, categorized into eight price categories.

The TestData table has more than 1000 rows.

SQL Call

Output

 message                                                                                 
 --------------------------------------------------------------------------------------- 
 Successful!                                                                            
 The final result is successfully stored in the table specified in OutputTable argument.

SELECT * FROM knn_output_1 ORDER BY 1;

 id   computer_category prob               
 ---- ----------------- ------------------ 
   10 mega                             1.0
   11 super                            1.0
   15 mega              0.7515842570160136
   29 hyper                            1.0
   30 hyper             0.9868332664440534
   38 uber                             1.0
   45 uber              0.8872700371272975
   46 mega              0.8007186591491793
   48 special           0.6572238590173166
   51 mega                             1.0
   52 mega                             1.0
   59 hyper                            1.0
  ...  ...                             ...

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.