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'}) ]
[ EmbeddingSize(integer_value) ]
[ DistanceMeasure({'Euclidean' | 'Cosine'}) ]
[ NormalizedVectors({'true' | 't' | 'yes' | 'y' | '1' | 'false' | 'f' | 'no' | 'n' | '0'}) ]
[ UseSIMD({'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