AGGREGATOR_ID

Returns the unique ID (node_id) for the current aggregator.

When you do not know the specific aggregator you are connecting to, either because you are connecting via the DML endpoint in SingleStore Helios or in situations where a load balancer is used, the ID returned by AGGREGATOR_ID() can be combined with CONNECTION_ID() to provide a cluster-wide unique identifier for the active session.

AGGREGATOR_ID()

SELECT AGGREGATOR_ID();

+-----------------+
| AGGREGATOR_ID() |
+-----------------+
|               8 |
+-----------------+