Clearing Configuration Parameters

You can clear configuration parameter settings at three scopes, in ascending levels of precedence:

  • Database
  • Node
  • Session

Database Scope

ALTER DATABASE...CLEAR resets one or more parameter values at the database scope to their default values. For example:

ALTER DATABASE DEFAULT CLEAR AnalyzeRowCountInterval, FailoverToStandbyAfter;

Node Scope

ALTER NODE...CLEAR resets one or more parameter values at the node scope to their database settings, if any. If the parameters are not set at the database scope, Vertica resets them to their default value. The following example clears MaxClientSessions on node v_vmart_node0001:

ALTER NODE v_vmart_node0001 CLEAR MaxClientSessions;

Session Scope

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

=> ALTER SESSION CLEAR ForceUDxFencedMode;