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 Cloud 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.

Syntax

AGGREGATOR_ID()

Return Type

Integer.

Example

SELECT AGGREGATOR_ID();
+-----------------+
| AGGREGATOR_ID() |
+-----------------+
|               8 |
+-----------------+

Last modified: November 8, 2023

Was this article helpful?