title

sys.dm_exec_compute_node_errors (Transact-SQL)

description

sys.dm_exec_compute_node_errors (Transact-SQL)

author

rwestMSFT

ms.author

randolphwest

ms.date

11/04/2019

ms.service

sql

ms.subservice

system-objects

ms.topic

reference

f1_keywords

SYS.DM_EXEC_COMPUTE_NODE_ERRORS_TSQL

DM_EXEC_COMPUTE_NODE_ERRORS

DM_EXEC_COMPUTE_NODE_ERRORS_TSQL

helpviewer_keywords

PolyBase

PolyBase, views

dm_exec_compute_node_errors

sys.dm_exec_compute_node_errors management view

dev_langs

TSQL

monikerRange

>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_exec_compute_node_errors (Transact-SQL)

Returns errors that occur on PolyBase compute nodes.

Column Name	Data Type	Description	Range
error_id	`nvarchar(36)`	Unique numeric id associated with the error .	Unique across all query errors in the system
source	`nvarchar(255)`	Source thread or process description
type	`nvarchar(255)`	Type of error.
create_time	`datetime`	The time of the error occurrence
compute_node_id	`int`	Identifier of the specific compute node	See compute_node_id of sys.dm_exec_compute_nodes (Transact-SQL)
rexecution_id	`nvarchar(36)`	Identifier of the PolyBase query, if any.
spid	`int`	Identifier of the SQL Server session
thread_id	`int`	Numeric identifier of the thread on which the error occurred.
details	nvarchar(4000)	Full description of the details of the error.
compute_pool_id	`int`	Unique identifier for the pool.

Provide feedback