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

Set and clear a user-defined parameter

See Also

SESSION_PARAMETERS

 


Was this topic helpful?