<model name>_NUMERIC_STATISTICS table
This table provides statistics about a cluster.
The following table shows the table columns:
| Column name | Data type | Description |
|---|---|---|
| CLUSTERID (primary key column) | INTEGER | Index value of the cluster in the cluster model If CLUSTER_ID is 0, the row applies to all input records. |
| COLUMNNAME (primary key column) | VARCHAR(128) | Name of a numeric input column |
| FROMVALUE (primary key column) | DOUBLE | Lower interval boundary NULL indicates negative infinity. |
| TOVALUE (primary key column) | DOUBLE | Upper interval boundary NULL indicates positive infinity. |
| CLOSURE | VARCHAR(12) | Indicates whether the interval limits are contained Possible values are openClosed, openOpen, closedOpen, and closedClosed. |
| COUNT | BIGINT | Number of occurrences of records in the interval |
| RELFREQUENCY | DOUBLE | Percentage of occurrences of records in the interval The relative frequency is based on all records, including those records with invalid values or NULL values. |
| DEVIATION | DOUBLE | RELFREQUENCY(CLUSTERID) -RELFREQUENCY(0) |
| MEAN | DOUBLE | Mean of all values in the interval |
| VARIANCE | DOUBLE | Variance of all values in the interval |