SET DIST VARIABLE

Description

The SET DIST VARIABLE syntax is used to set system variables.

Syntax

SetDistVariable ::=
  'SET' 'DIST' 'VARIABLE' variableName '=' variableValue

variableName ::=
  identifier

variableValue ::=
  literal

Supplement

• variableName is a ShardingSphere property; see common properties and Proxy properties. Use underscores instead of hyphens in DistSQL variable names.

• agent_plugins_enabled is used to set the agent plugin status. Its default value is TRUE.

Example

• Set a ShardingSphere property

SET DIST VARIABLE sql_show = true;

• Set agent plugin enable status

SET DIST VARIABLE agent_plugins_enabled = TRUE;

Reserved word

SET, DIST, VARIABLE

Related links

• Reserved word