The function returns two result sets:
- Progress report that shows how the algorithm converged and what made it stop processing.
- Cluster means and variances.
Progress Report
Column |
Data Type |
Description |
ctime |
TIMESTAMP |
Timestamp. |
v |
VARCHAR |
Progress message. |
Cluster Means and Variances
Rows associated with positive cluster IDs contain the average values of each of the clustered columns and the count for each cluster ID.
Rows associated with negative cluster IDs contain the variance of each clustered column for each cluster ID.
Column |
Data Type |
Description |
clusterid |
INTEGER |
Cluster identifier. |
cnt |
INTEGER |
Count of items in cluster. |
avg_cc_bal |
DOUBLE PRECISION |
Input column. |
avg_ck_bal |
DOUBLE PRECISION |
Input column. |
avg_sv_bal |
DOUBLE PRECISION |
Input column. |
Example
Progress Reportctime |
v |
12/4/2020 9:57:07 AM |
Starting Procedure |
12/4/2020 9:57:07 AM |
Data randomly assigned to clusters initially |
12/4/2020 9:57:07 AM |
Starting K-means loop 1 |
12/4/2020 9:57:07 AM |
Completed K-means loop 1 |
12/4/2020 9:57:08 AM |
Comparison complete, cluster aggregate difference is 8.44511468105135E 002 |
12/4/2020 9:57:08 AM |
Starting K-means loop 2 |
12/4/2020 9:57:08 AM |
Completed K-means loop 2 |
12/4/2020 9:57:08 AM |
Comparison complete, cluster aggregate difference is 6.28369025740172E 002 |
12/4/2020 9:57:08 AM |
Starting K-means loop 3 |
12/4/2020 9:57:08 AM |
Completed K-means loop 3 |
12/4/2020 9:57:08 AM |
Comparison complete, cluster aggregate difference is 6.15229501574827E 002 |
12/4/2020 9:57:08 AM |
Kmeans reached maximum iterations (3) so terminating procedure |
12/4/2020 9:57:09 AM |
Procedure Complete |
Cluster Means and Variancesclusterid |
cnt |
avg_cc_bal |
avg_ck_bal |
avg_sv_bal |
-3 |
512 |
231857.172417 |
301876.198169 |
339777.941176 |
-2 |
25 |
14851425.760280 |
65128867.597238 |
42746526.179346 |
-1 |
210 |
3424898.292542 |
3992928.509731 |
3409787.968982 |
1 |
210 |
-1371.9022857 |
1593.53185714 |
952.924238 |
2 |
25 |
-2311.104230 |
6918.833076 |
3453.093846 |
3 |
512 |
-281.768082 |
312.603170 |
309.22684 |