KModesPredict Example - Teradata Vantage

Input

• input: kmodes_input, found in KModes Example 1: InitialSeedTable
• model: kmodes_clusters, output by KModes Example 1: InitialSeedTable

SQL Call

SELECT * FROM KModesPredict (
  ON kmodes_input AS "input" PARTITION BY ANY
  ON kmodes_clusters AS model DIMENSION ORDER BY distance_metric
  USING
  Accumulate ('model')
) AS dt ORDER BY cluster_id, model;

Output

Each input row is assigned one of the three clusters.