crp-order-quantity-kpi-service - Details for Job 41

Status: SUCCEEDED
Submitted: 2026/04/20 06:14:53
Duration: 84 ms
Associated SQL Query: 28
Job Group: 36e0914c-7e4e-3a52-bc93-e306e07299ba
Completed Stages: 1
Skipped Stages: 8

Enable zooming

digraph G { id="graph_92"; subgraph graph_stage_92 { id="graph_stage_92"; isCluster="true"; label="Stage 92 (skipped)"; subgraph cluster_453 { id="cluster_453"; isCluster="true"; label="Scan parquet "; 182 [id="node_182" labelType="html" label="FileScanRDD [182] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 183 [id="node_183" labelType="html" label="MapPartitionsRDD [183] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_434 { id="cluster_434"; isCluster="true"; label="WholeStageCodegen (3)"; 186 [id="node_186" labelType="html" label="MapPartitionsRDD [186] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_433 { id="cluster_433"; isCluster="true"; label="Exchange"; 187 [id="node_187" labelType="html" label="MapPartitionsRDD [187] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 188 [id="node_188" labelType="html" label="MapPartitionsRDD [188] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 182->183; 183->186; 186->187; 187->188; }

digraph G { id="graph_93"; subgraph graph_stage_93 { id="graph_stage_93"; isCluster="true"; label="Stage 93 (skipped)"; subgraph cluster_451 { id="cluster_451"; isCluster="true"; label="Scan parquet "; 178 [id="node_178" labelType="html" label="FileScanRDD [178] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 180 [id="node_180" labelType="html" label="MapPartitionsRDD [180] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_442 { id="cluster_442"; isCluster="true"; label="WholeStageCodegen (2)"; 181 [id="node_181" labelType="html" label="MapPartitionsRDD [181] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_441 { id="cluster_441"; isCluster="true"; label="Exchange"; 184 [id="node_184" labelType="html" label="MapPartitionsRDD [184] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 185 [id="node_185" labelType="html" label="MapPartitionsRDD [185] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 178->180; 180->181; 181->184; 184->185; }

digraph G { id="graph_94"; subgraph graph_stage_94 { id="graph_stage_94"; isCluster="true"; label="Stage 94 (skipped)"; subgraph cluster_447 { id="cluster_447"; isCluster="true"; label="Scan parquet "; 173 [id="node_173" labelType="html" label="FileScanRDD [173] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 174 [id="node_174" labelType="html" label="MapPartitionsRDD [174] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_430 { id="cluster_430"; isCluster="true"; label="WholeStageCodegen (1)"; 176 [id="node_176" labelType="html" label="MapPartitionsRDD [176] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_429 { id="cluster_429"; isCluster="true"; label="Exchange"; 179 [id="node_179" labelType="html" label="MapPartitionsRDD [179] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 173->174; 174->176; 176->179; }

digraph G { id="graph_95"; subgraph graph_stage_95 { id="graph_stage_95"; isCluster="true"; label="Stage 95 (skipped)"; subgraph cluster_461 { id="cluster_461"; isCluster="true"; label="Exchange"; 189 [id="node_189" labelType="html" label="ShuffledRowRDD [189] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_459 { id="cluster_459"; isCluster="true"; label="Exchange"; 190 [id="node_190" labelType="html" label="MapPartitionsRDD [190] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 189->190; }

179,189

digraph G { id="graph_96"; subgraph graph_stage_96 { id="graph_stage_96"; isCluster="true"; label="Stage 96 (skipped)"; subgraph cluster_472 { id="cluster_472"; isCluster="true"; label="Exchange"; 193 [id="node_193" labelType="html" label="ShuffledRowRDD [193] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_468 { id="cluster_468"; isCluster="true"; label="WholeStageCodegen (5)"; 194 [id="node_194" labelType="html" label="MapPartitionsRDD [194] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_467 { id="cluster_467"; isCluster="true"; label="Exchange"; 195 [id="node_195" labelType="html" label="MapPartitionsRDD [195] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 193->194; 194->195; }

185,193

digraph G { id="graph_97"; subgraph graph_stage_97 { id="graph_stage_97"; isCluster="true"; label="Stage 97 (skipped)"; subgraph cluster_483 { id="cluster_483"; isCluster="true"; label="Exchange"; 196 [id="node_196" labelType="html" label="ShuffledRowRDD [196] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_479 { id="cluster_479"; isCluster="true"; label="WholeStageCodegen (6)"; 197 [id="node_197" labelType="html" label="MapPartitionsRDD [197] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_489 { id="cluster_489"; isCluster="true"; label="Exchange"; 198 [id="node_198" labelType="html" label="ShuffledRowRDD [198] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_485 { id="cluster_485"; isCluster="true"; label="WholeStageCodegen (7)"; 199 [id="node_199" labelType="html" label="MapPartitionsRDD [199] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_475 { id="cluster_475"; isCluster="true"; label="WholeStageCodegen (8)"; 200 [id="node_200" labelType="html" label="ZippedPartitionsRDD2 [200] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 201 [id="node_201" labelType="html" label="MapPartitionsRDD [201] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_474 { id="cluster_474"; isCluster="true"; label="Exchange"; 202 [id="node_202" labelType="html" label="MapPartitionsRDD [202] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 196->197; 198->199; 197->200; 199->200; 200->201; 201->202; }

190,196

195,198

digraph G { id="graph_98"; subgraph graph_stage_98 { id="graph_stage_98"; isCluster="true"; label="Stage 98 (skipped)"; subgraph cluster_465 { id="cluster_465"; isCluster="true"; label="Exchange"; 191 [id="node_191" labelType="html" label="ShuffledRowRDD [191] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_463 { id="cluster_463"; isCluster="true"; label="Exchange"; 192 [id="node_192" labelType="html" label="MapPartitionsRDD [192] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 191->192; }

188,191

digraph G { id="graph_99"; subgraph graph_stage_99 { id="graph_stage_99"; isCluster="true"; label="Stage 99 (skipped)"; subgraph cluster_511 { id="cluster_511"; isCluster="true"; label="Exchange"; 203 [id="node_203" labelType="html" label="ShuffledRowRDD [203] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_507 { id="cluster_507"; isCluster="true"; label="WholeStageCodegen (9)"; 204 [id="node_204" labelType="html" label="MapPartitionsRDD [204] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_517 { id="cluster_517"; isCluster="true"; label="Exchange"; 205 [id="node_205" labelType="html" label="ShuffledRowRDD [205] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_513 { id="cluster_513"; isCluster="true"; label="WholeStageCodegen (10)"; 206 [id="node_206" labelType="html" label="MapPartitionsRDD [206] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_504 { id="cluster_504"; isCluster="true"; label="WholeStageCodegen (11)"; 207 [id="node_207" labelType="html" label="ZippedPartitionsRDD2 [207] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 208 [id="node_208" labelType="html" label="MapPartitionsRDD [208] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_503 { id="cluster_503"; isCluster="true"; label="Project"; 209 [id="node_209" labelType="html" label="MapPartitionsRDD [209] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_490 { id="cluster_490"; isCluster="true"; label="WholeStageCodegen (12)"; 210 [id="node_210" labelType="html" label="MapPartitionsRDD [210] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_518 { id="cluster_518"; isCluster="true"; label="mapPartitionsInternal"; 211 [id="node_211" labelType="html" label="MapPartitionsRDD [211] [Unordered] isEmpty at InsightHandlerDataAccessImpl.java:62}"]; } subgraph cluster_519 { id="cluster_519"; isCluster="true"; label="mapPartitionsInternal"; 212 [id="node_212" labelType="html" label="AdaptiveSparkPlan isFinalPlan=false\n+- HashAggregate(keys=[product#1127, plant#1128], functions=[], output=[product#1127, plant#1128])\n +- HashAggregate(keys=[product#1127, plant#1128], functions=[], output=[product#1127, plant#1128])\n +- Project [product#1127, plant#1128]\n +- Filter (((size(demandTimeBuckets#1577, true) = 0) OR isnull(demandTimeBuckets#1577)) AND ((size(demandPointInTime#1580, true) = 0) OR isnull(demandPointInTime#1580)))\n +- BroadcastHashJoin [coalesce(plant#1128, ), isnull(plant#1128), coalesce(product#1127, ), isnull(product#1127)], [coalesce(plant#1573, ), isnull(plant#1573), coalesce(product#1572, ), isnull(product#1572)], LeftOuter, BuildRight, false\n :- Project [product#1127, plant#1128]\n : +- Generate explode(_extract_quantityDenominator#1607), [product#1127, plant#1128], true, [quantityDenominator#1216]\n : +- Project [product#1127, plant#1128, filteredUnitOfMeasureConversions#1205.quantityDenominator AS _ex... [212] [Cached] [Unordered] isEmpty at InsightHandlerDataAccessImpl.java:62}"]; } subgraph cluster_576 { id="cluster_576"; isCluster="true"; label="InMemoryTableScan"; 221 [id="node_221" labelType="html" label="MapPartitionsRDD [221] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 222 [id="node_222" labelType="html" label="MapPartitionsRDD [222] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 223 [id="node_223" labelType="html" label="MapPartitionsRDD [223] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_572 { id="cluster_572"; isCluster="true"; label="WholeStageCodegen (1)"; 224 [id="node_224" labelType="html" label="MapPartitionsRDD [224] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_571 { id="cluster_571"; isCluster="true"; label="Exchange"; 225 [id="node_225" labelType="html" label="MapPartitionsRDD [225] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 203->204; 205->206; 204->207; 206->207; 207->208; 208->209; 209->210; 210->211; 211->212; 212->221; 221->222; 222->223; 223->224; 224->225; }

202,203

192,205

212

digraph G { id="graph_100"; subgraph graph_stage_100 { id="graph_stage_100"; isCluster="true"; label="Stage 100"; subgraph cluster_581 { id="cluster_581"; isCluster="true"; label="Exchange"; 226 [id="node_226" labelType="html" label="ShuffledRowRDD [226] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_577 { id="cluster_577"; isCluster="true"; label="WholeStageCodegen (2)"; 227 [id="node_227" labelType="html" label="MapPartitionsRDD [227] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_582 { id="cluster_582"; isCluster="true"; label="mapPartitionsInternal"; 228 [id="node_228" labelType="html" label="MapPartitionsRDD [228] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 226->227; 227->228; }

225,226

Completed Stages (1)

Page:

Stage Id ▾	Pool Name	Description	Submitted	Duration	Tasks: Succeeded/Total	Input	Output	Shuffle Read	Shuffle Write
100	tenants-pool-506	replenishmentRunId = 10000000004 tenantId = 8793759653749352888 activityType = BufferDataSnapShot activityId = 36e0914c-7e4e-3a52-bc93-e306e07299ba workflowType = KpiPrepareDataSnapshotWorkflow workflowId = b49fb3c6-88b3-3c61-97e8-cbe3f98f9409 attempt = 1 cornerstoneTenantId = 8445 marketUnit = 10000_OP_PERF scenario = STANDARD $anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	2026/04/20 06:14:53	82 ms	1/1			2.7 KiB

Page:

Skipped Stages (8)

Page:

Stage Id ▾	Pool Name	Description	Submitted	Duration	Tasks: Succeeded/Total
99	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
98	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
97	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
96	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
95	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
94	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
93	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/37
92	default	$anonfun$withThreadLocalCaptured$2 at <unknown>:0 +details org.apache.spark.sql.execution.SQLExecution$.$anonfun$withThreadLocalCaptured$2(SQLExecution.scala:316) java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source)	Unknown	Unknown	0/2

Page: