sys.dm_exec_external_operations (Transact-SQL)

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

Captures information about external PolyBase operations.

Column Name	Data Type	Description	Range
execution_id	nvarchar(32)	Unique query identifier associated with PolyBase query	See ID in sys.dm_exec_requests (Transact-SQL)
step_index	int	Index of the query step	See step_index in sys.dm_exec_distributed_request_steps (Transact-SQL)
operation_ type	nvarchar(128)	Describes a Hadoop operation or other external operation	'External Hadoop Operation'
operation_ name	nvarchar(4000)	Indicates how the status of job in percentage (how much is the input consumed)	0-1 - multiplied by factor 100 (completed)
map_ progress	float	Indicates how the status of a reduce job in percentage, if any	0-1 - multiplied by factor 100 (completed)

See Also