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

Submitted Time: 2026/03/21 01:12:25
Duration: 0.6 s
Succeeded Jobs: 6410

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 (2)\n \nduration: total (min, med, max (stageId: taskId))\n123 ms (0 ms, 0 ms, 13 ms (stage 116716.0: task 387996))"; tooltip="WholeStageCodegen (2)"; 1 [id="node1" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 19 ms (0 ms, 0 ms, 4 ms (stage 116716.0: task 387994)) peak memory total (min, med, max (stageId: taskId)) 9.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 116716.0: task 388004)) number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[shardId#1100457], functions=[])"]; } 2 [id="node2" labelType="html" label="Exchange shuffle records written: 36 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 36 local bytes read: 1012.0 B merged fetch fallback count: 0 local blocks read: 11 remote merged chunks fetched: 0 remote blocks read: 25 data size total (min, med, max (stageId: taskId)) 1152.0 B (32.0 B, 32.0 B, 32.0 B (stage 116715.0: task 387959)) local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 39 ms (0 ms, 0 ms, 15 ms (stage 116715.0: task 387959)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 2.2 KiB number of partitions: 37 remote reqs duration: 4 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 3.2 KiB (92.0 B, 92.0 B, 92.0 B (stage 116715.0: task 387959))" tooltip="Exchange hashpartitioning(shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1756401]"]; subgraph cluster3 { isCluster="true"; id="cluster3"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (0 ms, 1 ms, 157 ms (stage 116715.0: task 387969))"; tooltip="WholeStageCodegen (1)"; 4 [id="node4" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 26 ms (0 ms, 0 ms, 4 ms (stage 116715.0: task 387969)) peak memory total (min, med, max (stageId: taskId)) 9.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 116715.0: task 387959)) number of output rows: 36 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[shardId#1100457], functions=[])"]; } 5 [id="node5" labelType="html" label="InMemoryTableScan number of output rows: 156" tooltip="InMemoryTableScan [shardId#1100457]"]; 6 [id="node6" labelType="html" label="SortAggregate number of output rows: 0" tooltip="SortAggregate(key=[demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216], functions=[first(kpis#1131244, false)])"]; subgraph cluster7 { isCluster="true"; id="cluster7"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 8 [id="node8" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [demandChannel#1131215 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, qty#1131235 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1131216 ASC NULLS FIRST], false, 0"]; } 9 [id="node9" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, 37), ENSURE_REQUIREMENTS, [plan_id=1756312]"]; 10 [id="node10" labelType="html" label="SortAggregate number of output rows: 0" tooltip="SortAggregate(key=[demandChannel#1131215, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1131235)) AS qty#1131235, worklistShardItemId#1100458L, demandStream#1131216], functions=[partial_first(kpis#1131244, false)])"]; subgraph cluster11 { isCluster="true"; id="cluster11"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 12 [id="node12" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [demandChannel#1131215 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#1131235)) AS qty#1131235 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1131216 ASC NULLS FIRST], false, 0"]; 13 [id="node13" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244]"]; 14 [id="node14" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [coalesce(product#1131208, ), isnull(product#1131208), coalesce(plant#1131209, ), isnull(plant#1131209)], [coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461)], Inner, BuildRight, ((qty#1131235 <=> qty#1100464) OR isnull(qty#1100464)), false"]; } 15 [id="node15" labelType="html" label=" Union " tooltip="Union"]; 16 [id="node16" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131189.productId AS product#1131208, prodPlantResults#1131189.plantId AS plant#1131209, null AS qty#1131235, null AS demandChannel#1131215, null AS demandStream#1131216, transform(prodPlantResults#1131189.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131244]"]; 17 [id="node17" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1131189]"]; subgraph cluster18 { isCluster="true"; id="cluster18"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 19 [id="node19" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1131182), false, [prodPlantResults#1131189]"]; 20 [id="node20" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131182]"]; 21 [id="node21" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1131182, true) > 0) AND isnotnull(prodPlantResults#1131182))"]; 22 [id="node22" labelType="html" label=" SerializeFromObject " tooltip="SerializeFromObject [mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement)))) null else named_struct(measuredUnit, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getMeasuredUnit()))), numberOfCalls, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getNumberOfCalls()), parent, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getParent()))), runtime, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getRuntime())), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getPerformanceMeasurements()), None) AS performanceMeasurements#1131181, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult)))) null else named_struct(demandChannelStreamKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult)))) null else named_struct(demandChannel, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandChannel()))), demandStream, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandStream()))), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getKpiResults()), None)), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getDemandChannelStreamKpiResults()), None), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getKpiResults()), None), plantId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getPlantId()))), productId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getProductId()))), quantityKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult)))) null else named_struct(kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getKpiResults()), None), quantity, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getQuantity())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getQuantityKpiResults()), None)), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getProdPlantResults()), None) AS prodPlantResults#1131182]"]; } 23 [id="node23" labelType="html" label=" Scan " tooltip="Scan[obj#1131178]"]; 24 [id="node24" labelType="html" label=" Project " tooltip="Project [_extract_productId#1131380 AS product#1131195, _extract_plantId#1131381 AS plant#1131196, quantityKpiResults#1131201.quantity AS qty#1131202, null AS demandChannel#1131204, null AS demandStream#1131205, transform(quantityKpiResults#1131201.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131378]"]; subgraph cluster25 { isCluster="true"; id="cluster25"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 26 [id="node26" labelType="html" label="Generate number of output rows: 0" tooltip="Generate explode(_extract_quantityKpiResults#1131382), [_extract_productId#1131380, _extract_plantId#1131381], false, [quantityKpiResults#1131201]"]; 27 [id="node27" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131234.productId AS _extract_productId#1131380, prodPlantResults#1131234.plantId AS _extract_plantId#1131381, prodPlantResults#1131234.quantityKpiResults AS _extract_quantityKpiResults#1131382]"]; 28 [id="node28" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((size(prodPlantResults#1131234.quantityKpiResults, true) > 0) AND isnotnull(prodPlantResults#1131234.quantityKpiResults))"]; } 29 [id="node29" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1131234], [(size(prodPlantResults#1131234.quantityKpiResults, true) > 0), isnotnull(prodPlantResults#1131234.quantityKpiResults)]"]; subgraph cluster30 { isCluster="true"; id="cluster30"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 31 [id="node31" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1131182), false, [prodPlantResults#1131189]"]; 32 [id="node32" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131182]"]; 33 [id="node33" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1131182, true) > 0) AND isnotnull(prodPlantResults#1131182))"]; 34 [id="node34" labelType="html" label=" SerializeFromObject " tooltip="SerializeFromObject [mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement)))) null else named_struct(measuredUnit, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getMeasuredUnit()))), numberOfCalls, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getNumberOfCalls()), parent, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getParent()))), runtime, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getRuntime())), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getPerformanceMeasurements()), None) AS performanceMeasurements#1131181, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult)))) null else named_struct(demandChannelStreamKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult)))) null else named_struct(demandChannel, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandChannel()))), demandStream, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandStream()))), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getKpiResults()), None)), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getDemandChannelStreamKpiResults()), None), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getKpiResults()), None), plantId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getPlantId()))), productId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getProductId()))), quantityKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult)))) null else named_struct(kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getKpiResults()), None), quantity, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getQuantity())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getQuantityKpiResults()), None)), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getProdPlantResults()), None) AS prodPlantResults#1131182]"]; } 35 [id="node35" labelType="html" label=" Scan " tooltip="Scan[obj#1131178]"]; 36 [id="node36" labelType="html" label=" Project " tooltip="Project [_extract_productId#1131383 AS product#1131217, _extract_plantId#1131384 AS plant#1131218, null AS qty#1131240, demandChannelStreamKpiResults#1131223.demandChannel AS demandChannel#1131225, demandChannelStreamKpiResults#1131223.demandStream AS demandStream#1131227, transform(demandChannelStreamKpiResults#1131223.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131379]"]; subgraph cluster37 { isCluster="true"; id="cluster37"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 38 [id="node38" labelType="html" label="Generate number of output rows: 0" tooltip="Generate explode(_extract_demandChannelStreamKpiResults#1131385), [_extract_productId#1131383, _extract_plantId#1131384], false, [demandChannelStreamKpiResults#1131223]"]; 39 [id="node39" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131239.productId AS _extract_productId#1131383, prodPlantResults#1131239.plantId AS _extract_plantId#1131384, prodPlantResults#1131239.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#1131385]"]; 40 [id="node40" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((size(prodPlantResults#1131239.demandChannelStreamKpiResults, true) > 0) AND isnotnull(prodPlantResults#1131239.demandChannelStreamKpiResults))"]; } 41 [id="node41" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1131239], [(size(prodPlantResults#1131239.demandChannelStreamKpiResults, true) > 0), isnotnull(prodPlantResults#1131239.demandChannelStreamKpiResults)]"]; subgraph cluster42 { isCluster="true"; id="cluster42"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 43 [id="node43" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1131182), false, [prodPlantResults#1131189]"]; 44 [id="node44" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1131182]"]; 45 [id="node45" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1131182, true) > 0) AND isnotnull(prodPlantResults#1131182))"]; 46 [id="node46" labelType="html" label=" SerializeFromObject " tooltip="SerializeFromObject [mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement)))) null else named_struct(measuredUnit, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getMeasuredUnit()))), numberOfCalls, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getNumberOfCalls()), parent, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getParent()))), runtime, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getRuntime())), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getPerformanceMeasurements()), None) AS performanceMeasurements#1131181, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult)))) null else named_struct(demandChannelStreamKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult)))) null else named_struct(demandChannel, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandChannel()))), demandStream, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandStream()))), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getKpiResults()), None)), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getDemandChannelStreamKpiResults()), None), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getKpiResults()), None), plantId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getPlantId()))), productId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getProductId()))), quantityKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult)))) null else named_struct(kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getKpiResults()), None), quantity, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getQuantity())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getQuantityKpiResults()), None)), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getProdPlantResults()), None) AS prodPlantResults#1131182]"]; } 47 [id="node47" labelType="html" label=" Scan " tooltip="Scan[obj#1131178]"]; 48 [id="node48" labelType="html" label="BroadcastExchange time to broadcast: 0 ms time to build: 0 ms time to collect: 0 ms number of output rows: 0 data size: 0.0 B" tooltip="BroadcastExchange HashedRelationBroadcastMode(List(coalesce(input[2, string, true], ), isnull(input[2, string, true]), coalesce(input[3, string, true], ), isnull(input[3, string, true])),false), [plan_id=1756305]"]; subgraph cluster49 { isCluster="true"; id="cluster49"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 50 [id="node50" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 51 [id="node51" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1756301]"]; subgraph cluster52 { isCluster="true"; id="cluster52"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 53 [id="node53" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1100464)) AS qty#1100464, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 54 [id="node54" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]"]; 55 [id="node55" labelType="html" label="Filter number of output rows: 0" tooltip="Filter isNewlyCalculated#1128682: boolean"]; } 56 [id="node56" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [isNewlyCalculated#1128682, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L], [isNewlyCalculated#1128682]"]; 57 [id="node57" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster58 { isCluster="true"; id="cluster58"; label="WholeStageCodegen (5)"; tooltip="WholeStageCodegen (5)"; 59 [id="node59" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1128679, null AS demandStream#1128680, [] AS kpis#1128714, true AS isNewlyCalculated#1128682]"]; 60 [id="node60" labelType="html" label=" SortMergeJoin " tooltip="SortMergeJoin [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)], [coalesce(shardId#1128671, ), isnull(shardId#1128671), coalesce(worklistShardItemId#1128672L, 0), isnull(worklistShardItemId#1128672L), coalesce(version#1128673, 0), isnull(version#1128673), coalesce(product#1128674, ), isnull(product#1128674), coalesce(plant#1128675, ), isnull(plant#1128675), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))), isnull(qty#1128446)], LeftAnti"]; } subgraph cluster61 { isCluster="true"; id="cluster61"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 62 [id="node62" labelType="html" label=" Sort " tooltip="Sort [coalesce(shardId#1100457, ) ASC NULLS FIRST, isnull(shardId#1100457) ASC NULLS FIRST, coalesce(worklistShardItemId#1100458L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1100458L) ASC NULLS FIRST, coalesce(version#1100459, 0) ASC NULLS FIRST, isnull(version#1100459) ASC NULLS FIRST, coalesce(product#1100460, ) ASC NULLS FIRST, isnull(product#1100460) ASC NULLS FIRST, coalesce(plant#1100461, ) ASC NULLS FIRST, isnull(plant#1100461) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))) ASC NULLS FIRST, isnull(qty#1100464) ASC NULLS FIRST], false, 0"]; } 63 [id="node63" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464), 37), ENSURE_REQUIREMENTS, [plan_id=1755494]"]; 64 [id="node64" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]"]; 65 [id="node65" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1755264]"]; subgraph cluster66 { isCluster="true"; id="cluster66"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 67 [id="node67" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster68 { isCluster="true"; id="cluster68"; label="WholeStageCodegen (4)"; tooltip="WholeStageCodegen (4)"; 69 [id="node69" labelType="html" label=" Sort " tooltip="Sort [coalesce(shardId#1128671, ) ASC NULLS FIRST, isnull(shardId#1128671) ASC NULLS FIRST, coalesce(worklistShardItemId#1128672L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1128672L) ASC NULLS FIRST, coalesce(version#1128673, 0) ASC NULLS FIRST, isnull(version#1128673) ASC NULLS FIRST, coalesce(product#1128674, ) ASC NULLS FIRST, isnull(product#1128674) ASC NULLS FIRST, coalesce(plant#1128675, ) ASC NULLS FIRST, isnull(plant#1128675) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))) ASC NULLS FIRST, isnull(qty#1128446) ASC NULLS FIRST], false, 0"]; } 70 [id="node70" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(coalesce(shardId#1128671, ), isnull(shardId#1128671), coalesce(worklistShardItemId#1128672L, 0), isnull(worklistShardItemId#1128672L), coalesce(version#1128673, 0), isnull(version#1128673), coalesce(product#1128674, ), isnull(product#1128674), coalesce(plant#1128675, ), isnull(plant#1128675), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))), isnull(qty#1128446), 37), ENSURE_REQUIREMENTS, [plan_id=1755514]"]; 71 [id="node71" labelType="html" label=" Union " tooltip="Union"]; 72 [id="node72" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446]"]; subgraph cluster73 { isCluster="true"; id="cluster73"; label="WholeStageCodegen (7)"; tooltip="WholeStageCodegen (7)"; 74 [id="node74" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1128444 AS qty#1128446, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445 AS kpis#1128447]"]; 75 [id="node75" labelType="html" label=" SortMergeJoin " tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1128443L, cachedShardId#1128442], Inner"]; } subgraph cluster76 { isCluster="true"; id="cluster76"; label="WholeStageCodegen (4)"; tooltip="WholeStageCodegen (4)"; 77 [id="node77" labelType="html" label=" Sort " tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 78 [id="node78" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(worklistShardItemId#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1755382]"]; subgraph cluster79 { isCluster="true"; id="cluster79"; label="WholeStageCodegen (3)"; tooltip="WholeStageCodegen (3)"; 80 [id="node80" labelType="html" label=" HashAggregate " tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 81 [id="node81" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1755378]"]; subgraph cluster82 { isCluster="true"; id="cluster82"; label="WholeStageCodegen (2)"; tooltip="WholeStageCodegen (2)"; 83 [id="node83" labelType="html" label=" HashAggregate " tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 84 [id="node84" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 85 [id="node85" labelType="html" label=" BroadcastHashJoin " tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1128433L, cachedShardId#1128432], Inner, BuildLeft, ((qty#1100464 = cachedQty#1128434) OR isnull(qty#1100464)), false"]; 93 [id="node93" labelType="html" label=" Project " tooltip="Project [shardId#1128426 AS cachedShardId#1128432, worklistShardItemId#1128427L AS cachedWorklistShardItemId#1128433L, qty#1128428 AS cachedQty#1128434]"]; 94 [id="node94" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1128427L) AND isnotnull(shardId#1128426))"]; 95 [id="node95" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1128426,worklistShardItemId#1128427L,qty#1128428,demandChannel#1128429,demandStream#1128430,kpis#1128431]"]; } 86 [id="node86" labelType="html" label=" BroadcastExchange " tooltip="BroadcastExchange HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1755372]"]; subgraph cluster87 { isCluster="true"; id="cluster87"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 88 [id="node88" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 89 [id="node89" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 90 [id="node90" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1755264]"]; subgraph cluster91 { isCluster="true"; id="cluster91"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 92 [id="node92" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster96 { isCluster="true"; id="cluster96"; label="WholeStageCodegen (6)"; tooltip="WholeStageCodegen (6)"; 97 [id="node97" labelType="html" label=" Sort " tooltip="Sort [cachedWorklistShardItemId#1128443L ASC NULLS FIRST, cachedShardId#1128442 ASC NULLS FIRST], false, 0"]; } 98 [id="node98" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(cachedWorklistShardItemId#1128443L, cachedShardId#1128442, 37), ENSURE_REQUIREMENTS, [plan_id=1755388]"]; subgraph cluster99 { isCluster="true"; id="cluster99"; label="WholeStageCodegen (5)"; tooltip="WholeStageCodegen (5)"; 100 [id="node100" labelType="html" label=" Project " tooltip="Project [shardId#1128436 AS cachedShardId#1128442, worklistShardItemId#1128437L AS cachedWorklistShardItemId#1128443L, qty#1128438 AS cachedQty#1128444, demandChannel#1128439, demandStream#1128440, kpis#1128441 AS cachedKpis#1128445]"]; 101 [id="node101" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1128437L) AND isnotnull(shardId#1128436))"]; 102 [id="node102" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1128436,worklistShardItemId#1128437L,qty#1128438,demandChannel#1128439,demandStream#1128440,kpis#1128441]"]; } subgraph cluster103 { isCluster="true"; id="cluster103"; label="WholeStageCodegen (3)"; tooltip="WholeStageCodegen (3)"; 104 [id="node104" labelType="html" label=" Project " tooltip="Project [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660]"]; 105 [id="node105" labelType="html" label=" BroadcastHashJoin " tooltip="BroadcastHashJoin [worklistShardItemId#1128654L, shardId#1128653], [cachedWorklistShardItemId#1128668L, cachedShardId#1128667], Inner, BuildLeft, false"]; 113 [id="node113" labelType="html" label=" Project " tooltip="Project [shardId#1128661 AS cachedShardId#1128667, worklistShardItemId#1128662L AS cachedWorklistShardItemId#1128668L]"]; 114 [id="node114" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1128662L) AND isnotnull(shardId#1128661))"]; 115 [id="node115" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1128661,worklistShardItemId#1128662L,qty#1128663,demandChannel#1128664,demandStream#1128665,kpis#1128666]"]; } 106 [id="node106" labelType="html" label=" BroadcastExchange " tooltip="BroadcastExchange HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1755508]"]; subgraph cluster107 { isCluster="true"; id="cluster107"; label="WholeStageCodegen (2)"; tooltip="WholeStageCodegen (2)"; 108 [id="node108" labelType="html" label=" Filter " tooltip="Filter ((isnull(qty#1128660) AND isnotnull(worklistShardItemId#1128654L)) AND isnotnull(shardId#1128653))"]; } 109 [id="node109" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660], [isnull(qty#1128660), isnotnull(worklistShardItemId#1128654L), isnotnull(shardId#1128653)]"]; 110 [id="node110" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1755264]"]; subgraph cluster111 { isCluster="true"; id="cluster111"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 112 [id="node112" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster116 { isCluster="true"; id="cluster116"; label="WholeStageCodegen (6)"; tooltip="WholeStageCodegen (6)"; 117 [id="node117" labelType="html" label=" Project " tooltip="Project [shardId#1128684, worklistShardItemId#1128685L, version#1128686, product#1128687, plant#1128688, qty#1128712, demandChannel#1128705, demandStream#1128706, kpis#1128713, false AS isNewlyCalculated#1128683]"]; } 118 [id="node118" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [demandChannel#1128705, demandStream#1128706, kpis#1128713, plant#1128688, product#1128687, qty#1128712, shardId#1128684, version#1128686, worklistShardItemId#1128685L]"]; subgraph cluster119 { isCluster="true"; id="cluster119"; label="WholeStageCodegen (7)"; tooltip="WholeStageCodegen (7)"; 120 [id="node120" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1128444 AS qty#1128446, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445 AS kpis#1128447]"]; 121 [id="node121" labelType="html" label=" SortMergeJoin " tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1128443L, cachedShardId#1128442], Inner"]; } subgraph cluster122 { isCluster="true"; id="cluster122"; label="WholeStageCodegen (4)"; tooltip="WholeStageCodegen (4)"; 123 [id="node123" labelType="html" label=" Sort " tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 124 [id="node124" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(worklistShardItemId#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1755382]"]; subgraph cluster125 { isCluster="true"; id="cluster125"; label="WholeStageCodegen (3)"; tooltip="WholeStageCodegen (3)"; 126 [id="node126" labelType="html" label=" HashAggregate " tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 127 [id="node127" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1755378]"]; subgraph cluster128 { isCluster="true"; id="cluster128"; label="WholeStageCodegen (2)"; tooltip="WholeStageCodegen (2)"; 129 [id="node129" labelType="html" label=" HashAggregate " tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 130 [id="node130" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 131 [id="node131" labelType="html" label=" BroadcastHashJoin " tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1128433L, cachedShardId#1128432], Inner, BuildLeft, ((qty#1100464 = cachedQty#1128434) OR isnull(qty#1100464)), false"]; 139 [id="node139" labelType="html" label=" Project " tooltip="Project [shardId#1128426 AS cachedShardId#1128432, worklistShardItemId#1128427L AS cachedWorklistShardItemId#1128433L, qty#1128428 AS cachedQty#1128434]"]; 140 [id="node140" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1128427L) AND isnotnull(shardId#1128426))"]; 141 [id="node141" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1128426,worklistShardItemId#1128427L,qty#1128428,demandChannel#1128429,demandStream#1128430,kpis#1128431]"]; } 132 [id="node132" labelType="html" label=" BroadcastExchange " tooltip="BroadcastExchange HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1755372]"]; subgraph cluster133 { isCluster="true"; id="cluster133"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 134 [id="node134" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 135 [id="node135" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 136 [id="node136" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1755264]"]; subgraph cluster137 { isCluster="true"; id="cluster137"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 138 [id="node138" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster142 { isCluster="true"; id="cluster142"; label="WholeStageCodegen (6)"; tooltip="WholeStageCodegen (6)"; 143 [id="node143" labelType="html" label=" Sort " tooltip="Sort [cachedWorklistShardItemId#1128443L ASC NULLS FIRST, cachedShardId#1128442 ASC NULLS FIRST], false, 0"]; } 144 [id="node144" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(cachedWorklistShardItemId#1128443L, cachedShardId#1128442, 37), ENSURE_REQUIREMENTS, [plan_id=1755388]"]; subgraph cluster145 { isCluster="true"; id="cluster145"; label="WholeStageCodegen (5)"; tooltip="WholeStageCodegen (5)"; 146 [id="node146" labelType="html" label=" Project " tooltip="Project [shardId#1128436 AS cachedShardId#1128442, worklistShardItemId#1128437L AS cachedWorklistShardItemId#1128443L, qty#1128438 AS cachedQty#1128444, demandChannel#1128439, demandStream#1128440, kpis#1128441 AS cachedKpis#1128445]"]; 147 [id="node147" labelType="html" label=" Filter " tooltip="Filter (isnotnull(worklistShardItemId#1128437L) AND isnotnull(shardId#1128436))"]; 148 [id="node148" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1128436,worklistShardItemId#1128437L,qty#1128438,demandChannel#1128439,demandStream#1128440,kpis#1128441]"]; } 2->1; 4->2; 5->4; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 16->15; 17->16; 19->17; 20->19; 21->20; 22->21; 23->22; 24->15; 26->24; 27->26; 28->27; 29->28; 31->29; 32->31; 33->32; 34->33; 35->34; 36->15; 38->36; 39->38; 40->39; 41->40; 43->41; 44->43; 45->44; 46->45; 47->46; 48->14; 50->48; 51->50; 53->51; 54->53; 55->54; 56->55; 57->56; 59->57; 60->59; 62->60; 63->62; 64->63; 65->64; 67->65; 69->60; 70->69; 71->70; 72->71; 74->72; 75->74; 77->75; 78->77; 80->78; 81->80; 83->81; 84->83; 85->84; 86->85; 88->86; 89->88; 90->89; 92->90; 93->85; 94->93; 95->94; 97->75; 98->97; 100->98; 101->100; 102->101; 104->71; 105->104; 106->105; 108->106; 109->108; 110->109; 112->110; 113->105; 114->113; 115->114; 117->57; 118->117; 120->118; 121->120; 123->121; 124->123; 126->124; 127->126; 129->127; 130->129; 131->130; 132->131; 134->132; 135->134; 136->135; 138->136; 139->131; 140->139; 141->140; 143->121; 144->143; 146->144; 147->146; 148->147; }

Details

== Physical Plan ==
* HashAggregate (88)
+- Exchange (87)
   +- * HashAggregate (86)
      +- InMemoryTableScan (1)
            +- InMemoryRelation (2)
                  +- SortAggregate (85)
                     +- * Sort (84)
                        +- Exchange (83)
                           +- SortAggregate (82)
                              +- * Sort (81)
                                 +- * Project (80)
                                    +- * BroadcastHashJoin Inner BuildRight (79)
                                       :- Union (23)
                                       :  :- Project (10)
                                       :  :  +- InMemoryTableScan (3)
                                       :  :        +- InMemoryRelation (4)
                                       :  :              +- * Generate (9)
                                       :  :                 +- * Project (8)
                                       :  :                    +- * Filter (7)
                                       :  :                       +- * SerializeFromObject (6)
                                       :  :                          +- Scan (5)
                                       :  :- Project (16)
                                       :  :  +- * Generate (15)
                                       :  :     +- * Project (14)
                                       :  :        +- * Filter (13)
                                       :  :           +- InMemoryTableScan (11)
                                       :  :                 +- InMemoryRelation (12)
                                       :  :                       +- * Generate (9)
                                       :  :                          +- * Project (8)
                                       :  :                             +- * Filter (7)
                                       :  :                                +- * SerializeFromObject (6)
                                       :  :                                   +- Scan (5)
                                       :  +- Project (22)
                                       :     +- * Generate (21)
                                       :        +- * Project (20)
                                       :           +- * Filter (19)
                                       :              +- InMemoryTableScan (17)
                                       :                    +- InMemoryRelation (18)
                                       :                          +- * Generate (9)
                                       :                             +- * Project (8)
                                       :                                +- * Filter (7)
                                       :                                   +- * SerializeFromObject (6)
                                       :                                      +- Scan (5)
                                       +- BroadcastExchange (78)
                                          +- * HashAggregate (77)
                                             +- Exchange (76)
                                                +- * HashAggregate (75)
                                                   +- * Project (74)
                                                      +- * Filter (73)
                                                         +- InMemoryTableScan (24)
                                                               +- InMemoryRelation (25)
                                                                     +- Union (72)
                                                                        :- * Project (68)
                                                                        :  +- * SortMergeJoin LeftAnti (67)
                                                                        :     :- * Sort (31)
                                                                        :     :  +- Exchange (30)
                                                                        :     :     +- InMemoryTableScan (26)
                                                                        :     :           +- InMemoryRelation (27)
                                                                        :     :                 +- Exchange (29)
                                                                        :     :                    +- * Scan ExistingRDD (28)
                                                                        :     +- * Sort (66)
                                                                        :        +- Exchange (65)
                                                                        :           +- Union (64)
                                                                        :              :- InMemoryTableScan (32)
                                                                        :              :     +- InMemoryRelation (33)
                                                                        :              :           +- * Project (54)
                                                                        :              :              +- * SortMergeJoin Inner (53)
                                                                        :              :                 :- * Sort (47)
                                                                        :              :                 :  +- Exchange (46)
                                                                        :              :                 :     +- * HashAggregate (45)
                                                                        :              :                 :        +- Exchange (44)
                                                                        :              :                 :           +- * HashAggregate (43)
                                                                        :              :                 :              +- * Project (42)
                                                                        :              :                 :                 +- * BroadcastHashJoin Inner BuildLeft (41)
                                                                        :              :                 :                    :- BroadcastExchange (37)
                                                                        :              :                 :                    :  +- * Filter (36)
                                                                        :              :                 :                    :     +- InMemoryTableScan (34)
                                                                        :              :                 :                    :           +- InMemoryRelation (35)
                                                                        :              :                 :                    :                 +- Exchange (29)
                                                                        :              :                 :                    :                    +- * Scan ExistingRDD (28)
                                                                        :              :                 :                    +- * Project (40)
                                                                        :              :                 :                       +- * Filter (39)
                                                                        :              :                 :                          +- * Scan ExistingRDD (38)
                                                                        :              :                 +- * Sort (52)
                                                                        :              :                    +- Exchange (51)
                                                                        :              :                       +- * Project (50)
                                                                        :              :                          +- * Filter (49)
                                                                        :              :                             +- * Scan ExistingRDD (48)
                                                                        :              +- * Project (63)
                                                                        :                 +- * BroadcastHashJoin Inner BuildLeft (62)
                                                                        :                    :- BroadcastExchange (58)
                                                                        :                    :  +- * Filter (57)
                                                                        :                    :     +- InMemoryTableScan (55)
                                                                        :                    :           +- InMemoryRelation (56)
                                                                        :                    :                 +- Exchange (29)
                                                                        :                    :                    +- * Scan ExistingRDD (28)
                                                                        :                    +- * Project (61)
                                                                        :                       +- * Filter (60)
                                                                        :                          +- * Scan ExistingRDD (59)
                                                                        +- * Project (71)
                                                                           +- InMemoryTableScan (69)
                                                                                 +- InMemoryRelation (70)
                                                                                       +- * Project (54)
                                                                                          +- * SortMergeJoin Inner (53)
                                                                                             :- * Sort (47)
                                                                                             :  +- Exchange (46)
                                                                                             :     +- * HashAggregate (45)
                                                                                             :        +- Exchange (44)
                                                                                             :           +- * HashAggregate (43)
                                                                                             :              +- * Project (42)
                                                                                             :                 +- * BroadcastHashJoin Inner BuildLeft (41)
                                                                                             :                    :- BroadcastExchange (37)
                                                                                             :                    :  +- * Filter (36)
                                                                                             :                    :     +- InMemoryTableScan (34)
                                                                                             :                    :           +- InMemoryRelation (35)
                                                                                             :                    :                 +- Exchange (29)
                                                                                             :                    :                    +- * Scan ExistingRDD (28)
                                                                                             :                    +- * Project (40)
                                                                                             :                       +- * Filter (39)
                                                                                             :                          +- * Scan ExistingRDD (38)
                                                                                             +- * Sort (52)
                                                                                                +- Exchange (51)
                                                                                                   +- * Project (50)
                                                                                                      +- * Filter (49)
                                                                                                         +- * Scan ExistingRDD (48)


(1) InMemoryTableScan
Output [1]: [shardId#1100457]
Arguments: [shardId#1100457]

(2) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244], StorageLevel(disk, memory, 2 replicas)

(3) InMemoryTableScan
Output [1]: [prodPlantResults#1131189]
Arguments: [prodPlantResults#1131189]

(4) InMemoryRelation
Arguments: [prodPlantResults#1131189], StorageLevel(disk, memory, 2 replicas)

(5) Scan
Output [1]: [obj#1131178]
Arguments: obj#1131178: com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, MapPartitionsRDD[56302] at start at FileStorageAdapterImpl.java:171

(6) SerializeFromObject [codegen id : 1]
Input [1]: [obj#1131178]
Arguments: [mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement)))) null else named_struct(measuredUnit, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getMeasuredUnit()))), numberOfCalls, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getNumberOfCalls()), parent, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getParent()))), runtime, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -1), StructField(measuredUnit,StringType,true), StructField(numberOfCalls,LongType,false), StructField(parent,StringType,true), StructField(runtime,LongType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.PerformanceMeasurement))).getRuntime())), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getPerformanceMeasurements()), None) AS performanceMeasurements#1131181, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult)))) null else named_struct(demandChannelStreamKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult)))) null else named_struct(demandChannel, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandChannel()))), demandStream, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getDemandStream()))), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -4), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -3), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.DemandChannelStreamKpiResult))).getKpiResults()), None)), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getDemandChannelStreamKpiResults()), None), kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -5), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getKpiResults()), None), plantId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getPlantId()))), productId, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getProductId()))), quantityKpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult)))) null else named_struct(kpiResults, mapobjects(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), if (isnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult)))) null else named_struct(datetime, static_invoke(DateTimeUtils.fromJavaTimestamp(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getDatetime()))), label, static_invoke(UTF8String.fromString(invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getLabel()))), value, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -7), StructField(datetime,TimestampType,true), StructField(label,StringType,true), StructField(value,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiResult))).getValue())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getKpiResults()), None), quantity, invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -6), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(quantity,DoubleType,false), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.QuantityKpiResult))).getQuantity())), invoke(knownnotnull(validateexternaltype(lambdavariable(MapObject, ObjectType(class java.lang.Object), true, -2), StructField(demandChannelStreamKpiResults,ArrayType(StructType(StructField(demandChannel,StringType,true),StructField(demandStream,StringType,true),StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true)),true),true), StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true), StructField(plantId,StringType,true), StructField(productId,StringType,true), StructField(quantityKpiResults,ArrayType(StructType(StructField(kpiResults,ArrayType(StructType(StructField(datetime,TimestampType,true),StructField(label,StringType,true),StructField(value,DoubleType,false)),true),true),StructField(quantity,DoubleType,false)),true),true), ObjectType(class com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.ProdPlantKpiCalculationResult))).getQuantityKpiResults()), None)), invoke(knownnotnull(assertnotnull(input[0, com.sap.s4hana.eureka.business.crporderquantitykpicalculation.dto.KpiCalculationResult, true])).getProdPlantResults()), None) AS prodPlantResults#1131182]

(7) Filter [codegen id : 1]
Input [2]: [performanceMeasurements#1131181, prodPlantResults#1131182]
Condition : ((size(prodPlantResults#1131182, true) > 0) AND isnotnull(prodPlantResults#1131182))

(8) Project [codegen id : 1]
Output [1]: [prodPlantResults#1131182]
Input [2]: [performanceMeasurements#1131181, prodPlantResults#1131182]

(9) Generate [codegen id : 1]
Input [1]: [prodPlantResults#1131182]
Arguments: explode(prodPlantResults#1131182), false, [prodPlantResults#1131189]

(10) Project
Output [6]: [prodPlantResults#1131189.productId AS product#1131208, prodPlantResults#1131189.plantId AS plant#1131209, null AS qty#1131235, null AS demandChannel#1131215, null AS demandStream#1131216, transform(prodPlantResults#1131189.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131244]
Input [1]: [prodPlantResults#1131189]

(11) InMemoryTableScan
Output [1]: [prodPlantResults#1131234]
Arguments: [prodPlantResults#1131234], [(size(prodPlantResults#1131234.quantityKpiResults, true) > 0), isnotnull(prodPlantResults#1131234.quantityKpiResults)]

(12) InMemoryRelation
Arguments: [prodPlantResults#1131234], StorageLevel(disk, memory, 2 replicas)

(13) Filter [codegen id : 1]
Input [1]: [prodPlantResults#1131234]
Condition : ((size(prodPlantResults#1131234.quantityKpiResults, true) > 0) AND isnotnull(prodPlantResults#1131234.quantityKpiResults))

(14) Project [codegen id : 1]
Output [3]: [prodPlantResults#1131234.productId AS _extract_productId#1131380, prodPlantResults#1131234.plantId AS _extract_plantId#1131381, prodPlantResults#1131234.quantityKpiResults AS _extract_quantityKpiResults#1131382]
Input [1]: [prodPlantResults#1131234]

(15) Generate [codegen id : 1]
Input [3]: [_extract_productId#1131380, _extract_plantId#1131381, _extract_quantityKpiResults#1131382]
Arguments: explode(_extract_quantityKpiResults#1131382), [_extract_productId#1131380, _extract_plantId#1131381], false, [quantityKpiResults#1131201]

(16) Project
Output [6]: [_extract_productId#1131380 AS product#1131195, _extract_plantId#1131381 AS plant#1131196, quantityKpiResults#1131201.quantity AS qty#1131202, null AS demandChannel#1131204, null AS demandStream#1131205, transform(quantityKpiResults#1131201.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131378]
Input [3]: [_extract_productId#1131380, _extract_plantId#1131381, quantityKpiResults#1131201]

(17) InMemoryTableScan
Output [1]: [prodPlantResults#1131239]
Arguments: [prodPlantResults#1131239], [(size(prodPlantResults#1131239.demandChannelStreamKpiResults, true) > 0), isnotnull(prodPlantResults#1131239.demandChannelStreamKpiResults)]

(18) InMemoryRelation
Arguments: [prodPlantResults#1131239], StorageLevel(disk, memory, 2 replicas)

(19) Filter [codegen id : 2]
Input [1]: [prodPlantResults#1131239]
Condition : ((size(prodPlantResults#1131239.demandChannelStreamKpiResults, true) > 0) AND isnotnull(prodPlantResults#1131239.demandChannelStreamKpiResults))

(20) Project [codegen id : 2]
Output [3]: [prodPlantResults#1131239.productId AS _extract_productId#1131383, prodPlantResults#1131239.plantId AS _extract_plantId#1131384, prodPlantResults#1131239.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#1131385]
Input [1]: [prodPlantResults#1131239]

(21) Generate [codegen id : 2]
Input [3]: [_extract_productId#1131383, _extract_plantId#1131384, _extract_demandChannelStreamKpiResults#1131385]
Arguments: explode(_extract_demandChannelStreamKpiResults#1131385), [_extract_productId#1131383, _extract_plantId#1131384], false, [demandChannelStreamKpiResults#1131223]

(22) Project
Output [6]: [_extract_productId#1131383 AS product#1131217, _extract_plantId#1131384 AS plant#1131218, null AS qty#1131240, demandChannelStreamKpiResults#1131223.demandChannel AS demandChannel#1131225, demandChannelStreamKpiResults#1131223.demandStream AS demandStream#1131227, transform(demandChannelStreamKpiResults#1131223.kpiResults, lambdafunction(struct(label, lambda kpi#1131245.label, dateTime, lambda kpi#1131245.datetime, value, lambda kpi#1131245.value), lambda kpi#1131245, false)) AS kpis#1131379]
Input [3]: [_extract_productId#1131383, _extract_plantId#1131384, demandChannelStreamKpiResults#1131223]

(23) Union

(24) InMemoryTableScan
Output [6]: [isNewlyCalculated#1128682, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]
Arguments: [isNewlyCalculated#1128682, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L], [isNewlyCalculated#1128682]

(25) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, demandChannel#1128679, demandStream#1128680, kpis#1128714, isNewlyCalculated#1128682], StorageLevel(disk, memory, 2 replicas)

(26) InMemoryTableScan
Output [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]

(27) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, periodStart#1100462, periodEnd#1100463, qty#1100464], StorageLevel(disk, memory, 2 replicas)

(28) Scan ExistingRDD [codegen id : 1]
Output [8]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, periodStart#1100462, periodEnd#1100463, qty#1100464]
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, periodStart#1100462, periodEnd#1100463, qty#1100464], SQLExecutionRDD[56160] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(29) Exchange
Input [8]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, periodStart#1100462, periodEnd#1100463, qty#1100464]
Arguments: hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1755264]

(30) Exchange
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Arguments: hashpartitioning(coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464), 37), ENSURE_REQUIREMENTS, [plan_id=1755494]

(31) Sort [codegen id : 1]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Arguments: [coalesce(shardId#1100457, ) ASC NULLS FIRST, isnull(shardId#1100457) ASC NULLS FIRST, coalesce(worklistShardItemId#1100458L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1100458L) ASC NULLS FIRST, coalesce(version#1100459, 0) ASC NULLS FIRST, isnull(version#1100459) ASC NULLS FIRST, coalesce(product#1100460, ) ASC NULLS FIRST, isnull(product#1100460) ASC NULLS FIRST, coalesce(plant#1100461, ) ASC NULLS FIRST, isnull(plant#1100461) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))) ASC NULLS FIRST, isnull(qty#1100464) ASC NULLS FIRST], false, 0

(32) InMemoryTableScan
Output [6]: [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446]
Arguments: [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446]

(33) InMemoryRelation
Arguments: [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446, demandChannel#1128439, demandStream#1128440, kpis#1128447], StorageLevel(disk, memory, 2 replicas)

(34) InMemoryTableScan
Output [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]

(35) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, periodStart#1100462, periodEnd#1100463, qty#1100464], StorageLevel(disk, memory, 2 replicas)

(36) Filter [codegen id : 1]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Condition : (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))

(37) BroadcastExchange
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]
Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1755372]

(38) Scan ExistingRDD
Output [6]: [shardId#1128426, worklistShardItemId#1128427L, qty#1128428, demandChannel#1128429, demandStream#1128430, kpis#1128431]
Arguments: [shardId#1128426, worklistShardItemId#1128427L, qty#1128428, demandChannel#1128429, demandStream#1128430, kpis#1128431], MapPartitionsRDD[56182] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(39) Filter
Input [6]: [shardId#1128426, worklistShardItemId#1128427L, qty#1128428, demandChannel#1128429, demandStream#1128430, kpis#1128431]
Condition : (isnotnull(worklistShardItemId#1128427L) AND isnotnull(shardId#1128426))

(40) Project
Output [3]: [shardId#1128426 AS cachedShardId#1128432, worklistShardItemId#1128427L AS cachedWorklistShardItemId#1128433L, qty#1128428 AS cachedQty#1128434]
Input [6]: [shardId#1128426, worklistShardItemId#1128427L, qty#1128428, demandChannel#1128429, demandStream#1128430, kpis#1128431]

(41) BroadcastHashJoin [codegen id : 2]
Left keys [2]: [worklistShardItemId#1100458L, shardId#1100457]
Right keys [2]: [cachedWorklistShardItemId#1128433L, cachedShardId#1128432]
Join type: Inner
Join condition: ((qty#1100464 = cachedQty#1128434) OR isnull(qty#1100464))

(42) Project [codegen id : 2]
Output [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]
Input [9]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, cachedShardId#1128432, cachedWorklistShardItemId#1128433L, cachedQty#1128434]

(43) HashAggregate [codegen id : 2]
Input [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]
Keys [5]: [plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460]
Functions: []
Aggregate Attributes: []
Results [5]: [plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460]

(44) Exchange
Input [5]: [plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460]
Arguments: hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1755378]

(45) HashAggregate [codegen id : 3]
Input [5]: [plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460]
Keys [5]: [plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460]
Functions: []
Aggregate Attributes: []
Results [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]

(46) Exchange
Input [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]
Arguments: hashpartitioning(worklistShardItemId#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1755382]

(47) Sort [codegen id : 4]
Input [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]
Arguments: [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0

(48) Scan ExistingRDD [codegen id : 5]
Output [6]: [shardId#1128436, worklistShardItemId#1128437L, qty#1128438, demandChannel#1128439, demandStream#1128440, kpis#1128441]
Arguments: [shardId#1128436, worklistShardItemId#1128437L, qty#1128438, demandChannel#1128439, demandStream#1128440, kpis#1128441], MapPartitionsRDD[56182] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(49) Filter [codegen id : 5]
Input [6]: [shardId#1128436, worklistShardItemId#1128437L, qty#1128438, demandChannel#1128439, demandStream#1128440, kpis#1128441]
Condition : (isnotnull(worklistShardItemId#1128437L) AND isnotnull(shardId#1128436))

(50) Project [codegen id : 5]
Output [6]: [shardId#1128436 AS cachedShardId#1128442, worklistShardItemId#1128437L AS cachedWorklistShardItemId#1128443L, qty#1128438 AS cachedQty#1128444, demandChannel#1128439, demandStream#1128440, kpis#1128441 AS cachedKpis#1128445]
Input [6]: [shardId#1128436, worklistShardItemId#1128437L, qty#1128438, demandChannel#1128439, demandStream#1128440, kpis#1128441]

(51) Exchange
Input [6]: [cachedShardId#1128442, cachedWorklistShardItemId#1128443L, cachedQty#1128444, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445]
Arguments: hashpartitioning(cachedWorklistShardItemId#1128443L, cachedShardId#1128442, 37), ENSURE_REQUIREMENTS, [plan_id=1755388]

(52) Sort [codegen id : 6]
Input [6]: [cachedShardId#1128442, cachedWorklistShardItemId#1128443L, cachedQty#1128444, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445]
Arguments: [cachedWorklistShardItemId#1128443L ASC NULLS FIRST, cachedShardId#1128442 ASC NULLS FIRST], false, 0

(53) SortMergeJoin [codegen id : 7]
Left keys [2]: [worklistShardItemId#1100458L, shardId#1100457]
Right keys [2]: [cachedWorklistShardItemId#1128443L, cachedShardId#1128442]
Join type: Inner
Join condition: None

(54) Project [codegen id : 7]
Output [9]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1128444 AS qty#1128446, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445 AS kpis#1128447]
Input [11]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedShardId#1128442, cachedWorklistShardItemId#1128443L, cachedQty#1128444, demandChannel#1128439, demandStream#1128440, cachedKpis#1128445]

(55) InMemoryTableScan
Output [6]: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660]
Arguments: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660], [isnull(qty#1128660), isnotnull(worklistShardItemId#1128654L), isnotnull(shardId#1128653)]

(56) InMemoryRelation
Arguments: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, periodStart#1128658, periodEnd#1128659, qty#1128660], StorageLevel(disk, memory, 2 replicas)

(57) Filter [codegen id : 2]
Input [6]: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660]
Condition : ((isnull(qty#1128660) AND isnotnull(worklistShardItemId#1128654L)) AND isnotnull(shardId#1128653))

(58) BroadcastExchange
Input [6]: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660]
Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1755508]

(59) Scan ExistingRDD
Output [6]: [shardId#1128661, worklistShardItemId#1128662L, qty#1128663, demandChannel#1128664, demandStream#1128665, kpis#1128666]
Arguments: [shardId#1128661, worklistShardItemId#1128662L, qty#1128663, demandChannel#1128664, demandStream#1128665, kpis#1128666], MapPartitionsRDD[56182] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(60) Filter
Input [6]: [shardId#1128661, worklistShardItemId#1128662L, qty#1128663, demandChannel#1128664, demandStream#1128665, kpis#1128666]
Condition : (isnotnull(worklistShardItemId#1128662L) AND isnotnull(shardId#1128661))

(61) Project
Output [2]: [shardId#1128661 AS cachedShardId#1128667, worklistShardItemId#1128662L AS cachedWorklistShardItemId#1128668L]
Input [6]: [shardId#1128661, worklistShardItemId#1128662L, qty#1128663, demandChannel#1128664, demandStream#1128665, kpis#1128666]

(62) BroadcastHashJoin [codegen id : 3]
Left keys [2]: [worklistShardItemId#1128654L, shardId#1128653]
Right keys [2]: [cachedWorklistShardItemId#1128668L, cachedShardId#1128667]
Join type: Inner
Join condition: None

(63) Project [codegen id : 3]
Output [6]: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660]
Input [8]: [shardId#1128653, worklistShardItemId#1128654L, version#1128655, product#1128656, plant#1128657, qty#1128660, cachedShardId#1128667, cachedWorklistShardItemId#1128668L]

(64) Union

(65) Exchange
Input [6]: [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446]
Arguments: hashpartitioning(coalesce(shardId#1128671, ), isnull(shardId#1128671), coalesce(worklistShardItemId#1128672L, 0), isnull(worklistShardItemId#1128672L), coalesce(version#1128673, 0), isnull(version#1128673), coalesce(product#1128674, ), isnull(product#1128674), coalesce(plant#1128675, ), isnull(plant#1128675), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))), isnull(qty#1128446), 37), ENSURE_REQUIREMENTS, [plan_id=1755514]

(66) Sort [codegen id : 4]
Input [6]: [shardId#1128671, worklistShardItemId#1128672L, version#1128673, product#1128674, plant#1128675, qty#1128446]
Arguments: [coalesce(shardId#1128671, ) ASC NULLS FIRST, isnull(shardId#1128671) ASC NULLS FIRST, coalesce(worklistShardItemId#1128672L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1128672L) ASC NULLS FIRST, coalesce(version#1128673, 0) ASC NULLS FIRST, isnull(version#1128673) ASC NULLS FIRST, coalesce(product#1128674, ) ASC NULLS FIRST, isnull(product#1128674) ASC NULLS FIRST, coalesce(plant#1128675, ) ASC NULLS FIRST, isnull(plant#1128675) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))) ASC NULLS FIRST, isnull(qty#1128446) ASC NULLS FIRST], false, 0

(67) SortMergeJoin [codegen id : 5]
Left keys [12]: [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)]
Right keys [12]: [coalesce(shardId#1128671, ), isnull(shardId#1128671), coalesce(worklistShardItemId#1128672L, 0), isnull(worklistShardItemId#1128672L), coalesce(version#1128673, 0), isnull(version#1128673), coalesce(product#1128674, ), isnull(product#1128674), coalesce(plant#1128675, ), isnull(plant#1128675), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1128446, 0.0))), isnull(qty#1128446)]
Join type: LeftAnti
Join condition: None

(68) Project [codegen id : 5]
Output [10]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1128679, null AS demandStream#1128680, [] AS kpis#1128714, true AS isNewlyCalculated#1128682]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]

(69) InMemoryTableScan
Output [9]: [demandChannel#1128705, demandStream#1128706, kpis#1128713, plant#1128688, product#1128687, qty#1128712, shardId#1128684, version#1128686, worklistShardItemId#1128685L]
Arguments: [demandChannel#1128705, demandStream#1128706, kpis#1128713, plant#1128688, product#1128687, qty#1128712, shardId#1128684, version#1128686, worklistShardItemId#1128685L]

(70) InMemoryRelation
Arguments: [shardId#1128684, worklistShardItemId#1128685L, version#1128686, product#1128687, plant#1128688, qty#1128712, demandChannel#1128705, demandStream#1128706, kpis#1128713], StorageLevel(disk, memory, 2 replicas)

(71) Project [codegen id : 6]
Output [10]: [shardId#1128684, worklistShardItemId#1128685L, version#1128686, product#1128687, plant#1128688, qty#1128712, demandChannel#1128705, demandStream#1128706, kpis#1128713, false AS isNewlyCalculated#1128683]
Input [9]: [demandChannel#1128705, demandStream#1128706, kpis#1128713, plant#1128688, product#1128687, qty#1128712, shardId#1128684, version#1128686, worklistShardItemId#1128685L]

(72) Union

(73) Filter [codegen id : 3]
Input [6]: [isNewlyCalculated#1128682, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]
Condition : isNewlyCalculated#1128682

(74) Project [codegen id : 3]
Output [5]: [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]
Input [6]: [isNewlyCalculated#1128682, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]

(75) HashAggregate [codegen id : 3]
Input [5]: [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]
Keys [5]: [plant#1100461, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1100464)) AS qty#1100464, worklistShardItemId#1100458L, product#1100460]
Functions: []
Aggregate Attributes: []
Results [5]: [plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460]

(76) Exchange
Input [5]: [plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460]
Arguments: hashpartitioning(plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1756301]

(77) HashAggregate [codegen id : 4]
Input [5]: [plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460]
Keys [5]: [plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460]
Functions: []
Aggregate Attributes: []
Results [5]: [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]

(78) BroadcastExchange
Input [5]: [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]
Arguments: HashedRelationBroadcastMode(List(coalesce(input[2, string, true], ), isnull(input[2, string, true]), coalesce(input[3, string, true], ), isnull(input[3, string, true])),false), [plan_id=1756305]

(79) BroadcastHashJoin [codegen id : 5]
Left keys [4]: [coalesce(product#1131208, ), isnull(product#1131208), coalesce(plant#1131209, ), isnull(plant#1131209)]
Right keys [4]: [coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461)]
Join type: Inner
Join condition: ((qty#1131235 <=> qty#1100464) OR isnull(qty#1100464))

(80) Project [codegen id : 5]
Output [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244]
Input [11]: [product#1131208, plant#1131209, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244, shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]

(81) Sort [codegen id : 5]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244]
Arguments: [demandChannel#1131215 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#1131235)) AS qty#1131235 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1131216 ASC NULLS FIRST], false, 0

(82) SortAggregate
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, kpis#1131244]
Keys [5]: [demandChannel#1131215, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1131235)) AS qty#1131235, worklistShardItemId#1100458L, demandStream#1131216]
Functions [1]: [partial_first(kpis#1131244, false)]
Aggregate Attributes [2]: [first#1131451, valueSet#1131452]
Results [7]: [demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, first#1131453, valueSet#1131454]

(83) Exchange
Input [7]: [demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, first#1131453, valueSet#1131454]
Arguments: hashpartitioning(demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, 37), ENSURE_REQUIREMENTS, [plan_id=1756312]

(84) Sort [codegen id : 6]
Input [7]: [demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, first#1131453, valueSet#1131454]
Arguments: [demandChannel#1131215 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, qty#1131235 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1131216 ASC NULLS FIRST], false, 0

(85) SortAggregate
Input [7]: [demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216, first#1131453, valueSet#1131454]
Keys [5]: [demandChannel#1131215, shardId#1100457, qty#1131235, worklistShardItemId#1100458L, demandStream#1131216]
Functions [1]: [first(kpis#1131244, false)]
Aggregate Attributes [1]: [first(kpis#1131244)()#1131376]
Results [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1131235, demandChannel#1131215, demandStream#1131216, first(kpis#1131244)()#1131376 AS kpis#1131377]

(86) HashAggregate [codegen id : 1]
Input [1]: [shardId#1100457]
Keys [1]: [shardId#1100457]
Functions: []
Aggregate Attributes: []
Results [1]: [shardId#1100457]

(87) Exchange
Input [1]: [shardId#1100457]
Arguments: hashpartitioning(shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1756401]

(88) HashAggregate [codegen id : 2]
Input [1]: [shardId#1100457]
Keys [1]: [shardId#1100457]
Functions: []
Aggregate Attributes: []
Results [1]: [shardId#1100457]

SQL / DataFrame Properties

Name	Value
spark.activity.hdlfsEnabled	true
spark.activity.isolateSession	true
spark.databricks.delta.lastCommitVersionInSession	3
spark.sql.adaptive.enabled	false
spark.sql.cbo.enabled	false
spark.sql.parquet.fieldId.read.enabled	true
spark.sql.parquet.fieldId.write.enabled	true
spark.sql.requireAllClusterKeysForDistribution	false
temporal.activity.id	2fe7819b-828a-3eaa-98c4-d5f04113b6b3
temporal.activity.type	RunStreamWithId