KMeans Syntax - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Version 1.6
SELECT * FROM KMeans (
  ON (SELECT 1)
  PARTITION BY 1
  [ Domain ('host:port') ]
  [ Database ('db_name') ]
  [ UserID ('user_id') ]
  [ Password ('password') ]
  [ SSLSettings ('SSLsettings') ]
  [ SSLTrustStorePassword ('SSLtruststorepassword') ]
  InputTable ('input_table')
  OutputTable ('output_table')
  [ ClusteredOutput ('clustered_output_table') ]
  [ UnpackColumns
    ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ InitialSeeds (starting_clusters) ]
  { NumClusters (number_of_means) [ Seed (seed) ] |
    CentroidsTable ('centroids_table') }
  [ Threshold ('threshold') ]
  [ MaxIterNum ('max_iterations') ]
);
You must specify only one of the arguments NumClusters, InitialSeeds, and CentroidsTable. If you specify more than one, the function gives top priority to InitialSeeds, then to NumClusters, and then to CentroidsTable.
For information about the authentication arguments, see the following topics: