<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.
If you specify statistics=none or statistics=columns, this table is not created.
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) |