| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_polybase_leave_group (Transact-SQL) |
Removes a SQL Server instance from a PolyBase group for scale-out computation. |
markingmyname |
maghan |
randolphwest |
03/07/2025 |
sql |
polybase |
conceptual |
|
|
|
[!INCLUDE sqlserver2016]
Removes a SQL Server instance from a PolyBase group for scale-out computation.
The SQL Server instance must have the PolyBase feature installed. PolyBase enables the integration of non-SQL Server data sources, such as Hadoop and Azure Blob Storage. See also sp_polybase_join_group.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_polybase_leave_group;
None.
0 (success) or 1 (failure).
Requires CONTROL SERVER permission.
You can only remove a compute node from a group.
After running the stored procedure, restart the PolyBase engine and PolyBase Data Movement Service on the machine. To verify, run the following DMV on the head node:
EXEC sys.dm_exec_compute_nodes;The example removes the current machine from a PolyBase group.
EXEC sp_polybase_leave_group;