Use ALTER SESSION to set and clear session-level configuration parameter values for the current session.
ALTER SESSION {
SET [PARAMETER] parameter‑name=value [,…]
| CLEAR [PARAMETER] parameter‑name[,…]
| SET UDPARAMETER [ FOR { namespace | libname } ] key=value [,…]
| CLEAR UDPARAMETER [ FOR { namespace | libname } ] key [,…]
}
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 Key size values:
|
CLEAR UDPARAMETER
|
Clears one or more user-defined session parameters. |
None
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 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;
Was this topic helpful?
