SHOW-VARIABLES

SHOW VARIABLES

This statement is used to display Doris system variables, which can be queried by conditions

Syntax:

SHOW [GLOBAL | SESSION] VARIABLES
     [LIKE 'pattern' | WHERE expr]

Note:

show variables is mainly used to view the values of system variables.
Executing the SHOW VARIABLES command does not require any privileges. Anyone who has connected to the server can execute this command.
The like statement means to match by variable_name
The % wildcard can be used anywhere in the matching pattern

Match by variable_name. The following example shows an exact matching
```
show variables like 'max_connections';
```
Use the % wildcard to match multiple items
```
show variables like '%connec%';
```

Use the Where clause for matching queries

show variables where variable_name = 'version';

SHOW, VARIABLES