| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_exec_external_operations (Transact-SQL) |
sys.dm_exec_external_operations (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sqlserver2016]
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) |
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)