Applies to: Azure Synapse Analytics Parallel Data Warehouse
Contains a row for each map-reduce job that is pushed down to Hadoop as part of running a Azure Synapse Analytics query on an external Hadoop table. Each map-reduce job represents one of the predicates in the query. This is only used when predicate pushdown is enabled for queries on Hadoop external tables.
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
|Column Name||Data Type||Description||Range|
|request_id||nvarchar(32)||ID for this external Hadoop operation.||Same as ID in sys.dm_pdw_exec_requests (Transact-SQL).|
|step_index||int||Index of the query step that refers to this Hadoop operation.||Same as step_index in sys.dm_pdw_request_steps (Transact-SQL).|
|operation_type||nvarchar(255)||Describes the type of external operation.||'External Hadoop Operation'|
|operation_name||nvarchar(4000)||The job ID for a map-reduce job. This is returned by Hadoop after Azure Synapse Analytics submits the job.|
|map_progress||float||The percentage of input data that has been consumed so far by the map job.||A floating point number between, and including, 0 and 100.|
|reduce_progress||int||The percentage of the reduce job that has completed..||A floating point number between, and including, 0 and 100.|