| title | sys.dm_exec_external_operations (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_exec_external_operations (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/15/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=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)