TD_KNN Classification Example | kNN | Teradata Vantage - Example: Using TD_KNN with Classification - Teradata VantageCloud Lake

TD_KNN Input Table for Classification Example

The following example predicts whether the person has diabetes:

TD_KNN SQL Call for Classification

SELECT * FROM TD_KNN (
    ON diabetes AS TestTable PARTITION BY ANY
    ON diabetes AS TrainingTable DIMENSION
    USING
        K(3)
        ResponseColumn('outcome')
        InputColumns('[1:8]')
        IDColumn('id')
        ModelType('Classification')
        OutputProb('true')
        EmitNeighbors('true')
        Responses('0', '1')
) AS dt;

TD_KNN Output for Classification