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

Submitted Time: 2026/03/21 01:17:32
Duration: 2 s
Succeeded Jobs: 6476 6477

Plan Visualization

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

digraph G { 0 [id="node0" labelType="html" label="CollectLimit shuffle records written: 37 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 1178.0 B merged fetch fallback count: 0 local blocks read: 19 remote merged chunks fetched: 0 remote blocks read: 0 local merged bytes read: 0.0 B remote reqs duration: 0 ms local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (0 ms, 0 ms, 0 ms (stage 117900.0: task 394480)) 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 remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 2.2 KiB (62.0 B, 62.0 B, 62.0 B (stage 117900.0: task 394454))" tooltip="CollectLimit 1"]; 1 [id="node1" labelType="html" label="InMemoryTableScan number of output rows: 137" tooltip="InMemoryTableScan"]; subgraph cluster2 { isCluster="true"; id="cluster2"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n3.3 s (0 ms, 0 ms, 778 ms (stage 117900.0: task 394471))"; tooltip="WholeStageCodegen (5)"; 3 [id="node3" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1148722, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388]"]; 4 [id="node4" labelType="html" label="BroadcastHashJoin number of output rows: 137" tooltip="BroadcastHashJoin [shardId#1100457, worklistShardItemId#1100458L], [shardId#1148819, worklistShardItemId#1148820L], Inner, BuildRight, false"]; } 5 [id="node5" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster6 { isCluster="true"; id="cluster6"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n660 ms (0 ms, 0 ms, 72 ms (stage 117900.0: task 394388))"; tooltip="WholeStageCodegen (1)"; 7 [id="node7" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388]"]; 8 [id="node8" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((NOT isNewlyCalculated#1145356 AND isnotnull(shardId#1100457)) AND isnotnull(worklistShardItemId#1100458L))"]; } 9 [id="node9" labelType="html" label="InMemoryTableScan number of output rows: 137" tooltip="InMemoryTableScan [demandChannel#1145353, demandStream#1145354, isNewlyCalculated#1145356, kpis#1145388, qty#1100464, shardId#1100457, worklistShardItemId#1100458L], [NOT isNewlyCalculated#1145356, isnotnull(shardId#1100457), isnotnull(worklistShardItemId#1100458L)]"]; 10 [id="node10" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster11 { isCluster="true"; id="cluster11"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 12 [id="node12" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1145353, null AS demandStream#1145354, [] AS kpis#1145388, true AS isNewlyCalculated#1145356]"]; 13 [id="node13" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)], [coalesce(shardId#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120)], LeftAnti"]; } subgraph cluster14 { isCluster="true"; id="cluster14"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 15 [id="node15" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1100457, ) ASC NULLS FIRST, isnull(shardId#1100457) ASC NULLS FIRST, coalesce(worklistShardItemId#1100458L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1100458L) ASC NULLS FIRST, coalesce(version#1100459, 0) ASC NULLS FIRST, isnull(version#1100459) ASC NULLS FIRST, coalesce(product#1100460, ) ASC NULLS FIRST, isnull(product#1100460) ASC NULLS FIRST, coalesce(plant#1100461, ) ASC NULLS FIRST, isnull(plant#1100461) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))) ASC NULLS FIRST, isnull(qty#1100464) ASC NULLS FIRST], false, 0"]; } 16 [id="node16" 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#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464), 37), ENSURE_REQUIREMENTS, [plan_id=1760249]"]; 17 [id="node17" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]"]; 18 [id="node18" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster19 { isCluster="true"; id="cluster19"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 20 [id="node20" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster21 { isCluster="true"; id="cluster21"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 22 [id="node22" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1145345, ) ASC NULLS FIRST, isnull(shardId#1145345) ASC NULLS FIRST, coalesce(worklistShardItemId#1145346L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1145346L) ASC NULLS FIRST, coalesce(version#1145347, 0) ASC NULLS FIRST, isnull(version#1145347) ASC NULLS FIRST, coalesce(product#1145348, ) ASC NULLS FIRST, isnull(product#1145348) ASC NULLS FIRST, coalesce(plant#1145349, ) ASC NULLS FIRST, isnull(plant#1145349) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))) ASC NULLS FIRST, isnull(qty#1145120) ASC NULLS FIRST], false, 0"]; } 23 [id="node23" 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#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120), 37), ENSURE_REQUIREMENTS, [plan_id=1760269]"]; 24 [id="node24" labelType="html" label=" Union " tooltip="Union"]; 25 [id="node25" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]"]; subgraph cluster26 { isCluster="true"; id="cluster26"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 27 [id="node27" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 28 [id="node28" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster29 { isCluster="true"; id="cluster29"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 30 [id="node30" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 31 [id="node31" 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#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster32 { isCluster="true"; id="cluster32"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 33 [id="node33" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 34 [id="node34" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster35 { isCluster="true"; id="cluster35"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 36 [id="node36" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 37 [id="node37" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 38 [id="node38" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 46 [id="node46" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 47 [id="node47" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 48 [id="node48" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 39 [id="node39" 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=1760127]"]; subgraph cluster40 { isCluster="true"; id="cluster40"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 41 [id="node41" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 42 [id="node42" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 43 [id="node43" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster44 { isCluster="true"; id="cluster44"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 45 [id="node45" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster49 { isCluster="true"; id="cluster49"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 50 [id="node50" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 51 [id="node51" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(cachedWorklistShardItemId#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster52 { isCluster="true"; id="cluster52"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 53 [id="node53" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 54 [id="node54" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 55 [id="node55" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } subgraph cluster56 { isCluster="true"; id="cluster56"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 57 [id="node57" labelType="html" label=" Project " tooltip="Project [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]"]; 58 [id="node58" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1145328L, shardId#1145327], [cachedWorklistShardItemId#1145342L, cachedShardId#1145341], Inner, BuildLeft, false"]; 66 [id="node66" labelType="html" label=" Project " tooltip="Project [shardId#1145335 AS cachedShardId#1145341, worklistShardItemId#1145336L AS cachedWorklistShardItemId#1145342L]"]; 67 [id="node67" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145336L) AND isnotnull(shardId#1145335))"]; 68 [id="node68" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145335,worklistShardItemId#1145336L,qty#1145337,demandChannel#1145338,demandStream#1145339,kpis#1145340]"]; } 59 [id="node59" 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=1760263]"]; subgraph cluster60 { isCluster="true"; id="cluster60"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 61 [id="node61" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((isnull(qty#1145334) AND isnotnull(worklistShardItemId#1145328L)) AND isnotnull(shardId#1145327))"]; } 62 [id="node62" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334], [isnull(qty#1145334), isnotnull(worklistShardItemId#1145328L), isnotnull(shardId#1145327)]"]; 63 [id="node63" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster64 { isCluster="true"; id="cluster64"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 65 [id="node65" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster69 { isCluster="true"; id="cluster69"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 70 [id="node70" labelType="html" label=" Project " tooltip="Project [shardId#1145358, worklistShardItemId#1145359L, version#1145360, product#1145361, plant#1145362, qty#1145386, demandChannel#1145379, demandStream#1145380, kpis#1145387, false AS isNewlyCalculated#1145357]"]; } 71 [id="node71" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]"]; subgraph cluster72 { isCluster="true"; id="cluster72"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 73 [id="node73" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 74 [id="node74" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster75 { isCluster="true"; id="cluster75"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 76 [id="node76" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 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(worklistShardItemId#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster78 { isCluster="true"; id="cluster78"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 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#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 80 [id="node80" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster81 { isCluster="true"; id="cluster81"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 82 [id="node82" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 83 [id="node83" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 84 [id="node84" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 92 [id="node92" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 93 [id="node93" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 94 [id="node94" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 85 [id="node85" 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=1760127]"]; subgraph cluster86 { isCluster="true"; id="cluster86"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 87 [id="node87" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 88 [id="node88" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 89 [id="node89" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster90 { isCluster="true"; id="cluster90"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 91 [id="node91" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster95 { isCluster="true"; id="cluster95"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 96 [id="node96" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 97 [id="node97" 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#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster98 { isCluster="true"; id="cluster98"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 99 [id="node99" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 100 [id="node100" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 101 [id="node101" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } subgraph cluster102 { isCluster="true"; id="cluster102"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n3.1 s (0 ms, 2 ms, 778 ms (stage 117900.0: task 394471))"; tooltip="WholeStageCodegen (2)"; 103 [id="node103" labelType="html" label="Filter number of output rows: 137" tooltip="Filter (isnotnull(shardId#1148727) AND isnotnull(worklistShardItemId#1148728L))"]; } 104 [id="node104" labelType="html" label="InMemoryTableScan number of output rows: 137" tooltip="InMemoryTableScan [shardId#1148727, worklistShardItemId#1148728L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918], [isnotnull(shardId#1148727), isnotnull(worklistShardItemId#1148728L)]"]; 105 [id="node105" labelType="html" label="SortAggregate number of output rows: 0" tooltip="SortAggregate(key=[demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890], functions=[first(kpis#1147918, false)])"]; subgraph cluster106 { isCluster="true"; id="cluster106"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 107 [id="node107" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [demandChannel#1147889 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, qty#1147909 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1147890 ASC NULLS FIRST], false, 0"]; } 108 [id="node108" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, 37), ENSURE_REQUIREMENTS, [plan_id=1761067]"]; 109 [id="node109" labelType="html" label="SortAggregate number of output rows: 0" tooltip="SortAggregate(key=[demandChannel#1147889, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1147909)) AS qty#1147909, worklistShardItemId#1100458L, demandStream#1147890], functions=[partial_first(kpis#1147918, false)])"]; subgraph cluster110 { isCluster="true"; id="cluster110"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 111 [id="node111" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [demandChannel#1147889 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#1147909)) AS qty#1147909 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1147890 ASC NULLS FIRST], false, 0"]; 112 [id="node112" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]"]; 113 [id="node113" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [coalesce(product#1147882, ), isnull(product#1147882), coalesce(plant#1147883, ), isnull(plant#1147883)], [coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461)], Inner, BuildRight, ((qty#1147909 <=> qty#1100464) OR isnull(qty#1100464)), false"]; } 114 [id="node114" labelType="html" label=" Union " tooltip="Union"]; 115 [id="node115" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147863.productId AS product#1147882, prodPlantResults#1147863.plantId AS plant#1147883, null AS qty#1147909, null AS demandChannel#1147889, null AS demandStream#1147890, transform(prodPlantResults#1147863.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1147918]"]; 116 [id="node116" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1147863]"]; subgraph cluster117 { isCluster="true"; id="cluster117"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 118 [id="node118" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1147856), false, [prodPlantResults#1147863]"]; 119 [id="node119" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147856]"]; 120 [id="node120" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1147856, true) > 0) AND isnotnull(prodPlantResults#1147856))"]; 121 [id="node121" 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#1147855, 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#1147856]"]; } 122 [id="node122" labelType="html" label=" Scan " tooltip="Scan[obj#1147852]"]; 123 [id="node123" labelType="html" label=" Project " tooltip="Project [_extract_productId#1148054 AS product#1147869, _extract_plantId#1148055 AS plant#1147870, quantityKpiResults#1147875.quantity AS qty#1147876, null AS demandChannel#1147878, null AS demandStream#1147879, transform(quantityKpiResults#1147875.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1148052]"]; subgraph cluster124 { isCluster="true"; id="cluster124"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 125 [id="node125" labelType="html" label="Generate number of output rows: 0" tooltip="Generate explode(_extract_quantityKpiResults#1148056), [_extract_productId#1148054, _extract_plantId#1148055], false, [quantityKpiResults#1147875]"]; 126 [id="node126" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147908.productId AS _extract_productId#1148054, prodPlantResults#1147908.plantId AS _extract_plantId#1148055, prodPlantResults#1147908.quantityKpiResults AS _extract_quantityKpiResults#1148056]"]; 127 [id="node127" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((size(prodPlantResults#1147908.quantityKpiResults, true) > 0) AND isnotnull(prodPlantResults#1147908.quantityKpiResults))"]; } 128 [id="node128" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1147908], [(size(prodPlantResults#1147908.quantityKpiResults, true) > 0), isnotnull(prodPlantResults#1147908.quantityKpiResults)]"]; subgraph cluster129 { isCluster="true"; id="cluster129"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 130 [id="node130" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1147856), false, [prodPlantResults#1147863]"]; 131 [id="node131" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147856]"]; 132 [id="node132" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1147856, true) > 0) AND isnotnull(prodPlantResults#1147856))"]; 133 [id="node133" 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#1147855, 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#1147856]"]; } 134 [id="node134" labelType="html" label=" Scan " tooltip="Scan[obj#1147852]"]; 135 [id="node135" labelType="html" label=" Project " tooltip="Project [_extract_productId#1148057 AS product#1147891, _extract_plantId#1148058 AS plant#1147892, null AS qty#1147914, demandChannelStreamKpiResults#1147897.demandChannel AS demandChannel#1147899, demandChannelStreamKpiResults#1147897.demandStream AS demandStream#1147901, transform(demandChannelStreamKpiResults#1147897.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1148053]"]; subgraph cluster136 { isCluster="true"; id="cluster136"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 137 [id="node137" labelType="html" label="Generate number of output rows: 0" tooltip="Generate explode(_extract_demandChannelStreamKpiResults#1148059), [_extract_productId#1148057, _extract_plantId#1148058], false, [demandChannelStreamKpiResults#1147897]"]; 138 [id="node138" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147913.productId AS _extract_productId#1148057, prodPlantResults#1147913.plantId AS _extract_plantId#1148058, prodPlantResults#1147913.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#1148059]"]; 139 [id="node139" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((size(prodPlantResults#1147913.demandChannelStreamKpiResults, true) > 0) AND isnotnull(prodPlantResults#1147913.demandChannelStreamKpiResults))"]; } 140 [id="node140" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [prodPlantResults#1147913], [(size(prodPlantResults#1147913.demandChannelStreamKpiResults, true) > 0), isnotnull(prodPlantResults#1147913.demandChannelStreamKpiResults)]"]; subgraph cluster141 { isCluster="true"; id="cluster141"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 142 [id="node142" labelType="html" label=" Generate " tooltip="Generate explode(prodPlantResults#1147856), false, [prodPlantResults#1147863]"]; 143 [id="node143" labelType="html" label=" Project " tooltip="Project [prodPlantResults#1147856]"]; 144 [id="node144" labelType="html" label=" Filter " tooltip="Filter ((size(prodPlantResults#1147856, true) > 0) AND isnotnull(prodPlantResults#1147856))"]; 145 [id="node145" 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#1147855, 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#1147856]"]; } 146 [id="node146" labelType="html" label=" Scan " tooltip="Scan[obj#1147852]"]; 147 [id="node147" labelType="html" label="BroadcastExchange time to broadcast: 0 ms time to build: 0 ms time to collect: 0 ms number of output rows: 0 data size: 0.0 B" tooltip="BroadcastExchange HashedRelationBroadcastMode(List(coalesce(input[2, string, true], ), isnull(input[2, string, true]), coalesce(input[3, string, true], ), isnull(input[3, string, true])),false), [plan_id=1761060]"]; subgraph cluster148 { isCluster="true"; id="cluster148"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 149 [id="node149" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 150 [id="node150" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, qty#1100464, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1761056]"]; subgraph cluster151 { isCluster="true"; id="cluster151"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 152 [id="node152" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1100464)) AS qty#1100464, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 153 [id="node153" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]"]; 154 [id="node154" labelType="html" label="Filter number of output rows: 0" tooltip="Filter isNewlyCalculated#1145356: boolean"]; } 155 [id="node155" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [isNewlyCalculated#1145356, plant#1100461, product#1100460, qty#1100464, shardId#1100457, worklistShardItemId#1100458L], [isNewlyCalculated#1145356]"]; 156 [id="node156" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster157 { isCluster="true"; id="cluster157"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 158 [id="node158" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1145353, null AS demandStream#1145354, [] AS kpis#1145388, true AS isNewlyCalculated#1145356]"]; 159 [id="node159" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)], [coalesce(shardId#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120)], LeftAnti"]; } subgraph cluster160 { isCluster="true"; id="cluster160"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 161 [id="node161" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1100457, ) ASC NULLS FIRST, isnull(shardId#1100457) ASC NULLS FIRST, coalesce(worklistShardItemId#1100458L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1100458L) ASC NULLS FIRST, coalesce(version#1100459, 0) ASC NULLS FIRST, isnull(version#1100459) ASC NULLS FIRST, coalesce(product#1100460, ) ASC NULLS FIRST, isnull(product#1100460) ASC NULLS FIRST, coalesce(plant#1100461, ) ASC NULLS FIRST, isnull(plant#1100461) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))) ASC NULLS FIRST, isnull(qty#1100464) ASC NULLS FIRST], false, 0"]; } 162 [id="node162" 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#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464), 37), ENSURE_REQUIREMENTS, [plan_id=1760249]"]; 163 [id="node163" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]"]; 164 [id="node164" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster165 { isCluster="true"; id="cluster165"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 166 [id="node166" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster167 { isCluster="true"; id="cluster167"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 168 [id="node168" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1145345, ) ASC NULLS FIRST, isnull(shardId#1145345) ASC NULLS FIRST, coalesce(worklistShardItemId#1145346L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1145346L) ASC NULLS FIRST, coalesce(version#1145347, 0) ASC NULLS FIRST, isnull(version#1145347) ASC NULLS FIRST, coalesce(product#1145348, ) ASC NULLS FIRST, isnull(product#1145348) ASC NULLS FIRST, coalesce(plant#1145349, ) ASC NULLS FIRST, isnull(plant#1145349) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))) ASC NULLS FIRST, isnull(qty#1145120) ASC NULLS FIRST], false, 0"]; } 169 [id="node169" 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#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120), 37), ENSURE_REQUIREMENTS, [plan_id=1760269]"]; 170 [id="node170" labelType="html" label=" Union " tooltip="Union"]; 171 [id="node171" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]"]; subgraph cluster172 { isCluster="true"; id="cluster172"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 173 [id="node173" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 174 [id="node174" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster175 { isCluster="true"; id="cluster175"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 176 [id="node176" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 177 [id="node177" 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#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster178 { isCluster="true"; id="cluster178"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 179 [id="node179" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 180 [id="node180" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster181 { isCluster="true"; id="cluster181"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 182 [id="node182" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 183 [id="node183" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 184 [id="node184" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 192 [id="node192" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 193 [id="node193" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 194 [id="node194" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 185 [id="node185" 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=1760127]"]; subgraph cluster186 { isCluster="true"; id="cluster186"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 187 [id="node187" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 188 [id="node188" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 189 [id="node189" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster190 { isCluster="true"; id="cluster190"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 191 [id="node191" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster195 { isCluster="true"; id="cluster195"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 196 [id="node196" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 197 [id="node197" 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#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster198 { isCluster="true"; id="cluster198"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 199 [id="node199" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 200 [id="node200" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 201 [id="node201" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } subgraph cluster202 { isCluster="true"; id="cluster202"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 203 [id="node203" labelType="html" label=" Project " tooltip="Project [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]"]; 204 [id="node204" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1145328L, shardId#1145327], [cachedWorklistShardItemId#1145342L, cachedShardId#1145341], Inner, BuildLeft, false"]; 212 [id="node212" labelType="html" label=" Project " tooltip="Project [shardId#1145335 AS cachedShardId#1145341, worklistShardItemId#1145336L AS cachedWorklistShardItemId#1145342L]"]; 213 [id="node213" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145336L) AND isnotnull(shardId#1145335))"]; 214 [id="node214" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145335,worklistShardItemId#1145336L,qty#1145337,demandChannel#1145338,demandStream#1145339,kpis#1145340]"]; } 205 [id="node205" 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=1760263]"]; subgraph cluster206 { isCluster="true"; id="cluster206"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 207 [id="node207" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((isnull(qty#1145334) AND isnotnull(worklistShardItemId#1145328L)) AND isnotnull(shardId#1145327))"]; } 208 [id="node208" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334], [isnull(qty#1145334), isnotnull(worklistShardItemId#1145328L), isnotnull(shardId#1145327)]"]; 209 [id="node209" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster210 { isCluster="true"; id="cluster210"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 211 [id="node211" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster215 { isCluster="true"; id="cluster215"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 216 [id="node216" labelType="html" label=" Project " tooltip="Project [shardId#1145358, worklistShardItemId#1145359L, version#1145360, product#1145361, plant#1145362, qty#1145386, demandChannel#1145379, demandStream#1145380, kpis#1145387, false AS isNewlyCalculated#1145357]"]; } 217 [id="node217" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]"]; subgraph cluster218 { isCluster="true"; id="cluster218"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 219 [id="node219" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 220 [id="node220" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster221 { isCluster="true"; id="cluster221"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 222 [id="node222" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 223 [id="node223" 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#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster224 { isCluster="true"; id="cluster224"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 225 [id="node225" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 226 [id="node226" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster227 { isCluster="true"; id="cluster227"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 228 [id="node228" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 229 [id="node229" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 230 [id="node230" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 238 [id="node238" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 239 [id="node239" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 240 [id="node240" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 231 [id="node231" 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=1760127]"]; subgraph cluster232 { isCluster="true"; id="cluster232"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 233 [id="node233" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 234 [id="node234" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 235 [id="node235" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster236 { isCluster="true"; id="cluster236"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 237 [id="node237" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster241 { isCluster="true"; id="cluster241"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 242 [id="node242" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 243 [id="node243" 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#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster244 { isCluster="true"; id="cluster244"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 245 [id="node245" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 246 [id="node246" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 247 [id="node247" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } 248 [id="node248" labelType="html" label="BroadcastExchange time to broadcast: 0 ms time to build: 1 ms time to collect: 606 ms number of output rows: 64 data size: 2.0 MiB" tooltip="BroadcastExchange HashedRelationBroadcastMode(List(input[0, string, true], input[1, bigint, true]),false), [plan_id=1761228]"]; subgraph cluster249 { isCluster="true"; id="cluster249"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n69 ms (0 ms, 2 ms, 5 ms (stage 117847.0: task 394345))"; tooltip="WholeStageCodegen (4)"; 250 [id="node250" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 46 ms (0 ms, 1 ms, 3 ms (stage 117847.0: task 394345)) peak memory total (min, med, max (stageId: taskId)) 71.3 MiB (256.0 KiB, 2.3 MiB, 2.3 MiB (stage 117847.0: task 394356)) number of output rows: 64 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 117847.0: task 394356))" tooltip="HashAggregate(keys=[shardId#1148819, worklistShardItemId#1148820L], functions=[max(version#1148821)])"]; } 251 [id="node251" labelType="html" label="Exchange shuffle records written: 136 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 136 local bytes read total (min, med, max (stageId: taskId)) 6.9 KiB (100.0 B, 200.0 B, 725.0 B (stage 117847.0: task 394369)) merged fetch fallback count: 0 local blocks read: 70 remote merged chunks fetched: 0 remote blocks read: 63 data size total (min, med, max (stageId: taskId)) 6.4 KiB (48.0 B, 192.0 B, 336.0 B (stage 117846.0: task 394298)) local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 23 ms (0 ms, 0 ms, 0 ms (stage 117846.0: task 394298)) 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)) 12 ms (0 ms, 0 ms, 2 ms (stage 117847.0: task 394375)) remote bytes read total (min, med, max (stageId: taskId)) 6.2 KiB (100.0 B, 200.0 B, 710.0 B (stage 117847.0: task 394359)) number of partitions: 37 remote reqs duration total (min, med, max (stageId: taskId)) 64 ms (0 ms, 2 ms, 6 ms (stage 117847.0: task 394345)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 13.1 KiB (100.0 B, 400.0 B, 708.0 B (stage 117846.0: task 394307))" tooltip="Exchange hashpartitioning(shardId#1148819, worklistShardItemId#1148820L, 37), ENSURE_REQUIREMENTS, [plan_id=1761224]"]; subgraph cluster252 { isCluster="true"; id="cluster252"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.9 s (0 ms, 1 ms, 206 ms (stage 117846.0: task 394276))"; tooltip="WholeStageCodegen (3)"; 253 [id="node253" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 28 ms (0 ms, 0 ms, 4 ms (stage 117846.0: task 394279)) peak memory total (min, med, max (stageId: taskId)) 18.5 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 117846.0: task 394277)) number of output rows: 136 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[shardId#1148819, worklistShardItemId#1148820L], functions=[partial_max(version#1148821)])"]; 254 [id="node254" labelType="html" label="Filter number of output rows: 137" tooltip="Filter (isnotnull(shardId#1148819) AND isnotnull(worklistShardItemId#1148820L))"]; } 255 [id="node255" labelType="html" label="InMemoryTableScan number of output rows: 137" tooltip="InMemoryTableScan [shardId#1148819, worklistShardItemId#1148820L, version#1148821], [isnotnull(shardId#1148819), isnotnull(worklistShardItemId#1148820L)]"]; 256 [id="node256" labelType="html" label=" Union " tooltip="Union"]; subgraph cluster257 { isCluster="true"; id="cluster257"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 258 [id="node258" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1145353, null AS demandStream#1145354, [] AS kpis#1145388, true AS isNewlyCalculated#1145356]"]; 259 [id="node259" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)], [coalesce(shardId#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120)], LeftAnti"]; } subgraph cluster260 { isCluster="true"; id="cluster260"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 261 [id="node261" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1100457, ) ASC NULLS FIRST, isnull(shardId#1100457) ASC NULLS FIRST, coalesce(worklistShardItemId#1100458L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1100458L) ASC NULLS FIRST, coalesce(version#1100459, 0) ASC NULLS FIRST, isnull(version#1100459) ASC NULLS FIRST, coalesce(product#1100460, ) ASC NULLS FIRST, isnull(product#1100460) ASC NULLS FIRST, coalesce(plant#1100461, ) ASC NULLS FIRST, isnull(plant#1100461) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))) ASC NULLS FIRST, isnull(qty#1100464) ASC NULLS FIRST], false, 0"]; } 262 [id="node262" 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#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464), 37), ENSURE_REQUIREMENTS, [plan_id=1760249]"]; 263 [id="node263" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]"]; 264 [id="node264" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster265 { isCluster="true"; id="cluster265"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 266 [id="node266" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster267 { isCluster="true"; id="cluster267"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 268 [id="node268" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [coalesce(shardId#1145345, ) ASC NULLS FIRST, isnull(shardId#1145345) ASC NULLS FIRST, coalesce(worklistShardItemId#1145346L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1145346L) ASC NULLS FIRST, coalesce(version#1145347, 0) ASC NULLS FIRST, isnull(version#1145347) ASC NULLS FIRST, coalesce(product#1145348, ) ASC NULLS FIRST, isnull(product#1145348) ASC NULLS FIRST, coalesce(plant#1145349, ) ASC NULLS FIRST, isnull(plant#1145349) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))) ASC NULLS FIRST, isnull(qty#1145120) ASC NULLS FIRST], false, 0"]; } 269 [id="node269" 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#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120), 37), ENSURE_REQUIREMENTS, [plan_id=1760269]"]; 270 [id="node270" labelType="html" label=" Union " tooltip="Union"]; 271 [id="node271" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]"]; subgraph cluster272 { isCluster="true"; id="cluster272"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 273 [id="node273" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 274 [id="node274" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster275 { isCluster="true"; id="cluster275"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 276 [id="node276" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 277 [id="node277" 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#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster278 { isCluster="true"; id="cluster278"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 279 [id="node279" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 280 [id="node280" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster281 { isCluster="true"; id="cluster281"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 282 [id="node282" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 283 [id="node283" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 284 [id="node284" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 292 [id="node292" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 293 [id="node293" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 294 [id="node294" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 285 [id="node285" 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=1760127]"]; subgraph cluster286 { isCluster="true"; id="cluster286"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 287 [id="node287" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 288 [id="node288" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 289 [id="node289" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster290 { isCluster="true"; id="cluster290"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 291 [id="node291" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster295 { isCluster="true"; id="cluster295"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 296 [id="node296" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 297 [id="node297" 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#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster298 { isCluster="true"; id="cluster298"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 299 [id="node299" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 300 [id="node300" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 301 [id="node301" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } subgraph cluster302 { isCluster="true"; id="cluster302"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 303 [id="node303" labelType="html" label=" Project " tooltip="Project [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]"]; 304 [id="node304" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1145328L, shardId#1145327], [cachedWorklistShardItemId#1145342L, cachedShardId#1145341], Inner, BuildLeft, false"]; 312 [id="node312" labelType="html" label=" Project " tooltip="Project [shardId#1145335 AS cachedShardId#1145341, worklistShardItemId#1145336L AS cachedWorklistShardItemId#1145342L]"]; 313 [id="node313" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145336L) AND isnotnull(shardId#1145335))"]; 314 [id="node314" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145335,worklistShardItemId#1145336L,qty#1145337,demandChannel#1145338,demandStream#1145339,kpis#1145340]"]; } 305 [id="node305" 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=1760263]"]; subgraph cluster306 { isCluster="true"; id="cluster306"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 307 [id="node307" labelType="html" label="Filter number of output rows: 0" tooltip="Filter ((isnull(qty#1145334) AND isnotnull(worklistShardItemId#1145328L)) AND isnotnull(shardId#1145327))"]; } 308 [id="node308" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334], [isnull(qty#1145334), isnotnull(worklistShardItemId#1145328L), isnotnull(shardId#1145327)]"]; 309 [id="node309" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster310 { isCluster="true"; id="cluster310"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 311 [id="node311" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster315 { isCluster="true"; id="cluster315"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 316 [id="node316" labelType="html" label=" Project " tooltip="Project [shardId#1145358, worklistShardItemId#1145359L, version#1145360, product#1145361, plant#1145362, qty#1145386, demandChannel#1145379, demandStream#1145380, kpis#1145387, false AS isNewlyCalculated#1145357]"]; } 317 [id="node317" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]"]; subgraph cluster318 { isCluster="true"; id="cluster318"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (7)"; 319 [id="node319" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]"]; 320 [id="node320" labelType="html" label="SortMergeJoin number of output rows: 0 spill size: 0.0 B" tooltip="SortMergeJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145117L, cachedShardId#1145116], Inner"]; } subgraph cluster321 { isCluster="true"; id="cluster321"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (4)"; 322 [id="node322" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [worklistShardItemId#1100458L ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST], false, 0"]; } 323 [id="node323" 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#1100458L, shardId#1100457, 37), ENSURE_REQUIREMENTS, [plan_id=1760137]"]; subgraph cluster324 { isCluster="true"; id="cluster324"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (3)"; 325 [id="node325" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; } 326 [id="node326" labelType="html" label="Exchange shuffle records written: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 0 local bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 0 remote merged chunks fetched: 0 remote blocks read: 0 data size: 0.0 B local merged bytes read: 0.0 B local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 fetch wait time: 0 ms remote bytes read: 0.0 B number of partitions: 0 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 0.0 B" tooltip="Exchange hashpartitioning(plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460, 37), ENSURE_REQUIREMENTS, [plan_id=1760133]"]; subgraph cluster327 { isCluster="true"; id="cluster327"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (2)"; 328 [id="node328" labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 0.0 B number of output rows: 0 number of sort fallback tasks: 0 avg hash probes per key: 0" tooltip="HashAggregate(keys=[plant#1100461, shardId#1100457, version#1100459, worklistShardItemId#1100458L, product#1100460], functions=[])"]; 329 [id="node329" labelType="html" label=" Project " tooltip="Project [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]"]; 330 [id="node330" labelType="html" label="BroadcastHashJoin number of output rows: 0" tooltip="BroadcastHashJoin [worklistShardItemId#1100458L, shardId#1100457], [cachedWorklistShardItemId#1145107L, cachedShardId#1145106], Inner, BuildLeft, ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464)), false"]; 338 [id="node338" labelType="html" label=" Project " tooltip="Project [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]"]; 339 [id="node339" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))"]; 340 [id="node340" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145100,worklistShardItemId#1145101L,qty#1145102,demandChannel#1145103,demandStream#1145104,kpis#1145105]"]; } 331 [id="node331" 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=1760127]"]; subgraph cluster332 { isCluster="true"; id="cluster332"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (1)"; 333 [id="node333" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1100458L) AND isnotnull(shardId#1100457))"]; } 334 [id="node334" labelType="html" label="InMemoryTableScan number of output rows: 0" tooltip="InMemoryTableScan [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464], [isnotnull(worklistShardItemId#1100458L), isnotnull(shardId#1100457)]"]; 335 [id="node335" labelType="html" label=" Exchange " tooltip="Exchange hashpartitioning(product#1100460, plant#1100461, 37), REPARTITION_BY_NUM, [plan_id=1760019]"]; subgraph cluster336 { isCluster="true"; id="cluster336"; label="WholeStageCodegen (1)"; tooltip="WholeStageCodegen (1)"; 337 [id="node337" labelType="html" label=" Scan ExistingRDD " tooltip="Scan ExistingRDD[shardId#1100457,worklistShardItemId#1100458L,version#1100459,product#1100460,plant#1100461,periodStart#1100462,periodEnd#1100463,qty#1100464]"]; } subgraph cluster341 { isCluster="true"; id="cluster341"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (6)"; 342 [id="node342" labelType="html" label="Sort sort time: 0 ms peak memory: 0.0 B spill size: 0.0 B" tooltip="Sort [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0"]; } 343 [id="node343" 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#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]"]; subgraph cluster344 { isCluster="true"; id="cluster344"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; tooltip="WholeStageCodegen (5)"; 345 [id="node345" labelType="html" label=" Project " tooltip="Project [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]"]; 346 [id="node346" labelType="html" label="Filter number of output rows: 0" tooltip="Filter (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))"]; 347 [id="node347" labelType="html" label="Scan ExistingRDD number of output rows: 0" tooltip="Scan ExistingRDD[shardId#1145110,worklistShardItemId#1145111L,qty#1145112,demandChannel#1145113,demandStream#1145114,kpis#1145115]"]; } 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 15->13; 16->15; 17->16; 18->17; 20->18; 22->13; 23->22; 24->23; 25->24; 27->25; 28->27; 30->28; 31->30; 33->31; 34->33; 36->34; 37->36; 38->37; 39->38; 41->39; 42->41; 43->42; 45->43; 46->38; 47->46; 48->47; 50->28; 51->50; 53->51; 54->53; 55->54; 57->24; 58->57; 59->58; 61->59; 62->61; 63->62; 65->63; 66->58; 67->66; 68->67; 70->10; 71->70; 73->71; 74->73; 76->74; 77->76; 79->77; 80->79; 82->80; 83->82; 84->83; 85->84; 87->85; 88->87; 89->88; 91->89; 92->84; 93->92; 94->93; 96->74; 97->96; 99->97; 100->99; 101->100; 103->5; 104->103; 105->104; 107->105; 108->107; 109->108; 111->109; 112->111; 113->112; 114->113; 115->114; 116->115; 118->116; 119->118; 120->119; 121->120; 122->121; 123->114; 125->123; 126->125; 127->126; 128->127; 130->128; 131->130; 132->131; 133->132; 134->133; 135->114; 137->135; 138->137; 139->138; 140->139; 142->140; 143->142; 144->143; 145->144; 146->145; 147->113; 149->147; 150->149; 152->150; 153->152; 154->153; 155->154; 156->155; 158->156; 159->158; 161->159; 162->161; 163->162; 164->163; 166->164; 168->159; 169->168; 170->169; 171->170; 173->171; 174->173; 176->174; 177->176; 179->177; 180->179; 182->180; 183->182; 184->183; 185->184; 187->185; 188->187; 189->188; 191->189; 192->184; 193->192; 194->193; 196->174; 197->196; 199->197; 200->199; 201->200; 203->170; 204->203; 205->204; 207->205; 208->207; 209->208; 211->209; 212->204; 213->212; 214->213; 216->156; 217->216; 219->217; 220->219; 222->220; 223->222; 225->223; 226->225; 228->226; 229->228; 230->229; 231->230; 233->231; 234->233; 235->234; 237->235; 238->230; 239->238; 240->239; 242->220; 243->242; 245->243; 246->245; 247->246; 248->4; 250->248; 251->250; 253->251; 254->253; 255->254; 256->255; 258->256; 259->258; 261->259; 262->261; 263->262; 264->263; 266->264; 268->259; 269->268; 270->269; 271->270; 273->271; 274->273; 276->274; 277->276; 279->277; 280->279; 282->280; 283->282; 284->283; 285->284; 287->285; 288->287; 289->288; 291->289; 292->284; 293->292; 294->293; 296->274; 297->296; 299->297; 300->299; 301->300; 303->270; 304->303; 305->304; 307->305; 308->307; 309->308; 311->309; 312->304; 313->312; 314->313; 316->256; 317->316; 319->317; 320->319; 322->320; 323->322; 325->323; 326->325; 328->326; 329->328; 330->329; 331->330; 333->331; 334->333; 335->334; 337->335; 338->330; 339->338; 340->339; 342->320; 343->342; 345->343; 346->345; 347->346; }

Details

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


(1) InMemoryTableScan
Output: []

(2) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1148722, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388], StorageLevel(disk, memory, 2 replicas)

(3) InMemoryTableScan
Output [7]: [demandChannel#1145353, demandStream#1145354, isNewlyCalculated#1145356, kpis#1145388, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]
Arguments: [demandChannel#1145353, demandStream#1145354, isNewlyCalculated#1145356, kpis#1145388, qty#1100464, shardId#1100457, worklistShardItemId#1100458L], [NOT isNewlyCalculated#1145356, isnotnull(shardId#1100457), isnotnull(worklistShardItemId#1100458L)]

(4) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388, isNewlyCalculated#1145356], StorageLevel(disk, memory, 2 replicas)

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

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

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

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

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

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

(11) InMemoryTableScan
Output [6]: [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]
Arguments: [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]

(12) InMemoryRelation
Arguments: [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120, demandChannel#1145113, demandStream#1145114, kpis#1145121], StorageLevel(disk, memory, 2 replicas)

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

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

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

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

(17) Scan ExistingRDD
Output [6]: [shardId#1145100, worklistShardItemId#1145101L, qty#1145102, demandChannel#1145103, demandStream#1145104, kpis#1145105]
Arguments: [shardId#1145100, worklistShardItemId#1145101L, qty#1145102, demandChannel#1145103, demandStream#1145104, kpis#1145105], MapPartitionsRDD[56976] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(18) Filter
Input [6]: [shardId#1145100, worklistShardItemId#1145101L, qty#1145102, demandChannel#1145103, demandStream#1145104, kpis#1145105]
Condition : (isnotnull(worklistShardItemId#1145101L) AND isnotnull(shardId#1145100))

(19) Project
Output [3]: [shardId#1145100 AS cachedShardId#1145106, worklistShardItemId#1145101L AS cachedWorklistShardItemId#1145107L, qty#1145102 AS cachedQty#1145108]
Input [6]: [shardId#1145100, worklistShardItemId#1145101L, qty#1145102, demandChannel#1145103, demandStream#1145104, kpis#1145105]

(20) BroadcastHashJoin [codegen id : 2]
Left keys [2]: [worklistShardItemId#1100458L, shardId#1100457]
Right keys [2]: [cachedWorklistShardItemId#1145107L, cachedShardId#1145106]
Join type: Inner
Join condition: ((qty#1100464 = cachedQty#1145108) OR isnull(qty#1100464))

(21) Project [codegen id : 2]
Output [5]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461]
Input [9]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, cachedShardId#1145106, cachedWorklistShardItemId#1145107L, cachedQty#1145108]

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

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

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

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

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

(27) Scan ExistingRDD [codegen id : 5]
Output [6]: [shardId#1145110, worklistShardItemId#1145111L, qty#1145112, demandChannel#1145113, demandStream#1145114, kpis#1145115]
Arguments: [shardId#1145110, worklistShardItemId#1145111L, qty#1145112, demandChannel#1145113, demandStream#1145114, kpis#1145115], MapPartitionsRDD[56976] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(28) Filter [codegen id : 5]
Input [6]: [shardId#1145110, worklistShardItemId#1145111L, qty#1145112, demandChannel#1145113, demandStream#1145114, kpis#1145115]
Condition : (isnotnull(worklistShardItemId#1145111L) AND isnotnull(shardId#1145110))

(29) Project [codegen id : 5]
Output [6]: [shardId#1145110 AS cachedShardId#1145116, worklistShardItemId#1145111L AS cachedWorklistShardItemId#1145117L, qty#1145112 AS cachedQty#1145118, demandChannel#1145113, demandStream#1145114, kpis#1145115 AS cachedKpis#1145119]
Input [6]: [shardId#1145110, worklistShardItemId#1145111L, qty#1145112, demandChannel#1145113, demandStream#1145114, kpis#1145115]

(30) Exchange
Input [6]: [cachedShardId#1145116, cachedWorklistShardItemId#1145117L, cachedQty#1145118, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119]
Arguments: hashpartitioning(cachedWorklistShardItemId#1145117L, cachedShardId#1145116, 37), ENSURE_REQUIREMENTS, [plan_id=1760143]

(31) Sort [codegen id : 6]
Input [6]: [cachedShardId#1145116, cachedWorklistShardItemId#1145117L, cachedQty#1145118, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119]
Arguments: [cachedWorklistShardItemId#1145117L ASC NULLS FIRST, cachedShardId#1145116 ASC NULLS FIRST], false, 0

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

(33) Project [codegen id : 7]
Output [9]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedQty#1145118 AS qty#1145120, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119 AS kpis#1145121]
Input [11]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, cachedShardId#1145116, cachedWorklistShardItemId#1145117L, cachedQty#1145118, demandChannel#1145113, demandStream#1145114, cachedKpis#1145119]

(34) InMemoryTableScan
Output [6]: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]
Arguments: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334], [isnull(qty#1145334), isnotnull(worklistShardItemId#1145328L), isnotnull(shardId#1145327)]

(35) InMemoryRelation
Arguments: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, periodStart#1145332, periodEnd#1145333, qty#1145334], StorageLevel(disk, memory, 2 replicas)

(36) Filter [codegen id : 2]
Input [6]: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]
Condition : ((isnull(qty#1145334) AND isnotnull(worklistShardItemId#1145328L)) AND isnotnull(shardId#1145327))

(37) BroadcastExchange
Input [6]: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]
Arguments: HashedRelationBroadcastMode(List(input[1, bigint, false], input[0, string, false]),false), [plan_id=1760263]

(38) Scan ExistingRDD
Output [6]: [shardId#1145335, worklistShardItemId#1145336L, qty#1145337, demandChannel#1145338, demandStream#1145339, kpis#1145340]
Arguments: [shardId#1145335, worklistShardItemId#1145336L, qty#1145337, demandChannel#1145338, demandStream#1145339, kpis#1145340], MapPartitionsRDD[56976] at start at FileStorageAdapterImpl.java:171, ExistingRDD, UnknownPartitioning(0)

(39) Filter
Input [6]: [shardId#1145335, worklistShardItemId#1145336L, qty#1145337, demandChannel#1145338, demandStream#1145339, kpis#1145340]
Condition : (isnotnull(worklistShardItemId#1145336L) AND isnotnull(shardId#1145335))

(40) Project
Output [2]: [shardId#1145335 AS cachedShardId#1145341, worklistShardItemId#1145336L AS cachedWorklistShardItemId#1145342L]
Input [6]: [shardId#1145335, worklistShardItemId#1145336L, qty#1145337, demandChannel#1145338, demandStream#1145339, kpis#1145340]

(41) BroadcastHashJoin [codegen id : 3]
Left keys [2]: [worklistShardItemId#1145328L, shardId#1145327]
Right keys [2]: [cachedWorklistShardItemId#1145342L, cachedShardId#1145341]
Join type: Inner
Join condition: None

(42) Project [codegen id : 3]
Output [6]: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334]
Input [8]: [shardId#1145327, worklistShardItemId#1145328L, version#1145329, product#1145330, plant#1145331, qty#1145334, cachedShardId#1145341, cachedWorklistShardItemId#1145342L]

(43) Union

(44) Exchange
Input [6]: [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]
Arguments: hashpartitioning(coalesce(shardId#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120), 37), ENSURE_REQUIREMENTS, [plan_id=1760269]

(45) Sort [codegen id : 4]
Input [6]: [shardId#1145345, worklistShardItemId#1145346L, version#1145347, product#1145348, plant#1145349, qty#1145120]
Arguments: [coalesce(shardId#1145345, ) ASC NULLS FIRST, isnull(shardId#1145345) ASC NULLS FIRST, coalesce(worklistShardItemId#1145346L, 0) ASC NULLS FIRST, isnull(worklistShardItemId#1145346L) ASC NULLS FIRST, coalesce(version#1145347, 0) ASC NULLS FIRST, isnull(version#1145347) ASC NULLS FIRST, coalesce(product#1145348, ) ASC NULLS FIRST, isnull(product#1145348) ASC NULLS FIRST, coalesce(plant#1145349, ) ASC NULLS FIRST, isnull(plant#1145349) ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))) ASC NULLS FIRST, isnull(qty#1145120) ASC NULLS FIRST], false, 0

(46) SortMergeJoin [codegen id : 5]
Left keys [12]: [coalesce(shardId#1100457, ), isnull(shardId#1100457), coalesce(worklistShardItemId#1100458L, 0), isnull(worklistShardItemId#1100458L), coalesce(version#1100459, 0), isnull(version#1100459), coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1100464, 0.0))), isnull(qty#1100464)]
Right keys [12]: [coalesce(shardId#1145345, ), isnull(shardId#1145345), coalesce(worklistShardItemId#1145346L, 0), isnull(worklistShardItemId#1145346L), coalesce(version#1145347, 0), isnull(version#1145347), coalesce(product#1145348, ), isnull(product#1145348), coalesce(plant#1145349, ), isnull(plant#1145349), knownfloatingpointnormalized(normalizenanandzero(coalesce(qty#1145120, 0.0))), isnull(qty#1145120)]
Join type: LeftAnti
Join condition: None

(47) Project [codegen id : 5]
Output [10]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, null AS demandChannel#1145353, null AS demandStream#1145354, [] AS kpis#1145388, true AS isNewlyCalculated#1145356]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464]

(48) InMemoryTableScan
Output [9]: [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]
Arguments: [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]

(49) InMemoryRelation
Arguments: [shardId#1145358, worklistShardItemId#1145359L, version#1145360, product#1145361, plant#1145362, qty#1145386, demandChannel#1145379, demandStream#1145380, kpis#1145387], StorageLevel(disk, memory, 2 replicas)

(50) Project [codegen id : 6]
Output [10]: [shardId#1145358, worklistShardItemId#1145359L, version#1145360, product#1145361, plant#1145362, qty#1145386, demandChannel#1145379, demandStream#1145380, kpis#1145387, false AS isNewlyCalculated#1145357]
Input [9]: [demandChannel#1145379, demandStream#1145380, kpis#1145387, plant#1145362, product#1145361, qty#1145386, shardId#1145358, version#1145360, worklistShardItemId#1145359L]

(51) Union

(52) Filter [codegen id : 1]
Input [7]: [demandChannel#1145353, demandStream#1145354, isNewlyCalculated#1145356, kpis#1145388, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]
Condition : ((NOT isNewlyCalculated#1145356 AND isnotnull(shardId#1100457)) AND isnotnull(worklistShardItemId#1100458L))

(53) Project [codegen id : 1]
Output [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388]
Input [7]: [demandChannel#1145353, demandStream#1145354, isNewlyCalculated#1145356, kpis#1145388, qty#1100464, shardId#1100457, worklistShardItemId#1100458L]

(54) InMemoryTableScan
Output [6]: [shardId#1148727, worklistShardItemId#1148728L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]
Arguments: [shardId#1148727, worklistShardItemId#1148728L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918], [isnotnull(shardId#1148727), isnotnull(worklistShardItemId#1148728L)]

(55) InMemoryRelation
Arguments: [shardId#1148727, worklistShardItemId#1148728L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918], StorageLevel(disk, memory, 2 replicas)

(56) InMemoryTableScan
Output [1]: [prodPlantResults#1147863]
Arguments: [prodPlantResults#1147863]

(57) InMemoryRelation
Arguments: [prodPlantResults#1147863], StorageLevel(disk, memory, 2 replicas)

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

(59) SerializeFromObject [codegen id : 1]
Input [1]: [obj#1147852]
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#1147855, 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#1147856]

(60) Filter [codegen id : 1]
Input [2]: [performanceMeasurements#1147855, prodPlantResults#1147856]
Condition : ((size(prodPlantResults#1147856, true) > 0) AND isnotnull(prodPlantResults#1147856))

(61) Project [codegen id : 1]
Output [1]: [prodPlantResults#1147856]
Input [2]: [performanceMeasurements#1147855, prodPlantResults#1147856]

(62) Generate [codegen id : 1]
Input [1]: [prodPlantResults#1147856]
Arguments: explode(prodPlantResults#1147856), false, [prodPlantResults#1147863]

(63) Project
Output [6]: [prodPlantResults#1147863.productId AS product#1147882, prodPlantResults#1147863.plantId AS plant#1147883, null AS qty#1147909, null AS demandChannel#1147889, null AS demandStream#1147890, transform(prodPlantResults#1147863.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1147918]
Input [1]: [prodPlantResults#1147863]

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

(65) InMemoryRelation
Arguments: [prodPlantResults#1147908], StorageLevel(disk, memory, 2 replicas)

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

(67) Project [codegen id : 1]
Output [3]: [prodPlantResults#1147908.productId AS _extract_productId#1148054, prodPlantResults#1147908.plantId AS _extract_plantId#1148055, prodPlantResults#1147908.quantityKpiResults AS _extract_quantityKpiResults#1148056]
Input [1]: [prodPlantResults#1147908]

(68) Generate [codegen id : 1]
Input [3]: [_extract_productId#1148054, _extract_plantId#1148055, _extract_quantityKpiResults#1148056]
Arguments: explode(_extract_quantityKpiResults#1148056), [_extract_productId#1148054, _extract_plantId#1148055], false, [quantityKpiResults#1147875]

(69) Project
Output [6]: [_extract_productId#1148054 AS product#1147869, _extract_plantId#1148055 AS plant#1147870, quantityKpiResults#1147875.quantity AS qty#1147876, null AS demandChannel#1147878, null AS demandStream#1147879, transform(quantityKpiResults#1147875.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1148052]
Input [3]: [_extract_productId#1148054, _extract_plantId#1148055, quantityKpiResults#1147875]

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

(71) InMemoryRelation
Arguments: [prodPlantResults#1147913], StorageLevel(disk, memory, 2 replicas)

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

(73) Project [codegen id : 2]
Output [3]: [prodPlantResults#1147913.productId AS _extract_productId#1148057, prodPlantResults#1147913.plantId AS _extract_plantId#1148058, prodPlantResults#1147913.demandChannelStreamKpiResults AS _extract_demandChannelStreamKpiResults#1148059]
Input [1]: [prodPlantResults#1147913]

(74) Generate [codegen id : 2]
Input [3]: [_extract_productId#1148057, _extract_plantId#1148058, _extract_demandChannelStreamKpiResults#1148059]
Arguments: explode(_extract_demandChannelStreamKpiResults#1148059), [_extract_productId#1148057, _extract_plantId#1148058], false, [demandChannelStreamKpiResults#1147897]

(75) Project
Output [6]: [_extract_productId#1148057 AS product#1147891, _extract_plantId#1148058 AS plant#1147892, null AS qty#1147914, demandChannelStreamKpiResults#1147897.demandChannel AS demandChannel#1147899, demandChannelStreamKpiResults#1147897.demandStream AS demandStream#1147901, transform(demandChannelStreamKpiResults#1147897.kpiResults, lambdafunction(struct(label, lambda kpi#1147919.label, dateTime, lambda kpi#1147919.datetime, value, lambda kpi#1147919.value), lambda kpi#1147919, false)) AS kpis#1148053]
Input [3]: [_extract_productId#1148057, _extract_plantId#1148058, demandChannelStreamKpiResults#1147897]

(76) Union

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

(78) InMemoryRelation
Arguments: [shardId#1100457, worklistShardItemId#1100458L, version#1100459, product#1100460, plant#1100461, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388, isNewlyCalculated#1145356], StorageLevel(disk, memory, 2 replicas)

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

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

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

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

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

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

(85) BroadcastHashJoin [codegen id : 5]
Left keys [4]: [coalesce(product#1147882, ), isnull(product#1147882), coalesce(plant#1147883, ), isnull(plant#1147883)]
Right keys [4]: [coalesce(product#1100460, ), isnull(product#1100460), coalesce(plant#1100461, ), isnull(plant#1100461)]
Join type: Inner
Join condition: ((qty#1147909 <=> qty#1100464) OR isnull(qty#1100464))

(86) Project [codegen id : 5]
Output [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]
Input [11]: [product#1147882, plant#1147883, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918, shardId#1100457, worklistShardItemId#1100458L, product#1100460, plant#1100461, qty#1100464]

(87) Sort [codegen id : 5]
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]
Arguments: [demandChannel#1147889 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, knownfloatingpointnormalized(normalizenanandzero(qty#1147909)) AS qty#1147909 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1147890 ASC NULLS FIRST], false, 0

(88) SortAggregate
Input [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]
Keys [5]: [demandChannel#1147889, shardId#1100457, knownfloatingpointnormalized(normalizenanandzero(qty#1147909)) AS qty#1147909, worklistShardItemId#1100458L, demandStream#1147890]
Functions [1]: [partial_first(kpis#1147918, false)]
Aggregate Attributes [2]: [first#1148125, valueSet#1148126]
Results [7]: [demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, first#1148127, valueSet#1148128]

(89) Exchange
Input [7]: [demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, first#1148127, valueSet#1148128]
Arguments: hashpartitioning(demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, 37), ENSURE_REQUIREMENTS, [plan_id=1761067]

(90) Sort [codegen id : 6]
Input [7]: [demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, first#1148127, valueSet#1148128]
Arguments: [demandChannel#1147889 ASC NULLS FIRST, shardId#1100457 ASC NULLS FIRST, qty#1147909 ASC NULLS FIRST, worklistShardItemId#1100458L ASC NULLS FIRST, demandStream#1147890 ASC NULLS FIRST], false, 0

(91) SortAggregate
Input [7]: [demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890, first#1148127, valueSet#1148128]
Keys [5]: [demandChannel#1147889, shardId#1100457, qty#1147909, worklistShardItemId#1100458L, demandStream#1147890]
Functions [1]: [first(kpis#1147918, false)]
Aggregate Attributes [1]: [first(kpis#1147918)()#1148050]
Results [6]: [shardId#1100457, worklistShardItemId#1100458L, qty#1147909, demandChannel#1147889, demandStream#1147890, first(kpis#1147918)()#1148050 AS kpis#1148051]

(92) Filter [codegen id : 2]
Input [6]: [shardId#1148727, worklistShardItemId#1148728L, qty#1147909, demandChannel#1147889, demandStream#1147890, kpis#1147918]
Condition : (isnotnull(shardId#1148727) AND isnotnull(worklistShardItemId#1148728L))

(93) Union

(94) InMemoryTableScan
Output [3]: [shardId#1148819, worklistShardItemId#1148820L, version#1148821]
Arguments: [shardId#1148819, worklistShardItemId#1148820L, version#1148821], [isnotnull(shardId#1148819), isnotnull(worklistShardItemId#1148820L)]

(95) InMemoryRelation
Arguments: [shardId#1148819, worklistShardItemId#1148820L, version#1148821, product#1148822, plant#1148823, qty#1148826, demandChannel#1148875, demandStream#1148876, kpis#1148879, isNewlyCalculated#1148878], StorageLevel(disk, memory, 2 replicas)

(96) Filter [codegen id : 3]
Input [3]: [shardId#1148819, worklistShardItemId#1148820L, version#1148821]
Condition : (isnotnull(shardId#1148819) AND isnotnull(worklistShardItemId#1148820L))

(97) HashAggregate [codegen id : 3]
Input [3]: [shardId#1148819, worklistShardItemId#1148820L, version#1148821]
Keys [2]: [shardId#1148819, worklistShardItemId#1148820L]
Functions [1]: [partial_max(version#1148821)]
Aggregate Attributes [1]: [max#1149301]
Results [3]: [shardId#1148819, worklistShardItemId#1148820L, max#1149302]

(98) Exchange
Input [3]: [shardId#1148819, worklistShardItemId#1148820L, max#1149302]
Arguments: hashpartitioning(shardId#1148819, worklistShardItemId#1148820L, 37), ENSURE_REQUIREMENTS, [plan_id=1761224]

(99) HashAggregate [codegen id : 4]
Input [3]: [shardId#1148819, worklistShardItemId#1148820L, max#1149302]
Keys [2]: [shardId#1148819, worklistShardItemId#1148820L]
Functions [1]: [max(version#1148821)]
Aggregate Attributes [1]: [max(version#1148821)#1148726]
Results [3]: [shardId#1148819, worklistShardItemId#1148820L, (max(version#1148821)#1148726 + 1) AS version#1148722]

(100) BroadcastExchange
Input [3]: [shardId#1148819, worklistShardItemId#1148820L, version#1148722]
Arguments: HashedRelationBroadcastMode(List(input[0, string, true], input[1, bigint, true]),false), [plan_id=1761228]

(101) BroadcastHashJoin [codegen id : 5]
Left keys [2]: [shardId#1100457, worklistShardItemId#1100458L]
Right keys [2]: [shardId#1148819, worklistShardItemId#1148820L]
Join type: Inner
Join condition: None

(102) Project [codegen id : 5]
Output [7]: [shardId#1100457, worklistShardItemId#1100458L, version#1148722, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388]
Input [9]: [shardId#1100457, worklistShardItemId#1100458L, qty#1100464, demandChannel#1145353, demandStream#1145354, kpis#1145388, shardId#1148819, worklistShardItemId#1148820L, version#1148722]

(103) CollectLimit
Input: []
Arguments: 1

SQL / DataFrame Properties

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