Clearing Configuration Parameters

You can clear configuration parameter settings at three scopes:

Database Scope

ALTER DATABASE..CLEAR clears one or more parameter values at the database scope, and resets them to their default values as follows:

ALTER DATABASE dbname CLEAR parameter-name[,...];

For example:

ALTER DATABASE mydb CLEAR AnalyzeRowCountInterval, FailoverToStandbyAfter;

Node Scope

ALTER NODE..CLEAR clears one or more parameter values at the node scope, and resets them to their database settings, if any. If the parameters are not set at the database scope, Vertica resets them to their default value.

ALTER NODE node-name CLEAR parameter-name[,...];

The following example clears MaxClientSessions on node v_vmart_node0001:

ALTER NODE v_vmart_node0001 CLEAR MaxClientSessions;

Session Scope

ALTER SESSION..CLEAR clears one or more parameter values at the session scope, and resets them to their node or database settings, if any. If the parameters are not set at either scope, Vertica resets them to their default value.

ALTER SESSION CLEAR parameter-name[,...];

For example:

=> ALTER SESSION CLEAR ForceUDxFencedMode;