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