7.00.02 - KMeansPlot Syntax - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Version 1.1
SELECT * FROM KMeansPlot (
  ON { table | view | query } PARTITION BY ANY
  ON { table | view | query } DIMENSION
  [ CentroidsTable ('centroids_table') ]
  [ PrintDistance ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
 );
When calling KMeansPlot on a view, you must provide aliases (a requirement of multiple-input SQL-MapReduce). For example:
SELECT *
  FROM KMeansPlot (
  ON pa_prdwk.seg_data_v AS input_data PARTITION BY ANY
  ON pa_prdwk.seg_data_output AS segmentation_data_output DIMENSION
  CentroidsTable ('segmentation_data_output')
);