<model name>_COLUMN_STATISTICS table

This table contains statistical information about the active columns for each node.

The existence of this table depends on the value of the statistics parameter when the model is built. If you specify statistics=none, this table is not created.

The following table shows the table columns:

Table 1. Columns of the <model name>_COLUMN_STATISTICS table
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
CARDINALITY BIGINT Number of distinct values

If the column is continuous, the value is NULL.
MODE VARCHAR (512) Most frequent discrete value for NODEID in COLUMNNAME
MINIMUM DOUBLE Minimum value

If the column is not numeric, this value is NULL.
MAXIMUM DOUBLE Maximum value

If the column is not numeric, this value is NULL.
MEAN DOUBLE Mean value

If the column is not numeric, this value is NULL.
VARIANCE DOUBLE Variance

If the column is not numeric, this value is NULL.
VALIDFREQ DOUBLE Frequency of valid values
MISSINGFREQ DOUBLE Frequency of missing values
INVALIDFREQ DOUBLE Frequency of invalid values
IMPORTANCE DOUBLE Importance of the column for data records in NODEID in relation to the target prediction