sys.dm_pdw_hadoop_operations (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

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.

Note

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.

See Also

System Views (Transact-SQL)