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 you do not specify 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

Set and clear a user-defined parameter

See Also

SESSION_PARAMETERS