<model name>_NUMERIC_STATISTICS table
This table contains statistical information about the values of active continuous columns with more than 100 values for each node.
The contents and the existence of this table depend on the value of the statistics parameter when the model is built. If you specify statistics=values:n or statistics=all, this table is created. It then contains statistics for active continuous columns with more than n (default 100) distinct values for each node.
The following table shows the table columns:
| Column | Data type | Description |
|---|---|---|
| NODEID | BIGINT | Index value of the node in the tree model The root node has the NODEID 1. |
| COLUMNNAME | VARCHAR(128) | Name of the numeric input column |
| FROMVALUE | DOUBLE | Lower interval boundary A value of NULL indicates negative infinity. |
| TOVALUE | DOUBLE | Upper interval boundary A value of NULL indicates positive infinity. |
| CLOSURE | VARCHAR(12) | Indicates whether the interval limits are contained Possible values are
|
| COUNT | DOUBLE | 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, where records with invalid values or NULL values are included. |
| DEVIATION | DOUBLE | RELFREQUENCY(NODEID) -RELFREQUENCY(0) |
| MEAN | DOUBLE | Mean of all values in the interval |
| VARIANCE | DOUBLE | Variance of all values in the interval |