crp-order-quantity-kpi-service - Details for Query 5501

Submitted Time: 2026/07/21 12:26:32
Duration: 0.2 s
Succeeded Jobs: 8649

Plan Visualization

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { subgraph cluster0 { isCluster="true"; id="cluster0"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n116 ms (0 ms, 1 ms, 24 ms (stage 23258.0: task 350932))"; tooltip="WholeStageCodegen (1)"; 1 [id="node1" labelType="html" label=" Project " tooltip="Project [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, null AS stats#1137187, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091]"]; 2 [id="node2" labelType="html" label="Filter number of output rows: 1" tooltip="Filter ((UDF(true, size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords) AND UDF(true, size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords)) AND if (isnull((((stats#537092.nullCount.marketUnit < stats#537092.numRecords) AND ((stats#537092.minValues.marketUnit <= Alert_Test1) AND (Alert_Test1 <= stats#537092.maxValues.marketUnit))) OR (((isnull(stats#537092.nullCount.marketUnit) OR isnull(stats#537092.numRecords)) OR (isnull(stats#537092.minValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))) OR (isnull(stats#537092.maxValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords)))))) false else UDF(knownnotnull((((stats#537092.nullCount.marketUnit < stats#537092.numRecords) AND ((stats#537092.minValues.marketUnit <= Alert_Test1) AND (Alert_Test1 <= stats#537092.maxValues.marketUnit))) OR (((isnull(stats#537092.nullCount.marketUnit) OR isnull(stats#537092.numRecords)) OR (isnull(stats#537092.minValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))) OR (isnull(stats#537092.maxValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))))), size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords))"]; 3 [id="node3" labelType="html" label="Scan ExistingRDD Delta Table State with Stats #554 - hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log number of output rows: 51" tooltip="Scan ExistingRDD Delta Table State with Stats #554 - hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log[path#537081,partitionValues#537082,size#537083L,modificationTime#537084L,dataChange#537085,stats#537092,tags#537087,deletionVector#537088,baseRowId#537089L,defaultRowCommitVersion#537090L,clusteringProvider#537091]"]; } 2->1; 3->2; }

Details

== Physical Plan ==
* Project (3)
+- * Filter (2)
   +- * Scan ExistingRDD Delta Table State with Stats #554 - hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log (1)


(1) Scan ExistingRDD Delta Table State with Stats #554 - hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log [codegen id : 1]
Output [11]: [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, stats#537092, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091]
Arguments: [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, stats#537092, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091], Delta Table State with Stats #554 - hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log MapPartitionsRDD[30917] at $anonfun$recordDeltaOperationInternal$1 at DatabricksLogging.scala:128, ExistingRDD, UnknownPartitioning(0)

(2) Filter [codegen id : 1]
Input [11]: [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, stats#537092, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091]
Condition : ((UDF(true, size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords) AND UDF(true, size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords)) AND if (isnull((((stats#537092.nullCount.marketUnit < stats#537092.numRecords) AND ((stats#537092.minValues.marketUnit <= Alert_Test1) AND (Alert_Test1 <= stats#537092.maxValues.marketUnit))) OR (((isnull(stats#537092.nullCount.marketUnit) OR isnull(stats#537092.numRecords)) OR (isnull(stats#537092.minValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))) OR (isnull(stats#537092.maxValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords)))))) false else UDF(knownnotnull((((stats#537092.nullCount.marketUnit < stats#537092.numRecords) AND ((stats#537092.minValues.marketUnit <= Alert_Test1) AND (Alert_Test1 <= stats#537092.maxValues.marketUnit))) OR (((isnull(stats#537092.nullCount.marketUnit) OR isnull(stats#537092.numRecords)) OR (isnull(stats#537092.minValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))) OR (isnull(stats#537092.maxValues.marketUnit) AND NOT (stats#537092.nullCount.marketUnit = stats#537092.numRecords))))), size#537083L, (stats#537092.numRecords - coalesce(deletionVector#537088.cardinality, 0)), stats#537092.numRecords))

(3) Project [codegen id : 1]
Output [11]: [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, null AS stats#1137187, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091]
Input [11]: [path#537081, partitionValues#537082, size#537083L, modificationTime#537084L, dataChange#537085, stats#537092, tags#537087, deletionVector#537088, baseRowId#537089L, defaultRowCommitVersion#537090L, clusteringProvider#537091]

SQL / DataFrame Properties

Name	Value
spark.activity.hdlfsEnabled	true
spark.activity.isolateSession	true
spark.sql.adaptive.applyFinalStageShuffleOptimizations	false
spark.sql.parquet.fieldId.read.enabled	true
spark.sql.parquet.fieldId.write.enabled	true
spark.sql.sources.bucketing.autoBucketedScan.enabled	false
temporal.activity.id	c0d716ca-c986-3952-99ee-328b497c66de
temporal.activity.type	BufferDataSnapShot