TD_KMeans (
ON {table | view | (query)} AS InputTable
[ ON {table | view | (query)} AS InitialCentroidsTable DIMENSION ]
[ OUT [ PERMANENT | VOLATILE ] TABLE ModelTable(model_output_table_name) ]
USING
IdColumn('id_column')
TargetColumns({'target_column'|'target_column_range'}[,...])
[ InitialCentroidsMethod({'random'|'kmeans++'}) ]
[ NumClusters(number_of_clusters) ]
[ Seed(seed_value) ]
[ StopThreshold(threshold_value) ]
[ MaxIterNum(number_of_iterations) ]
[ NumInit(num_init) ]
[ OutputClusterAssignment({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
)
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement