IDAX.PRUNE_REGTREE - Prune a regression tree model

Use this stored procedure to prune a regression tree model.

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role. Additionally, you must be the owner of the model or have the authority to alter it.

Syntax

IDAX.PRUNE_REGTREE(in parameter_string varchar(32672))

Parameter descriptions

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

model: Mandatory.; The name of the regression tree model that is to be pruned.; Data type: VARCHAR(64)
valtable: Mandatory.; The name of the input table.; Data type: VARCHAR(128)
id: Optional.; The column of the input table that identifies a unique instance ID.; Default: The name of the id column that is used to build the model.; Data type: VARCHAR(128)
target: Optional.; The column of the input table that represents the prediction target.; Default: The name of the target column that is used to build the model.; Data type: VARCHAR(128)
qmeasure: Optional.; The quality measure for pruning.; Allowed values are 'mse', 'r2', 'pearson', and 'spearman'.; Default: mse; Data type: VARCHAR(4)

Returned information

The number of the nodes and leaves of a pruned regression tree as a result set.

Example

CALL IDAX.PRUNE_REGTREE('model=adult_regtree, intable=adult_prune');