KMeansPlot Syntax - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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')
);