<model name>_DISCRETE_STATISTICS table
This table contains statistical information about the values of active categorical columns and active continuous columns with 100 values or less for each node.
The content of this table depends on the value of the statistics parameter when the model is built. If you specify statistics=none or statistics=columns, this table contains only statistics for the target column values in 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 input column |
| VALUE | VARCHAR(512) | Value that is contained in COLUMNNAME If the column is numeric, the value is a string representation of the value of the true column. |
| COUNT | DOUBLE | Number of occurrences of records in the VALUE column |
| RELFREQUENCY | DOUBLE | Percentage of occurrences of records in the VALUE column The relative frequency is based on all records, where records with invalid values or NULL values are included. |
| DEVIATION | DOUBLE | RELFREQUENCY(NODEID) -RELFREQUENCY(1) |