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

Status: SUCCEEDED
Submitted: 2026/04/20 06:14:51
Duration: 1 s
Associated SQL Query: 27
Job Group: 36e0914c-7e4e-3a52-bc93-e306e07299ba
Completed Stages: 2
Skipped Stages: 7

Enable zooming

digraph G { id="graph_75"; subgraph graph_stage_75 { id="graph_stage_75"; isCluster="true"; label="Stage 75 (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_76"; subgraph graph_stage_76 { id="graph_stage_76"; isCluster="true"; label="Stage 76 (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_77"; subgraph graph_stage_77 { id="graph_stage_77"; isCluster="true"; label="Stage 77 (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_78"; subgraph graph_stage_78 { id="graph_stage_78"; isCluster="true"; label="Stage 78 (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_79"; subgraph graph_stage_79 { id="graph_stage_79"; isCluster="true"; label="Stage 79 (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_80"; subgraph graph_stage_80 { id="graph_stage_80"; isCluster="true"; label="Stage 80 (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_81"; subgraph graph_stage_81 { id="graph_stage_81"; isCluster="true"; label="Stage 81 (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_82"; subgraph graph_stage_82 { id="graph_stage_82"; isCluster="true"; label="Stage 82"; 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_522 { id="cluster_522"; isCluster="true"; label="InMemoryTableScan"; 213 [id="node_213" labelType="html" label="MapPartitionsRDD [213] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 214 [id="node_214" labelType="html" label="MapPartitionsRDD [214] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 215 [id="node_215" labelType="html" label="MapPartitionsRDD [215] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_520 { id="cluster_520"; isCluster="true"; label="CollectLimit"; 216 [id="node_216" labelType="html" label="MapPartitionsRDD [216] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 217 [id="node_217" labelType="html" label="MapPartitionsRDD [217] [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->213; 213->214; 214->215; 215->216; 216->217; }

202,203

192,205

212

digraph G { id="graph_83"; subgraph graph_stage_83 { id="graph_stage_83"; isCluster="true"; label="Stage 83"; subgraph cluster_520 { id="cluster_520"; isCluster="true"; label="CollectLimit"; 218 [id="node_218" labelType="html" label="ShuffledRowRDD [218] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; 219 [id="node_219" labelType="html" label="MapPartitionsRDD [219] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } subgraph cluster_523 { id="cluster_523"; isCluster="true"; label="mapPartitionsInternal"; 220 [id="node_220" labelType="html" label="MapPartitionsRDD [220] [Unordered] $anonfun$withThreadLocalCaptured$2 at <unknown>:0}"]; } } 218->219; 219->220; }

217,218

Completed Stages (2)

Page:

Stage Id ▾	Pool Name	Description	Submitted	Duration	Tasks: Succeeded/Total	Input	Output	Shuffle Read	Shuffle Write
83	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:52	10 ms	1/1
82	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:51	1 s	37/37	142.7 KiB			2.1 KiB

Page:

Skipped Stages (7)

Page:

Stage Id ▾	Pool Name	Description	Submitted	Duration	Tasks: Succeeded/Total
81	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
80	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
79	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
78	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
77	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
76	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
75	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: