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

Submitted Time: 2026/03/20 06:00:15
Duration: 0.8 s
Succeeded Jobs: 5609

Plan Visualization

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

digraph G { 0 [id="node0" labelType="html" label=" DeserializeToObject " tooltip="DeserializeToObject createexternalrow(invoke(shardId#943631.toString()), static_invoke(java.lang.Long.valueOf(worklistShardItemId#943632L)), static_invoke(java.lang.Double.valueOf(qty#964850)), invoke(demandChannel#964830.toString()), invoke(demandStream#964831.toString()), mapobjects(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1), createexternalrow(invoke(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).label.toString()), static_invoke(DateTimeUtils.toJavaTimestamp(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).dateTime)), static_invoke(java.lang.Double.valueOf(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).value)), StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true)), kpis#964859, Some(class scala.collection.mutable.ArraySeq)), StructField(shardId,StringType,true), StructField(worklistShardItemId,LongType,true), StructField(qty,DoubleType,true), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpis,ArrayType(StructType(StructField(label,StringType,true),StructField(dateTime,TimestampType,true),StructField(value,DoubleType,true)),false),true)), obj#965179: org.apache.spark.sql.Row"]; 1 [id="node1" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]"]; 2 [id="node2" labelType="html" label=" SortAggregate " tooltip="SortAggregate(key=[demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831], functions=[first(kpis#964859, false)])"]; subgraph cluster3 { isCluster="true"; id="cluster3"; label="WholeStageCodegen (6)"; tooltip="WholeStageCodegen (6)"; 4 [id="node4" labelType="html" label=" Sort " tooltip="Sort [demandChannel#964830 ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST, qty#964850 ASC NULLS FIRST, worklistShardItemId#943632L ASC NULLS FIRST, demandStream#964831 ASC NULLS FIRST], false, 0"]; } 5 [id="node5" labelType="html" label="Exchange number of partitions: 37" tooltip="Exchange hashpartitioning(demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, 37), ENSURE_REQUIREMENTS, [plan_id=1620191]"]; 6 [id="node6" labelType="html" label=" SortAggregate " tooltip="SortAggregate(key=[demandChannel#964830, shardId#943631, knownfloatingpointnormalized(normalizenanandzero(qty#964850)) AS qty#964850, worklistShardItemId#943632L, demandStream#964831], functions=[partial_first(kpis#964859, false)])"]; subgraph cluster7 { isCluster="true"; id="cluster7"; label="WholeStageCodegen (5)"; tooltip="WholeStageCodegen (5)"; 8 [id="node8" labelType="html" label=" Sort " tooltip="Sort [demandChannel#964830 ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#964850)) AS qty#964850 ASC NULLS FIRST, worklistShardItemId#943632L ASC NULLS FIRST, demandStream#964831 ASC NULLS FIRST], false, 0"]; 9 [id="node9" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]"]; 10 [id="node10" labelType="html" label=" BroadcastHashJoin " tooltip="BroadcastHashJoin [coalesce(product#964823, ), isnull(product#964823), coalesce(plant#964824, ), isnull(plant#964824)], [coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635)], Inner, BuildRight, ((qty#964850 <=> qty#943638) OR isnull(qty#943638)), false"]; } 11 [id="node11" labelType="html" label=" Union " tooltip="Union"]; 12 [id="node12" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964804.productId AS product#964823, prodPlantResults#964804.plantId AS plant#964824, null AS qty#964850, null AS demandChannel#964830, null AS demandStream#964831, transform(prodPlantResults#964804.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964859]"]; 13 [id="node13" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [prodPlantResults#964804]"]; subgraph cluster14 { isCluster="true"; id="cluster14"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 15 [id="node15" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#964797), false, [prodPlantResults#964804]"]; 16 [id="node16" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964797]"]; 17 [id="node17" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#964797, true) > 0) AND isnotnull(prodPlantResults#964797))"]; 18 [id="node18" 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#964796, 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#964797]"]; } 19 [id="node19" labelType="html" label=" Scan " tooltip="Scan[obj#964793]"]; 20 [id="node20" labelType="html" label=" Project " tooltip="Project [_extract_productId#964995 AS product#964810, _extract_plantId#964996 AS plant#964811, quantityKpiResults#964816.quantity AS qty#964817, null AS demandChannel#964819, null AS demandStream#964820, transform(quantityKpiResults#964816.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964993]"]; subgraph cluster21 { isCluster="true"; id="cluster21"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 22 [id="node22" labelType="html" label=" Generate " tooltip="Generate explode(_extract_quantityKpiResults#964997), [_extract_productId#964995, _extract_plantId#964996], false, [quantityKpiResults#964816]"]; 23 [id="node23" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964849.productId AS _extract_productId#964995, prodPlantResults#964849.plantId AS _extract_plantId#964996, prodPlantResults#964849.quantityKpiResults AS _extract_quantityKpiResults#964997]"]; 24 [id="node24" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#964849.quantityKpiResults, true) > 0) AND isnotnull(prodPlantResults#964849.quantityKpiResults))"]; } 25 [id="node25" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [prodPlantResults#964849], [(size(prodPlantResults#964849.quantityKpiResults, true) > 0), isnotnull(prodPlantResults#964849.quantityKpiResults)]"]; subgraph cluster26 { isCluster="true"; id="cluster26"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 27 [id="node27" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#964797), false, [prodPlantResults#964804]"]; 28 [id="node28" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964797]"]; 29 [id="node29" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#964797, true) > 0) AND isnotnull(prodPlantResults#964797))"]; 30 [id="node30" 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#964796, 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#964797]"]; } 31 [id="node31" labelType="html" label=" Scan " tooltip="Scan[obj#964793]"]; 32 [id="node32" labelType="html" label=" Project " tooltip="Project [_extract_productId#964998 AS product#964832, _extract_plantId#964999 AS plant#964833, null AS qty#964855, demandChannelStreamKpiResults#964838.demandChannel AS demandChannel#964840, demandChannelStreamKpiResults#964838.demandStream AS demandStream#964842, transform(demandChannelStreamKpiResults#964838.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964994]"]; subgraph cluster33 { isCluster="true"; id="cluster33"; label="WholeStageCodegen (2)"; tooltip="WholeStageCodegen (2)"; 34 [id="node34" labelType="html" label=" Generate " tooltip="Generate explode(_extract_demandChannelStreamKpiResults#965000), [_extract_productId#964998, _extract_plantId#964999], false, [demandChannelStreamKpiResults#964838]"]; 35 [id="node35" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964854.productId AS _extract_productId#964998, prodPlantResults#964854.plantId AS _extract_plantId#964999, prodPlantResults#964854.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#965000]"]; 36 [id="node36" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#964854.demandChannelStreamKpiResults, true) > 0) AND isnotnull(prodPlantResults#964854.demandChannelStreamKpiResults))"]; } 37 [id="node37" labelType="html" label=" InMemoryTableScan " tooltip="InMemoryTableScan [prodPlantResults#964854], [(size(prodPlantResults#964854.demandChannelStreamKpiResults, true) > 0), isnotnull(prodPlantResults#964854.demandChannelStreamKpiResults)]"]; subgraph cluster38 { isCluster="true"; id="cluster38"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 39 [id="node39" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#964797), false, [prodPlantResults#964804]"]; 40 [id="node40" labelType="html" label=" Project " tooltip="Project [prodPlantResults#964797]"]; 41 [id="node41" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#964797, true) > 0) AND isnotnull(prodPlantResults#964797))"]; 42 [id="node42" 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#964796, 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#964797]"]; } 43 [id="node43" labelType="html" label=" Scan " tooltip="Scan[obj#964793]"]; 44 [id="node44" labelType="html" label="BroadcastExchange time to broadcast: 0 ms time to build: 1 ms time to collect: 675 ms number of output rows: 434 data size: 2.0 MiB" 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=1620184]"]; subgraph cluster45 { isCluster="true"; id="cluster45"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n191 ms (1 ms, 3 ms, 16 ms (stage 101403.0: task 330848))"; tooltip="WholeStageCodegen (4)"; 46 [id="node46" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 72 ms (0 ms, 2 ms, 5 ms (stage 101403.0: task 330842)) peak memory total (min, med, max (stageId: taskId)) 83.3 MiB (2.3 MiB, 2.3 MiB, 2.3 MiB (stage 101403.0: task 330841)) number of output rows: 434 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 101403.0: task 330841))" tooltip="HashAggregate(keys=[plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634], functions=[])"]; } 47 [id="node47" labelType="html" label="Exchange shuffle records written: 434 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 434 local bytes read total (min, med, max (stageId: taskId)) 30.7 KiB (354.0 B, 710.0 B, 1714.0 B (stage 101403.0: task 330840)) merged fetch fallback count: 0 local blocks read: 167 remote merged chunks fetched: 0 remote blocks read: 206 data size total (min, med, max (stageId: taskId)) 54.3 KiB (384.0 B, 1536.0 B, 2.3 KiB (stage 101402.0: task 330795)) local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 37 ms (0 ms, 1 ms, 1 ms (stage 101402.0: task 330762)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time total (min, med, max (stageId: taskId)) 15 ms (0 ms, 0 ms, 1 ms (stage 101403.0: task 330851)) remote bytes read total (min, med, max (stageId: taskId)) 38.0 KiB (178.0 B, 1075.0 B, 1931.0 B (stage 101403.0: task 330838)) number of partitions: 37 remote reqs duration total (min, med, max (stageId: taskId)) 113 ms (0 ms, 3 ms, 7 ms (stage 101403.0: task 330848)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 68.8 KiB (533.0 B, 1910.0 B, 3.0 KiB (stage 101402.0: task 330795))" tooltip="Exchange hashpartitioning(plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634, 37), ENSURE_REQUIREMENTS, [plan_id=1620180]"]; subgraph cluster48 { isCluster="true"; id="cluster48"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (0 ms, 1 ms, 156 ms (stage 101402.0: task 330768))"; tooltip="WholeStageCodegen (3)"; 49 [id="node49" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 42 ms (0 ms, 0 ms, 6 ms (stage 101402.0: task 330768)) peak memory total (min, med, max (stageId: taskId)) 92.5 MiB (256.0 KiB, 2.3 MiB, 2.3 MiB (stage 101402.0: task 330773)) number of output rows: 434 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 101402.0: task 330773))" tooltip="HashAggregate(keys=[plant#943635, shardId#943631, knownfloatingpointnormalized(normalizenanandzero(qty#943638)) AS qty#943638, worklistShardItemId#943632L, product#943634], functions=[])"]; 50 [id="node50" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]"]; 51 [id="node51" labelType="html" label="Filter number of output rows: 434" tooltip="Filter isNewlyCalculated#960604: boolean"]; } 52 [id="node52" labelType="html" label="InMemoryTableScan number of output rows: 434" tooltip="InMemoryTableScan [isNewlyCalculated#960604, plant#943635, product#943634, qty#943638, shardId#943631, worklistShardItemId#943632L], [isNewlyCalculated#960604]"]; 53 [id="node53" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster54 { isCluster="true"; id="cluster54"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 55 [id="node55" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638, null AS demandChannel#960601, null AS demandStream#960602, [] AS kpis#960636, true AS isNewlyCalculated#960604]"]; 56 [id="node56" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [coalesce(shardId#943631, ), isnull(shardId#943631), coalesce(worklistShardItemId#943632L, 0), isnull(worklistShardItemId#943632L), coalesce(version#943633, 0), isnull(version#943633), coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))), isnull(qty#943638)], [coalesce(shardId#960593, ), isnull(shardId#960593), coalesce(worklistShardItemId#960594L, 0), isnull(worklistShardItemId#960594L), coalesce(version#960595, 0), isnull(version#960595), coalesce(product#960596, ), isnull(product#960596), coalesce(plant#960597, ), isnull(plant#960597), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))), isnull(qty#960368)], LeftAnti"]; } subgraph cluster57 { isCluster="true"; id="cluster57"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 58 [id="node58" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#943631, ) ASC NULLS FIRST, isnull(shardId#943631) ASC NULLS FIRST, coalesce(worklistShardItemId#943632L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#943632L) ASC NULLS FIRST, coalesce(version#943633, 0) ASC NULLS FIRST, isnull(version#943633) ASC NULLS FIRST, coalesce(product#943634, ) ASC NULLS FIRST, isnull(product#943634) ASC NULLS FIRST, coalesce(plant#943635, ) ASC NULLS FIRST, isnull(plant#943635) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))) ASC NULLS FIRST, isnull(qty#943638) ASC NULLS FIRST], false, 0"]; } 59 [id="node59" 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(coalesce(shardId#943631, ), isnull(shardId#943631), coalesce(worklistShardItemId#943632L, 0), isnull(worklistShardItemId#943632L), coalesce(version#943633, 0), isnull(version#943633), coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))), isnull(qty#943638), 37), ENSURE_REQUIREMENTS, [plan_id=1595416]"]; 60 [id="node60" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]"]; 61 [id="node61" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#943634, plant#943635, 37), REPARTITION_BY_NUM, [plan_id=1594958]"]; subgraph cluster62 { isCluster="true"; id="cluster62"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 63 [id="node63" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#943631,worklistShardItemId#943632L,version#943633,product#943634,plant#943635,periodStart#943636,periodEnd#943637,qty#943638]"]; } subgraph cluster64 { isCluster="true"; id="cluster64"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 65 [id="node65" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#960593, ) ASC NULLS FIRST, isnull(shardId#960593) ASC NULLS FIRST, coalesce(worklistShardItemId#960594L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#960594L) ASC NULLS FIRST, coalesce(version#960595, 0) ASC NULLS FIRST, isnull(version#960595) ASC NULLS FIRST, coalesce(product#960596, ) ASC NULLS FIRST, isnull(product#960596) ASC NULLS FIRST, coalesce(plant#960597, ) ASC NULLS FIRST, isnull(plant#960597) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))) ASC NULLS FIRST, isnull(qty#960368) ASC NULLS FIRST], false, 0"]; } 66 [id="node66" 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(coalesce(shardId#960593, ), isnull(shardId#960593), coalesce(worklistShardItemId#960594L, 0), isnull(worklistShardItemId#960594L), coalesce(version#960595, 0), isnull(version#960595), coalesce(product#960596, ), isnull(product#960596), coalesce(plant#960597, ), isnull(plant#960597), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))), isnull(qty#960368), 37), ENSURE_REQUIREMENTS, [plan_id=1595436]"]; 67 [id="node67" labelType="html" label=" Union " tooltip="Union"]; 68 [id="node68" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368]"]; subgraph cluster69 { isCluster="true"; id="cluster69"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 70 [id="node70" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, cachedQty#960366 AS qty#960368, demandChannel#960361, demandStream#960362, cachedKpis#960367 AS kpis#960369]"]; 71 [id="node71" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#943632L, shardId#943631], [cachedWorklistShardItemId#960365L, cachedShardId#960364], Inner"]; } subgraph cluster72 { isCluster="true"; id="cluster72"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 73 [id="node73" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#943632L ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST], false, 0"]; } 74 [id="node74" 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(worklistShardItemId#943632L, shardId#943631, 37), ENSURE_REQUIREMENTS, [plan_id=1595304]"]; subgraph cluster75 { isCluster="true"; id="cluster75"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 76 [id="node76" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634], functions=[])"]; } 77 [id="node77" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634, 37), ENSURE_REQUIREMENTS, [plan_id=1595300]"]; subgraph cluster78 { isCluster="true"; id="cluster78"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 79 [id="node79" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634], functions=[])"]; 80 [id="node80" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]"]; 81 [id="node81" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#943632L, shardId#943631], [cachedWorklistShardItemId#960355L, cachedShardId#960354], Inner, BuildLeft, ((qty#943638 = cachedQty#960356) OR isnull(qty#943638)), false"]; 89 [id="node89" labelType="html" label=" Project " tooltip="Project [shardId#960348 AS cachedShardId#960354, worklistShardItemId#960349L AS cachedWorklistShardItemId#960355L, qty#960350 AS cachedQty#960356]"]; 90 [id="node90" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#960349L) AND isnotnull(shardId#960348))"]; 91 [id="node91" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#960348,worklistShardItemId#960349L,qty#960350,demandChannel#960351,demandStream#960352,kpis#960353]"]; } 82 [id="node82" 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(input[1, bigint, false], input[0, string, false]),false), [plan_id=1595294]"]; subgraph cluster83 { isCluster="true"; id="cluster83"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 84 [id="node84" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#943632L) AND isnotnull(shardId#943631))"]; } 85 [id="node85" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638], [isnotnull(worklistShardItemId#943632L), isnotnull(shardId#943631)]"]; 86 [id="node86" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#943634, plant#943635, 37), REPARTITION_BY_NUM, [plan_id=1594958]"]; subgraph cluster87 { isCluster="true"; id="cluster87"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 88 [id="node88" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#943631,worklistShardItemId#943632L,version#943633,product#943634,plant#943635,periodStart#943636,periodEnd#943637,qty#943638]"]; } subgraph cluster92 { isCluster="true"; id="cluster92"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 93 [id="node93" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#960365L ASC NULLS FIRST, cachedShardId#960364 ASC NULLS FIRST], false, 0"]; } 94 [id="node94" 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(cachedWorklistShardItemId#960365L, cachedShardId#960364, 37), ENSURE_REQUIREMENTS, [plan_id=1595310]"]; subgraph cluster95 { isCluster="true"; id="cluster95"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 96 [id="node96" labelType="html" label=" Project " tooltip="Project [shardId#960358 AS cachedShardId#960364, worklistShardItemId#960359L AS cachedWorklistShardItemId#960365L, qty#960360 AS cachedQty#960366, demandChannel#960361, demandStream#960362, kpis#960363 AS cachedKpis#960367]"]; 97 [id="node97" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#960359L) AND isnotnull(shardId#960358))"]; 98 [id="node98" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#960358,worklistShardItemId#960359L,qty#960360,demandChannel#960361,demandStream#960362,kpis#960363]"]; } subgraph cluster99 { isCluster="true"; id="cluster99"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 100 [id="node100" labelType="html" label=" Project " tooltip="Project [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582]"]; 101 [id="node101" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#960576L, shardId#960575], [cachedWorklistShardItemId#960590L, cachedShardId#960589], Inner, BuildLeft, false"]; 109 [id="node109" labelType="html" label=" Project " tooltip="Project [shardId#960583 AS cachedShardId#960589, worklistShardItemId#960584L AS cachedWorklistShardItemId#960590L]"]; 110 [id="node110" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#960584L) AND isnotnull(shardId#960583))"]; 111 [id="node111" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#960583,worklistShardItemId#960584L,qty#960585,demandChannel#960586,demandStream#960587,kpis#960588]"]; } 102 [id="node102" 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(input[1, bigint, false], input[0, string, false]),false), [plan_id=1595430]"]; subgraph cluster103 { isCluster="true"; id="cluster103"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 104 [id="node104" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((isnull(qty#960582) AND isnotnull(worklistShardItemId#960576L)) AND isnotnull(shardId#960575))"]; } 105 [id="node105" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582], [isnull(qty#960582), isnotnull(worklistShardItemId#960576L), isnotnull(shardId#960575)]"]; 106 [id="node106" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#943634, plant#943635, 37), REPARTITION_BY_NUM, [plan_id=1594958]"]; subgraph cluster107 { isCluster="true"; id="cluster107"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 108 [id="node108" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#943631,worklistShardItemId#943632L,version#943633,product#943634,plant#943635,periodStart#943636,periodEnd#943637,qty#943638]"]; } subgraph cluster112 { isCluster="true"; id="cluster112"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 113 [id="node113" labelType="html" label=" Project " tooltip="Project [shardId#960606, worklistShardItemId#960607L, version#960608, product#960609, plant#960610, qty#960634, demandChannel#960627, demandStream#960628, kpis#960635, false AS isNewlyCalculated#960605]"]; } 114 [id="node114" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [demandChannel#960627, demandStream#960628, kpis#960635, plant#960610, product#960609, qty#960634, shardId#960606, version#960608, worklistShardItemId#960607L]"]; subgraph cluster115 { isCluster="true"; id="cluster115"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 116 [id="node116" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, cachedQty#960366 AS qty#960368, demandChannel#960361, demandStream#960362, cachedKpis#960367 AS kpis#960369]"]; 117 [id="node117" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#943632L, shardId#943631], [cachedWorklistShardItemId#960365L, cachedShardId#960364], Inner"]; } subgraph cluster118 { isCluster="true"; id="cluster118"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 119 [id="node119" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#943632L ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST], false, 0"]; } 120 [id="node120" 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(worklistShardItemId#943632L, shardId#943631, 37), ENSURE_REQUIREMENTS, [plan_id=1595304]"]; subgraph cluster121 { isCluster="true"; id="cluster121"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 122 [id="node122" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634], functions=[])"]; } 123 [id="node123" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634, 37), ENSURE_REQUIREMENTS, [plan_id=1595300]"]; subgraph cluster124 { isCluster="true"; id="cluster124"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 125 [id="node125" 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#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634], functions=[])"]; 126 [id="node126" labelType="html" label=" Project " tooltip="Project [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]"]; 127 [id="node127" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#943632L, shardId#943631], [cachedWorklistShardItemId#960355L, cachedShardId#960354], Inner, BuildLeft, ((qty#943638 = cachedQty#960356) OR isnull(qty#943638)), false"]; 135 [id="node135" labelType="html" label=" Project " tooltip="Project [shardId#960348 AS cachedShardId#960354, worklistShardItemId#960349L AS cachedWorklistShardItemId#960355L, qty#960350 AS cachedQty#960356]"]; 136 [id="node136" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#960349L) AND isnotnull(shardId#960348))"]; 137 [id="node137" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#960348,worklistShardItemId#960349L,qty#960350,demandChannel#960351,demandStream#960352,kpis#960353]"]; } 128 [id="node128" 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(input[1, bigint, false], input[0, string, false]),false), [plan_id=1595294]"]; subgraph cluster129 { isCluster="true"; id="cluster129"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 130 [id="node130" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#943632L) AND isnotnull(shardId#943631))"]; } 131 [id="node131" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638], [isnotnull(worklistShardItemId#943632L), isnotnull(shardId#943631)]"]; 132 [id="node132" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#943634, plant#943635, 37), REPARTITION_BY_NUM, [plan_id=1594958]"]; subgraph cluster133 { isCluster="true"; id="cluster133"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 134 [id="node134" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#943631,worklistShardItemId#943632L,version#943633,product#943634,plant#943635,periodStart#943636,periodEnd#943637,qty#943638]"]; } subgraph cluster138 { isCluster="true"; id="cluster138"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 139 [id="node139" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#960365L ASC NULLS FIRST, cachedShardId#960364 ASC NULLS FIRST], false, 0"]; } 140 [id="node140" 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(cachedWorklistShardItemId#960365L, cachedShardId#960364, 37), ENSURE_REQUIREMENTS, [plan_id=1595310]"]; subgraph cluster141 { isCluster="true"; id="cluster141"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 142 [id="node142" labelType="html" label=" Project " tooltip="Project [shardId#960358 AS cachedShardId#960364, worklistShardItemId#960359L AS cachedWorklistShardItemId#960365L, qty#960360 AS cachedQty#960366, demandChannel#960361, demandStream#960362, kpis#960363 AS cachedKpis#960367]"]; 143 [id="node143" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#960359L) AND isnotnull(shardId#960358))"]; 144 [id="node144" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#960358,worklistShardItemId#960359L,qty#960360,demandChannel#960361,demandStream#960362,kpis#960363]"]; } 1->0; 2->1; 4->2; 5->4; 6->5; 8->6; 9->8; 10->9; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; 19->18; 20->11; 22->20; 23->22; 24->23; 25->24; 27->25; 28->27; 29->28; 30->29; 31->30; 32->11; 34->32; 35->34; 36->35; 37->36; 39->37; 40->39; 41->40; 42->41; 43->42; 44->10; 46->44; 47->46; 49->47; 50->49; 51->50; 52->51; 53->52; 55->53; 56->55; 58->56; 59->58; 60->59; 61->60; 63->61; 65->56; 66->65; 67->66; 68->67; 70->68; 71->70; 73->71; 74->73; 76->74; 77->76; 79->77; 80->79; 81->80; 82->81; 84->82; 85->84; 86->85; 88->86; 89->81; 90->89; 91->90; 93->71; 94->93; 96->94; 97->96; 98->97; 100->67; 101->100; 102->101; 104->102; 105->104; 106->105; 108->106; 109->101; 110->109; 111->110; 113->53; 114->113; 116->114; 117->116; 119->117; 120->119; 122->120; 123->122; 125->123; 126->125; 127->126; 128->127; 130->128; 131->130; 132->131; 134->132; 135->127; 136->135; 137->136; 139->117; 140->139; 142->140; 143->142; 144->143; }

Details

== Physical Plan ==
DeserializeToObject (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 [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]
Arguments: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]

(2) InMemoryRelation
Arguments: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859], StorageLevel(disk, memory, 2 replicas)

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

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

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

(6) SerializeFromObject [codegen id : 1]
Input [1]: [obj#964793]
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#964796, 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#964797]

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

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

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

(10) Project
Output [6]: [prodPlantResults#964804.productId AS product#964823, prodPlantResults#964804.plantId AS plant#964824, null AS qty#964850, null AS demandChannel#964830, null AS demandStream#964831, transform(prodPlantResults#964804.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964859]
Input [1]: [prodPlantResults#964804]

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

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

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

(14) Project [codegen id : 1]
Output [3]: [prodPlantResults#964849.productId AS _extract_productId#964995, prodPlantResults#964849.plantId AS _extract_plantId#964996, prodPlantResults#964849.quantityKpiResults AS _extract_quantityKpiResults#964997]
Input [1]: [prodPlantResults#964849]

(15) Generate [codegen id : 1]
Input [3]: [_extract_productId#964995, _extract_plantId#964996, _extract_quantityKpiResults#964997]
Arguments: explode(_extract_quantityKpiResults#964997), [_extract_productId#964995, _extract_plantId#964996], false, [quantityKpiResults#964816]

(16) Project
Output [6]: [_extract_productId#964995 AS product#964810, _extract_plantId#964996 AS plant#964811, quantityKpiResults#964816.quantity AS qty#964817, null AS demandChannel#964819, null AS demandStream#964820, transform(quantityKpiResults#964816.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964993]
Input [3]: [_extract_productId#964995, _extract_plantId#964996, quantityKpiResults#964816]

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

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

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

(20) Project [codegen id : 2]
Output [3]: [prodPlantResults#964854.productId AS _extract_productId#964998, prodPlantResults#964854.plantId AS _extract_plantId#964999, prodPlantResults#964854.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#965000]
Input [1]: [prodPlantResults#964854]

(21) Generate [codegen id : 2]
Input [3]: [_extract_productId#964998, _extract_plantId#964999, _extract_demandChannelStreamKpiResults#965000]
Arguments: explode(_extract_demandChannelStreamKpiResults#965000), [_extract_productId#964998, _extract_plantId#964999], false, [demandChannelStreamKpiResults#964838]

(22) Project
Output [6]: [_extract_productId#964998 AS product#964832, _extract_plantId#964999 AS plant#964833, null AS qty#964855, demandChannelStreamKpiResults#964838.demandChannel AS demandChannel#964840, demandChannelStreamKpiResults#964838.demandStream AS demandStream#964842, transform(demandChannelStreamKpiResults#964838.kpiResults, lambdafunction(struct(label, lambda kpi#964860.label, dateTime, lambda kpi#964860.datetime, value, lambda kpi#964860.value), lambda kpi#964860, false)) AS kpis#964994]
Input [3]: [_extract_productId#964998, _extract_plantId#964999, demandChannelStreamKpiResults#964838]

(23) Union

(24) InMemoryTableScan
Output [6]: [isNewlyCalculated#960604, plant#943635, product#943634, qty#943638, shardId#943631, worklistShardItemId#943632L]
Arguments: [isNewlyCalculated#960604, plant#943635, product#943634, qty#943638, shardId#943631, worklistShardItemId#943632L], [isNewlyCalculated#960604]

(25) InMemoryRelation
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638, demandChannel#960601, demandStream#960602, kpis#960636, isNewlyCalculated#960604], StorageLevel(disk, memory, 2 replicas)

(26) InMemoryTableScan
Output [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]

(27) InMemoryRelation
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, periodStart#943636, periodEnd#943637, qty#943638], StorageLevel(disk, memory, 2 replicas)

(28) Scan ExistingRDD [codegen id : 1]
Output [8]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, periodStart#943636, periodEnd#943637, qty#943638]
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, periodStart#943636, periodEnd#943637, qty#943638], SQLExecutionRDD[47881] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(29) Exchange
Input [8]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, periodStart#943636, periodEnd#943637, qty#943638]
Arguments: hashpartitioning(product#943634, plant#943635, 37), REPARTITION_BY_NUM, [plan_id=1594958]

(30) Exchange
Input [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Arguments: hashpartitioning(coalesce(shardId#943631, ), isnull(shardId#943631), coalesce(worklistShardItemId#943632L, 0), isnull(worklistShardItemId#943632L), coalesce(version#943633, 0), isnull(version#943633), coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))), isnull(qty#943638), 37), ENSURE_REQUIREMENTS, [plan_id=1595416]

(31) Sort [codegen id : 1]
Input [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Arguments: [coalesce(shardId#943631, ) ASC NULLS FIRST, isnull(shardId#943631) ASC NULLS FIRST, coalesce(worklistShardItemId#943632L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#943632L) ASC NULLS FIRST, coalesce(version#943633, 0) ASC NULLS FIRST, isnull(version#943633) ASC NULLS FIRST, coalesce(product#943634, ) ASC NULLS FIRST, isnull(product#943634) ASC NULLS FIRST, coalesce(plant#943635, ) ASC NULLS FIRST, isnull(plant#943635) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))) ASC NULLS FIRST, isnull(qty#943638) ASC NULLS FIRST], false, 0

(32) InMemoryTableScan
Output [6]: [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368]
Arguments: [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368]

(33) InMemoryRelation
Arguments: [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368, demandChannel#960361, demandStream#960362, kpis#960369], StorageLevel(disk, memory, 2 replicas)

(34) InMemoryTableScan
Output [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638], [isnotnull(worklistShardItemId#943632L), isnotnull(shardId#943631)]

(35) InMemoryRelation
Arguments: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, periodStart#943636, periodEnd#943637, qty#943638], StorageLevel(disk, memory, 2 replicas)

(36) Filter [codegen id : 1]
Input [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Condition : (isnotnull(worklistShardItemId#943632L) AND isnotnull(shardId#943631))

(37) BroadcastExchange
Input [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]
Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1595294]

(38) Scan ExistingRDD
Output [6]: [shardId#960348, worklistShardItemId#960349L, qty#960350, demandChannel#960351, demandStream#960352, kpis#960353]
Arguments: [shardId#960348, worklistShardItemId#960349L, qty#960350, demandChannel#960351, demandStream#960352, kpis#960353], MapPartitionsRDD[47917] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(39) Filter
Input [6]: [shardId#960348, worklistShardItemId#960349L, qty#960350, demandChannel#960351, demandStream#960352, kpis#960353]
Condition : (isnotnull(worklistShardItemId#960349L) AND isnotnull(shardId#960348))

(40) Project
Output [3]: [shardId#960348 AS cachedShardId#960354, worklistShardItemId#960349L AS cachedWorklistShardItemId#960355L, qty#960350 AS cachedQty#960356]
Input [6]: [shardId#960348, worklistShardItemId#960349L, qty#960350, demandChannel#960351, demandStream#960352, kpis#960353]

(41) BroadcastHashJoin [codegen id : 2]
Left keys [2]: [worklistShardItemId#943632L, shardId#943631]
Right keys [2]: [cachedWorklistShardItemId#960355L, cachedShardId#960354]
Join type: Inner
Join condition: ((qty#943638 = cachedQty#960356) OR isnull(qty#943638))

(42) Project [codegen id : 2]
Output [5]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]
Input [9]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638, cachedShardId#960354, cachedWorklistShardItemId#960355L, cachedQty#960356]

(43) HashAggregate [codegen id : 2]
Input [5]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]
Keys [5]: [plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634]
Functions: []
Aggregate Attributes: []
Results [5]: [plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634]

(44) Exchange
Input [5]: [plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634]
Arguments: hashpartitioning(plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634, 37), ENSURE_REQUIREMENTS, [plan_id=1595300]

(45) HashAggregate [codegen id : 3]
Input [5]: [plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634]
Keys [5]: [plant#943635, shardId#943631, version#943633, worklistShardItemId#943632L, product#943634]
Functions: []
Aggregate Attributes: []
Results [5]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]

(46) Exchange
Input [5]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]
Arguments: hashpartitioning(worklistShardItemId#943632L, shardId#943631, 37), ENSURE_REQUIREMENTS, [plan_id=1595304]

(47) Sort [codegen id : 4]
Input [5]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635]
Arguments: [worklistShardItemId#943632L ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST], false, 0

(48) Scan ExistingRDD [codegen id : 5]
Output [6]: [shardId#960358, worklistShardItemId#960359L, qty#960360, demandChannel#960361, demandStream#960362, kpis#960363]
Arguments: [shardId#960358, worklistShardItemId#960359L, qty#960360, demandChannel#960361, demandStream#960362, kpis#960363], MapPartitionsRDD[47917] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(49) Filter [codegen id : 5]
Input [6]: [shardId#960358, worklistShardItemId#960359L, qty#960360, demandChannel#960361, demandStream#960362, kpis#960363]
Condition : (isnotnull(worklistShardItemId#960359L) AND isnotnull(shardId#960358))

(50) Project [codegen id : 5]
Output [6]: [shardId#960358 AS cachedShardId#960364, worklistShardItemId#960359L AS cachedWorklistShardItemId#960365L, qty#960360 AS cachedQty#960366, demandChannel#960361, demandStream#960362, kpis#960363 AS cachedKpis#960367]
Input [6]: [shardId#960358, worklistShardItemId#960359L, qty#960360, demandChannel#960361, demandStream#960362, kpis#960363]

(51) Exchange
Input [6]: [cachedShardId#960364, cachedWorklistShardItemId#960365L, cachedQty#960366, demandChannel#960361, demandStream#960362, cachedKpis#960367]
Arguments: hashpartitioning(cachedWorklistShardItemId#960365L, cachedShardId#960364, 37), ENSURE_REQUIREMENTS, [plan_id=1595310]

(52) Sort [codegen id : 6]
Input [6]: [cachedShardId#960364, cachedWorklistShardItemId#960365L, cachedQty#960366, demandChannel#960361, demandStream#960362, cachedKpis#960367]
Arguments: [cachedWorklistShardItemId#960365L ASC NULLS FIRST, cachedShardId#960364 ASC NULLS FIRST], false, 0

(53) SortMergeJoin [codegen id : 7]
Left keys [2]: [worklistShardItemId#943632L, shardId#943631]
Right keys [2]: [cachedWorklistShardItemId#960365L, cachedShardId#960364]
Join type: Inner
Join condition: None

(54) Project [codegen id : 7]
Output [9]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, cachedQty#960366 AS qty#960368, demandChannel#960361, demandStream#960362, cachedKpis#960367 AS kpis#960369]
Input [11]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, cachedShardId#960364, cachedWorklistShardItemId#960365L, cachedQty#960366, demandChannel#960361, demandStream#960362, cachedKpis#960367]

(55) InMemoryTableScan
Output [6]: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582]
Arguments: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582], [isnull(qty#960582), isnotnull(worklistShardItemId#960576L), isnotnull(shardId#960575)]

(56) InMemoryRelation
Arguments: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, periodStart#960580, periodEnd#960581, qty#960582], StorageLevel(disk, memory, 2 replicas)

(57) Filter [codegen id : 2]
Input [6]: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582]
Condition : ((isnull(qty#960582) AND isnotnull(worklistShardItemId#960576L)) AND isnotnull(shardId#960575))

(58) BroadcastExchange
Input [6]: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582]
Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1595430]

(59) Scan ExistingRDD
Output [6]: [shardId#960583, worklistShardItemId#960584L, qty#960585, demandChannel#960586, demandStream#960587, kpis#960588]
Arguments: [shardId#960583, worklistShardItemId#960584L, qty#960585, demandChannel#960586, demandStream#960587, kpis#960588], MapPartitionsRDD[47917] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(60) Filter
Input [6]: [shardId#960583, worklistShardItemId#960584L, qty#960585, demandChannel#960586, demandStream#960587, kpis#960588]
Condition : (isnotnull(worklistShardItemId#960584L) AND isnotnull(shardId#960583))

(61) Project
Output [2]: [shardId#960583 AS cachedShardId#960589, worklistShardItemId#960584L AS cachedWorklistShardItemId#960590L]
Input [6]: [shardId#960583, worklistShardItemId#960584L, qty#960585, demandChannel#960586, demandStream#960587, kpis#960588]

(62) BroadcastHashJoin [codegen id : 3]
Left keys [2]: [worklistShardItemId#960576L, shardId#960575]
Right keys [2]: [cachedWorklistShardItemId#960590L, cachedShardId#960589]
Join type: Inner
Join condition: None

(63) Project [codegen id : 3]
Output [6]: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582]
Input [8]: [shardId#960575, worklistShardItemId#960576L, version#960577, product#960578, plant#960579, qty#960582, cachedShardId#960589, cachedWorklistShardItemId#960590L]

(64) Union

(65) Exchange
Input [6]: [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368]
Arguments: hashpartitioning(coalesce(shardId#960593, ), isnull(shardId#960593), coalesce(worklistShardItemId#960594L, 0), isnull(worklistShardItemId#960594L), coalesce(version#960595, 0), isnull(version#960595), coalesce(product#960596, ), isnull(product#960596), coalesce(plant#960597, ), isnull(plant#960597), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))), isnull(qty#960368), 37), ENSURE_REQUIREMENTS, [plan_id=1595436]

(66) Sort [codegen id : 4]
Input [6]: [shardId#960593, worklistShardItemId#960594L, version#960595, product#960596, plant#960597, qty#960368]
Arguments: [coalesce(shardId#960593, ) ASC NULLS FIRST, isnull(shardId#960593) ASC NULLS FIRST, coalesce(worklistShardItemId#960594L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#960594L) ASC NULLS FIRST, coalesce(version#960595, 0) ASC NULLS FIRST, isnull(version#960595) ASC NULLS FIRST, coalesce(product#960596, ) ASC NULLS FIRST, isnull(product#960596) ASC NULLS FIRST, coalesce(plant#960597, ) ASC NULLS FIRST, isnull(plant#960597) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))) ASC NULLS FIRST, isnull(qty#960368) ASC NULLS FIRST], false, 0

(67) SortMergeJoin [codegen id : 5]
Left keys [12]: [coalesce(shardId#943631, ), isnull(shardId#943631), coalesce(worklistShardItemId#943632L, 0), isnull(worklistShardItemId#943632L), coalesce(version#943633, 0), isnull(version#943633), coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#943638, 0.0))), isnull(qty#943638)]
Right keys [12]: [coalesce(shardId#960593, ), isnull(shardId#960593), coalesce(worklistShardItemId#960594L, 0), isnull(worklistShardItemId#960594L), coalesce(version#960595, 0), isnull(version#960595), coalesce(product#960596, ), isnull(product#960596), coalesce(plant#960597, ), isnull(plant#960597), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#960368, 0.0))), isnull(qty#960368)]
Join type: LeftAnti
Join condition: None

(68) Project [codegen id : 5]
Output [10]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638, null AS demandChannel#960601, null AS demandStream#960602, [] AS kpis#960636, true AS isNewlyCalculated#960604]
Input [6]: [shardId#943631, worklistShardItemId#943632L, version#943633, product#943634, plant#943635, qty#943638]

(69) InMemoryTableScan
Output [9]: [demandChannel#960627, demandStream#960628, kpis#960635, plant#960610, product#960609, qty#960634, shardId#960606, version#960608, worklistShardItemId#960607L]
Arguments: [demandChannel#960627, demandStream#960628, kpis#960635, plant#960610, product#960609, qty#960634, shardId#960606, version#960608, worklistShardItemId#960607L]

(70) InMemoryRelation
Arguments: [shardId#960606, worklistShardItemId#960607L, version#960608, product#960609, plant#960610, qty#960634, demandChannel#960627, demandStream#960628, kpis#960635], StorageLevel(disk, memory, 2 replicas)

(71) Project [codegen id : 6]
Output [10]: [shardId#960606, worklistShardItemId#960607L, version#960608, product#960609, plant#960610, qty#960634, demandChannel#960627, demandStream#960628, kpis#960635, false AS isNewlyCalculated#960605]
Input [9]: [demandChannel#960627, demandStream#960628, kpis#960635, plant#960610, product#960609, qty#960634, shardId#960606, version#960608, worklistShardItemId#960607L]

(72) Union

(73) Filter [codegen id : 3]
Input [6]: [isNewlyCalculated#960604, plant#943635, product#943634, qty#943638, shardId#943631, worklistShardItemId#943632L]
Condition : isNewlyCalculated#960604

(74) Project [codegen id : 3]
Output [5]: [shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]
Input [6]: [isNewlyCalculated#960604, plant#943635, product#943634, qty#943638, shardId#943631, worklistShardItemId#943632L]

(75) HashAggregate [codegen id : 3]
Input [5]: [shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]
Keys [5]: [plant#943635, shardId#943631, knownfloatingpointnormalized(normalizenanandzero(qty#943638)) AS qty#943638, worklistShardItemId#943632L, product#943634]
Functions: []
Aggregate Attributes: []
Results [5]: [plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634]

(76) Exchange
Input [5]: [plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634]
Arguments: hashpartitioning(plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634, 37), ENSURE_REQUIREMENTS, [plan_id=1620180]

(77) HashAggregate [codegen id : 4]
Input [5]: [plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634]
Keys [5]: [plant#943635, shardId#943631, qty#943638, worklistShardItemId#943632L, product#943634]
Functions: []
Aggregate Attributes: []
Results [5]: [shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]

(78) BroadcastExchange
Input [5]: [shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]
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=1620184]

(79) BroadcastHashJoin [codegen id : 5]
Left keys [4]: [coalesce(product#964823, ), isnull(product#964823), coalesce(plant#964824, ), isnull(plant#964824)]
Right keys [4]: [coalesce(product#943634, ), isnull(product#943634), coalesce(plant#943635, ), isnull(plant#943635)]
Join type: Inner
Join condition: ((qty#964850 <=> qty#943638) OR isnull(qty#943638))

(80) Project [codegen id : 5]
Output [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]
Input [11]: [product#964823, plant#964824, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859, shardId#943631, worklistShardItemId#943632L, product#943634, plant#943635, qty#943638]

(81) Sort [codegen id : 5]
Input [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]
Arguments: [demandChannel#964830 ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#964850)) AS qty#964850 ASC NULLS FIRST, worklistShardItemId#943632L ASC NULLS FIRST, demandStream#964831 ASC NULLS FIRST], false, 0

(82) SortAggregate
Input [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]
Keys [5]: [demandChannel#964830, shardId#943631, knownfloatingpointnormalized(normalizenanandzero(qty#964850)) AS qty#964850, worklistShardItemId#943632L, demandStream#964831]
Functions [1]: [partial_first(kpis#964859, false)]
Aggregate Attributes [2]: [first#965066, valueSet#965067]
Results [7]: [demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, first#965068, valueSet#965069]

(83) Exchange
Input [7]: [demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, first#965068, valueSet#965069]
Arguments: hashpartitioning(demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, 37), ENSURE_REQUIREMENTS, [plan_id=1620191]

(84) Sort [codegen id : 6]
Input [7]: [demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, first#965068, valueSet#965069]
Arguments: [demandChannel#964830 ASC NULLS FIRST, shardId#943631 ASC NULLS FIRST, qty#964850 ASC NULLS FIRST, worklistShardItemId#943632L ASC NULLS FIRST, demandStream#964831 ASC NULLS FIRST], false, 0

(85) SortAggregate
Input [7]: [demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831, first#965068, valueSet#965069]
Keys [5]: [demandChannel#964830, shardId#943631, qty#964850, worklistShardItemId#943632L, demandStream#964831]
Functions [1]: [first(kpis#964859, false)]
Aggregate Attributes [1]: [first(kpis#964859)()#964991]
Results [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, first(kpis#964859)()#964991 AS kpis#964992]

(86) DeserializeToObject
Input [6]: [shardId#943631, worklistShardItemId#943632L, qty#964850, demandChannel#964830, demandStream#964831, kpis#964859]
Arguments: createexternalrow(invoke(shardId#943631.toString()), static_invoke(java.lang.Long.valueOf(worklistShardItemId#943632L)), static_invoke(java.lang.Double.valueOf(qty#964850)), invoke(demandChannel#964830.toString()), invoke(demandStream#964831.toString()), mapobjects(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1), createexternalrow(invoke(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).label.toString()), static_invoke(DateTimeUtils.toJavaTimestamp(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).dateTime)), static_invoke(java.lang.Double.valueOf(lambdavariable(MapObject, StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true), false, -1).value)), StructField(label,StringType,true), StructField(dateTime,TimestampType,true), StructField(value,DoubleType,true)), kpis#964859, Some(class scala.collection.mutable.ArraySeq)), StructField(shardId,StringType,true), StructField(worklistShardItemId,LongType,true), StructField(qty,DoubleType,true), StructField(demandChannel,StringType,true), StructField(demandStream,StringType,true), StructField(kpis,ArrayType(StructType(StructField(label,StringType,true),StructField(dateTime,TimestampType,true),StructField(value,DoubleType,true)),false),true)), obj#965179: org.apache.spark.sql.Row

SQL / DataFrame Properties

Name	Value
spark.activity.hdlfsEnabled	true
spark.activity.isolateSession	true
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	aded1321-bd2b-35de-a087-438f85924892
temporal.activity.type	RunStreamWithId