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;