Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SET AGGREGATOR
On this page
Sets a sync variable to propagate to all aggregators in the cluster.
Syntax
SET AGGREGATOR variable_name = valueArguments
-
variable_: name of the sync variable.name -
value: value to be assigned to the sync variable.
Remarks
-
variable_must be a variable type that can sync to all aggregators or a variable that can sync to all nodes (aggregators and leaves).name -
You cannot run this command on a non-sync variable.
-
This command must be run on the master aggregator.
Examples
Example 1
The following example syncs the variable auto_ to all aggregators.SET AGGREGATOR can be run on auto_ because auto_ is a variable that can sync to all aggregators.Description
column for the variable.
SET AGGREGATOR auto_attach = 1;
Retrieve the variable’s value:
SELECT @@auto_attach;
+---------------+
| @@auto_attach |
+---------------+
| 1 |
+---------------+Example 2
The following example syncs the variable regexp_ to all aggregators.SET AGGREGATOR can be run using regexp_ because regexp_ is a variable that can sync to all nodes (leaves and aggregators).Description
column for the variable.
SET AGGREGATOR regexp_format = "extended";
Retrieve the variable’s value:
SELECT @@regexp_format;
+-----------------+
| @@regexp_format |
+-----------------+
| extended |
+-----------------+Related Topics
-
See the Engine Variables Overview for information about other ways to set variables.
Last modified: June 22, 2022