sys.dm_exec_external_operations (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

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

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)