Syntax | Fast K-Means Cluster Scoring | Vantage Analytics Library - Syntax - Vantage Analytics Library

CALL td_analyze (
  'kmeansscore',
  'required_parameter_list [ optional_parameter; [...] ]'
);

required_parameter_list

database = input_database_name;
tablename = input_table_name;
outputdatabase = output_database_name;
outputtablename = output_table_name;
modeldatabase = model_database_name;
modeltablename = model_table_name;

optional_parameter

{ clustername = cluster_name |
  fallback = { true | false } |
  index = index_column [,...] |
  operatordatabase = operator_database_name |
  overwrite = { true | false } |
  retain = retain_column [,...] |
  samplescoresize = sample_score_size
}

Syntax Elements

database

The database containing the input table.

tablename

The name of the table containing the data to score.

outputdatabase

The database containing the resulting scored output table.

outputtablename

The name of the scored output table to build.

modeldatabase

The database containing the table that represents the cluster model to score.

modeltablename

The name of the input table containing the cluster model to score.

clustername

[Optional] The name of the column containing the cluster identifier. This name cannot be the name of an index column or column being scored.

Default: clusterid

fallback

[Optional] Whether to give the scored output table the FALLBACK attribute.

Default: false

index

[Optional] The columns for the primary index of the score output table. These columns must form a unique key for the score output table. Otherwise, a given observation has more than one score.

Default: Primary index columns of the input table

operatordatabase

[Optional] The database where the table operators that td_analyze calls reside.

Default behavior: The function searches the standard search path for table operators.

overwrite

[Optional] Whether to drop the output tables before creating new ones.

Default: true

retain

[Optional] One or more input table columns to copy to the output table.

samplescoresize

[Optional] The number of output table rows to display as a result set.

Default: 0