Skip to main content
Skip to main content

UNSET-VARIABLE

UNSET-VARIABLE​

Name​

UNSET VARIABLE

Description​

This statement is used to restore Doris system variables. These system variables can be modified at global or session level.

grammar:

UNSET [SESSION|GLOBAL] VARIABLE (variable_name | ALL)

illustrate:

  1. (variable_name | ALL): statement must be ended with a variable name or keyword ALL.

Note:

  1. Only ADMIN users can unset variables to take effect globally
  2. When restore a variable with GLOBAL, it only affect your current using session and new open sessions. It does not affect other current open sessions.

Example​

  1. Restore value of the time zone

    UNSET VARIABLE time_zone;
  2. Restore the global execution memory size

    UNSET GLOBAL VARIABLE exec_mem_limit;
  3. Restore all variables globally

    UNSET GLOBAL VARIABLE ALL;

Keywords​

UNSET, VARIABLE

Best Practice​