ALTER SESSION

Use ALTER SESSION to set and clear session-level configuration parameter values for the current session.

Syntax

ALTER SESSION {
    SET [PARAMETER] parameter‑name=value [,…]
    | CLEAR [PARAMETER] parameter‑name[,…]
    | SET UDPARAMETER [ FOR { namespace | libname } ] key=value [,…]
    | CLEAR UDPARAMETER [ FOR { namespace | libname } ] key [,…]
}

Parameters

SET [PARAMETER]	Sets one or more configuration parameters to the specified value.
CLEAR [PARAMETER]	Clears one or more specified configuration parameters .
SET UDPARAMETER	Sets a user-defined session parameter, can be used in combination with a UDx. If omit a name space, Vertica uses the PUBLIC name space. Key size values: Set from client side: 128 characters Set from UDx side: Unlimited
CLEAR UDPARAMETER	Clears one or more user-defined session parameters.

Privileges

None

Examples

Set and clear a parameter

• Force all UDxes that support fenced mode to run in fenced mode, even if their definition specified is NOT FENCED:

  => ALTER SESSION SET ForceUDxFencedMode = 1;

• Clear ForceUDxFencedMode at the session level. The value now reflects the default value (0).

  => ALTER SESSION CLEAR ForceUDxFencedMode;

Set and clear a user-defined parameter

• Set the value of RowCount, in the MyLibrary library and PUBLIC namespace, to 25.

  => ALTER SESSION SET UDPARAMETER FOR MyLibrary RowCount = 25;

• Clear RowCount at the session level. The value now reflects the default value (0).

  => ALTER SESSION CLEAR UDPARAMETER FOR MyLibrary RowCount;

See Also

SESSION_PARAMETERS