sp_polybase_leave_group (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Removes a SQL Server instance from a PolyBase group for scale-out computation.

The SQL Server instance must have the PolyBase Guide 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.

Topic link icon 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: sys.dm_exec_compute_nodes.

Example

The example removes the current machine from a PolyBase group.

EXEC sp_polybase_leave_group ;  

See Also

Get started with PolyBase
System Stored Procedures (Transact-SQL)