# SET AGGREGATOR

Sets a sync variable to propagate to all aggregators in the cluster.

## Syntax

```

SET AGGREGATOR variable_name = value

```

## Arguments

* `variable_name`: name of the sync variable.
* `value`: value to be assigned to the sync variable.

## Remarks

* `variable_name` must be a [variable type](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/sync-variables.md) that can sync to all aggregators or a variable that can sync to all nodes (aggregators and leaves).
* 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_attach` to all aggregators. `SET AGGREGATOR` can be run on `auto_attach` because `auto_attach` is a variable that can sync to all aggregators. This is indicated in the last sentence of the “Description” column for the [variable](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists.md).

```sql

SET AGGREGATOR auto_attach = 1;

```

Retrieve the variable’s value:

```sql

SELECT @@auto_attach;

```

```output

+---------------+
| @@auto_attach |
+---------------+
|             1 |
+---------------+

```

## Example 2

The following example syncs the variable `regexp_format` to all aggregators. `SET AGGREGATOR` can be run using `regexp_format` because `regexp_format` is a variable that can sync to all nodes (leaves and aggregators). This is indicated in the last sentence of the “Description” column for the [variable](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists-2.md).

```sql

SET AGGREGATOR regexp_format = "extended";

```

Retrieve the variable’s value:

```sql

SELECT @@regexp_format;

```

```output

+-----------------+
| @@regexp_format |
+-----------------+
| extended        |
+-----------------+

```

## Related Topics

* See the [Engine Variables Overview](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables.md) for information about other ways to set variables.

***

Modified at: June 22, 2022

Source: [/db/v9.1/reference/sql-reference/operational-commands/set-aggregator/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/set-aggregator/)

(An index of the documentation is available at /llms.txt)