sp_polybase_leave_group (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions

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.

Transact-SQL syntax conventions

Syntax

sp_polybase_leave_group;

Return code values

0 (success) or 1 (failure).

Permissions

Requires CONTROL SERVER permission.

Remarks

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;

Examples

The example removes the current machine from a PolyBase group.

EXEC sp_polybase_leave_group;