| 1889 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#44943]
+- SortMergeJoin [articlehierarchynode#35895], [articlehierarchynode#44934], Inner
:- Project [articlehierarchynode#35895]
: +- Filter (rank#44953 = 1)
: +- Window [rank(stepCnt#35920) windowspecdefinition(articlehierarchynode#35895, stepCnt#35920 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rank#44953], [articlehierarchynode#35895], [stepCnt#35920 DESC NULLS LAST]
: +- WindowGroupLimit [articlehierarchynode#35895], [stepCnt#35920 DESC NULLS LAST], rank(stepCnt#35920), 1, Final
: +- Sort [articlehierarchynode#35895 ASC NULLS FIRST, stepCnt#35920 DESC NULLS LAST], false, 0
: +- Exchange hashpartitioning(articlehierarchynode#35895, 200), ENSURE_REQUIREMENTS, [plan_id=58250]
: +- WindowGroupLimit [articlehierarchynode#35895], [stepCnt#35920 DESC NULLS LAST], rank(stepCnt#35920), 1, Partial
: ...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
62.2 KiB |
0.0 B |
| 1937 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#53831, plant#53830, blockedForReplenishmentStartingFrom#53832, 2026-04-26 22:00:00 AS validFrom#53905, 2026-05-07 21:59:59 AS validTo#53913, null AS prodPlantListingValidFrom#53922, null AS prodPlantListingValidTo#53923]
+- BroadcastHashJoin [plant#53830.internalRefUUID], [location#52200], Inner, BuildRight, false
:- Project [plant#53830, product#53831, blockedForReplenishmentStartingFrom#53832]
: +- BroadcastHashJoin [product#53831.internalRefUUID], [product#35330], Inner, BuildRight, false
: :- Project [plant#53830, product#53831, blockedForReplenishmentStartingFrom#53832]
: : +- Filter ((productionAspect#53833.productPlanningPlants.mrpType.internalRefUUID IN (b4c29f1fb1ce4a14f79d5e6c89b9a390,d66ec59835101f21bab4c0d72dc4d2cc,bf6ef7384b34e4b50b15369994392a77,92b96d3705f7916897415c0a7ff5afda,2cbeb1c6ad4b5cb7b181162c85952823,6549c8226c3377a357ae64708cd1d58c,83a97fa47395df5fab0af8d66f461449) AND isnotnull(product#538...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
6.8 MiB |
0.0 B |
| 1947 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#53831, plant#53830, validFrom#53905, CASE WHEN (validTo#53913 > cast(blockedForReplenishmentStartingFrom#53832 as timestamp)) THEN cast(blockedForReplenishmentStartingFrom#53832 as timestamp) ELSE validTo#53913 END AS validTo#54345, prodPlantListingValidFrom#53922, prodPlantListingValidTo#53923]
+- Filter ((isnotnull(blockedForReplenishmentStartingFrom#53832) AND (validFrom#53905 < cast(blockedForReplenishmentStartingFrom#53832 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#53832))
+- InMemoryTableScan [blockedForReplenishmentStartingFrom#53832, plant#53830, prodPlantListingValidFrom#53922, prodPlantListingValidTo#53923, product#53831, validFrom#53905, validTo#53913], [((isnotnull(blockedForReplenishmentStartingFrom#53832) AND (validFrom#53905 < cast(blockedForReplenishmentStartingFrom#53832 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#53832))]
+- InMemoryRelation [product#53831, plant#53830, blocke...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
6.3 MiB |
0.0 B |
| 1989 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#53831, plant#53830, supplier#54731, validFrom#54901, validOn#54936, listedValidTo#54903, sosUuidFinal#54978 AS sourceOfSupplyUuid#55061, localTimeZoneCode#54691, prodPlantListingValidFrom#53922, prodPlantListingValidTo#53923]
+- Filter (((rank#54999 = 1) AND (rowNumber#55036 = 1)) AND ((sosTypePrio#54837 = 1) OR ((((sosTypePrio#54837 = 0) AND isnotnull(sosTypeBUuid#54953)) AND NOT (sosTypeBUuid#54953 = )) AND NOT (sosTypeBUuid#54953 = sourceOfSupplyUuid#54904))))
+- Window [row_number() windowspecdefinition(_w0#55039, _w1#55040, validOn#54936, sosTypePrio#54837 ASC NULLS FIRST, priority#54742 ASC NULLS FIRST, noPlant#54857 ASC NULLS FIRST, matchPurOrg#54878 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rowNumber#55036], [_w0#55039, _w1#55040, validOn#54936], [sosTypePrio#54837 ASC NULLS FIRST, priority#54742 ASC NULLS FIRST, noPlant#54857 ASC NULLS FIRST, matchPurOrg#54878 ASC NULLS FIRST]
...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
17.8 MiB |
0.0 B |
| 3737 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#57867, plant#57868, supplier#57869, sourceOfSupplyUuid#57872, orderDateTime#58599, deliveryDateTime#58597, availabilityDateTime#58598, prodPlantListingValidFrom#57875, prodPlantListingValidTo#57876, nextAvailabilityDateTime#58609]
+- Filter (orderDateTime#58599 <= 2026-04-27 21:59:59)
+- Window [lead(availabilityDateTime#58598, 1, null) windowspecdefinition(_w0#58612, _w1#58613, availabilitydatetime#58598 ASC NULLS FIRST, specifiedwindowframe(RowFrame, 1, 1)) AS nextAvailabilityDateTime#58609], [_w0#58612, _w1#58613], [availabilitydatetime#58598 ASC NULLS FIRST]
+- Sort [_w0#58612 ASC NULLS FIRST, _w1#58613 ASC NULLS FIRST, availabilitydatetime#58598 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(_w0#58612, _w1#58613, 200), ENSURE_REQUIREMENTS, [plan_id=116422]
+- Project [product#57867, plant#57868, supplier#57869, sourceOfSupplyUuid#57872, cast(concat(items_orderDate#58532, , items_orderTime#585...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
11.5 MiB |
0.0 B |
| 3747 |
AdaptiveSparkPlan isFinalPlan=false
+- Filter isnull(nextAvailabilityDateTime#58609)
+- InMemoryTableScan [product#57867, plant#57868, supplier#57869, sourceOfSupplyUuid#57872, orderDateTime#58599, deliveryDateTime#58597, availabilityDateTime#58598, prodPlantListingValidFrom#57875, prodPlantListingValidTo#57876, nextAvailabilityDateTime#58609], [isnull(nextAvailabilityDateTime#58609)]
+- InMemoryRelation [product#57867, plant#57868, supplier#57869, sourceOfSupplyUuid#57872, orderDateTime#58599, deliveryDateTime#58597, availabilityDateTime#58598, prodPlantListingValidFrom#57875, prodPlantListingValidTo#57876, nextAvailabilityDateTime#58609], StorageLevel(disk, memory, 2 replicas)
+- AdaptiveSparkPlan isFinalPlan=false
+- Project [product#57867, plant#57868, supplier#57869, sourceOfSupplyUuid#57872, orderDateTime#58599, deliveryDateTime#58597, availabilityDateTime#58598, prodPlantListingValidFrom#57875, prodPlantListingValidTo#57876, nextAvailabilityDateTime#58609...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
8.2 KiB |
0.0 B |
| 4391 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#116635]
+- SortMergeJoin [articlehierarchynode#107874], [articlehierarchynode#116626], Inner
:- Project [articlehierarchynode#107874]
: +- Filter (rank#116645 = 1)
: +- Window [rank(stepCnt#107899) windowspecdefinition(articlehierarchynode#107874, stepCnt#107899 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rank#116645], [articlehierarchynode#107874], [stepCnt#107899 DESC NULLS LAST]
: +- WindowGroupLimit [articlehierarchynode#107874], [stepCnt#107899 DESC NULLS LAST], rank(stepCnt#107899), 1, Final
: +- Sort [articlehierarchynode#107874 ASC NULLS FIRST, stepCnt#107899 DESC NULLS LAST], false, 0
: +- Exchange hashpartitioning(articlehierarchynode#107874, 200), ENSURE_REQUIREMENTS, [plan_id=135141]
: +- WindowGroupLimit [articlehierarchynode#107874], [stepCnt#107899 DESC NULLS LAST], rank(stepCnt#107899), 1, Partia...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
15.9 KiB |
0.0 B |
| 4445 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#124891, plant#124890, blockedForReplenishmentStartingFrom#124892, 2026-04-26 22:00:00 AS validFrom#124965, 2026-05-07 21:59:59 AS validTo#124973, null AS prodPlantListingValidFrom#124982, null AS prodPlantListingValidTo#124983]
+- BroadcastHashJoin [plant#124890.internalRefUUID], [location#123818], Inner, BuildRight, false
:- Project [plant#124890, product#124891, blockedForReplenishmentStartingFrom#124892]
: +- BroadcastHashJoin [product#124891.internalRefUUID], [product#107331], Inner, BuildRight, false
: :- Project [plant#124890, product#124891, blockedForReplenishmentStartingFrom#124892]
: : +- Filter ((productionAspect#124893.productPlanningPlants.mrpType.internalRefUUID IN (b4c29f1fb1ce4a14f79d5e6c89b9a390,d66ec59835101f21bab4c0d72dc4d2cc,bf6ef7384b34e4b50b15369994392a77,92b96d3705f7916897415c0a7ff5afda,2cbeb1c6ad4b5cb7b181162c85952823,6549c8226c3377a357ae64708cd1d58c,83a97fa47395df5fab0af8d66f461449) AND isn...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
648.2 KiB |
0.0 B |
| 4455 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#124891, plant#124890, validFrom#124965, CASE WHEN (validTo#124973 > cast(blockedForReplenishmentStartingFrom#124892 as timestamp)) THEN cast(blockedForReplenishmentStartingFrom#124892 as timestamp) ELSE validTo#124973 END AS validTo#125675, prodPlantListingValidFrom#124982, prodPlantListingValidTo#124983]
+- Filter ((isnotnull(blockedForReplenishmentStartingFrom#124892) AND (validFrom#124965 < cast(blockedForReplenishmentStartingFrom#124892 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#124892))
+- InMemoryTableScan [blockedForReplenishmentStartingFrom#124892, plant#124890, prodPlantListingValidFrom#124982, prodPlantListingValidTo#124983, product#124891, validFrom#124965, validTo#124973], [((isnotnull(blockedForReplenishmentStartingFrom#124892) AND (validFrom#124965 < cast(blockedForReplenishmentStartingFrom#124892 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#124892))]
+- InMemoryRelation [product#1...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
647.5 KiB |
0.0 B |
| 4497 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#124891, plant#124890, supplier#126061, validFrom#126231, validOn#126266, listedValidTo#126233, sosUuidFinal#126308 AS sourceOfSupplyUuid#126391, localTimeZoneCode#126021, prodPlantListingValidFrom#124982, prodPlantListingValidTo#124983]
+- Filter (((rank#126329 = 1) AND (rowNumber#126366 = 1)) AND ((sosTypePrio#126167 = 1) OR ((((sosTypePrio#126167 = 0) AND isnotnull(sosTypeBUuid#126283)) AND NOT (sosTypeBUuid#126283 = )) AND NOT (sosTypeBUuid#126283 = sourceOfSupplyUuid#126234))))
+- Window [row_number() windowspecdefinition(_w0#126369, _w1#126370, validOn#126266, sosTypePrio#126167 ASC NULLS FIRST, priority#126072 ASC NULLS FIRST, noPlant#126187 ASC NULLS FIRST, matchPurOrg#126208 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rowNumber#126366], [_w0#126369, _w1#126370, validOn#126266], [sosTypePrio#126167 ASC NULLS FIRST, priority#126072 ASC NULLS FIRST, noPlant#126187 ASC NULLS FIRST, matchPurOrg...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
2.4 MiB |
0.0 B |
| 6189 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#129511, plant#129512, supplier#129513, sourceOfSupplyUuid#129516, orderDateTime#130243, deliveryDateTime#130241, availabilityDateTime#130242, prodPlantListingValidFrom#129519, prodPlantListingValidTo#129520, nextAvailabilityDateTime#130253]
+- Filter (orderDateTime#130243 <= 2026-04-27 21:59:59)
+- Window [lead(availabilityDateTime#130242, 1, null) windowspecdefinition(_w0#130256, _w1#130257, availabilitydatetime#130242 ASC NULLS FIRST, specifiedwindowframe(RowFrame, 1, 1)) AS nextAvailabilityDateTime#130253], [_w0#130256, _w1#130257], [availabilitydatetime#130242 ASC NULLS FIRST]
+- Sort [_w0#130256 ASC NULLS FIRST, _w1#130257 ASC NULLS FIRST, availabilitydatetime#130242 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(_w0#130256, _w1#130257, 200), ENSURE_REQUIREMENTS, [plan_id=190908]
+- Project [product#129511, plant#129512, supplier#129513, sourceOfSupplyUuid#129516, cast(concat(items_orderDate#1...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
2.1 MiB |
0.0 B |
| 6199 |
AdaptiveSparkPlan isFinalPlan=false
+- Filter isnull(nextAvailabilityDateTime#130253)
+- InMemoryTableScan [product#129511, plant#129512, supplier#129513, sourceOfSupplyUuid#129516, orderDateTime#130243, deliveryDateTime#130241, availabilityDateTime#130242, prodPlantListingValidFrom#129519, prodPlantListingValidTo#129520, nextAvailabilityDateTime#130253], [isnull(nextAvailabilityDateTime#130253)]
+- InMemoryRelation [product#129511, plant#129512, supplier#129513, sourceOfSupplyUuid#129516, orderDateTime#130243, deliveryDateTime#130241, availabilityDateTime#130242, prodPlantListingValidFrom#129519, prodPlantListingValidTo#129520, nextAvailabilityDateTime#130253], StorageLevel(disk, memory, 2 replicas)
+- AdaptiveSparkPlan isFinalPlan=false
+- Project [product#129511, plant#129512, supplier#129513, sourceOfSupplyUuid#129516, orderDateTime#130243, deliveryDateTime#130241, availabilityDateTime#130242, prodPlantListingValidFrom#129519, prodPlantListingValidTo#129520,...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
8.2 KiB |
0.0 B |
| 43015 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#663429]
+- SortMergeJoin [articlehierarchynode#654370], [articlehierarchynode#663420], Inner
:- Project [articlehierarchynode#654370]
: +- Filter (rank#663439 = 1)
: +- Window [rank(stepCnt#654395) windowspecdefinition(articlehierarchynode#654370, stepCnt#654395 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rank#663439], [articlehierarchynode#654370], [stepCnt#654395 DESC NULLS LAST]
: +- WindowGroupLimit [articlehierarchynode#654370], [stepCnt#654395 DESC NULLS LAST], rank(stepCnt#654395), 1, Final
: +- Sort [articlehierarchynode#654370 ASC NULLS FIRST, stepCnt#654395 DESC NULLS LAST], false, 0
: +- Exchange hashpartitioning(articlehierarchynode#654370, 200), ENSURE_REQUIREMENTS, [plan_id=725537]
: +- WindowGroupLimit [articlehierarchynode#654370], [stepCnt#654395 DESC NULLS LAST], rank(stepCnt#654395), 1, Partia...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
15.9 KiB |
0.0 B |
| 43073 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#672057, plant#672056, blockedForReplenishmentStartingFrom#672058, 2026-04-21 22:00:00 AS validFrom#672131, 2026-05-02 21:59:59 AS validTo#672139, null AS prodPlantListingValidFrom#672148, null AS prodPlantListingValidTo#672149]
+- BroadcastHashJoin [plant#672056.internalRefUUID], [location#670962], Inner, BuildRight, false
:- Project [plant#672056, product#672057, blockedForReplenishmentStartingFrom#672058]
: +- BroadcastHashJoin [product#672057.internalRefUUID], [product#653805], Inner, BuildRight, false
: :- Project [plant#672056, product#672057, blockedForReplenishmentStartingFrom#672058]
: : +- Filter ((productionAspect#672059.productPlanningPlants.mrpType.internalRefUUID IN (b4c29f1fb1ce4a14f79d5e6c89b9a390,d66ec59835101f21bab4c0d72dc4d2cc,bf6ef7384b34e4b50b15369994392a77,92b96d3705f7916897415c0a7ff5afda,2cbeb1c6ad4b5cb7b181162c85952823,6549c8226c3377a357ae64708cd1d58c,83a97fa47395df5fab0af8d66f461449) AND isn...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
648.0 KiB |
0.0 B |
| 43083 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#672057, plant#672056, validFrom#672131, CASE WHEN (validTo#672139 > cast(blockedForReplenishmentStartingFrom#672058 as timestamp)) THEN cast(blockedForReplenishmentStartingFrom#672058 as timestamp) ELSE validTo#672139 END AS validTo#672841, prodPlantListingValidFrom#672148, prodPlantListingValidTo#672149]
+- Filter ((isnotnull(blockedForReplenishmentStartingFrom#672058) AND (validFrom#672131 < cast(blockedForReplenishmentStartingFrom#672058 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#672058))
+- InMemoryTableScan [blockedForReplenishmentStartingFrom#672058, plant#672056, prodPlantListingValidFrom#672148, prodPlantListingValidTo#672149, product#672057, validFrom#672131, validTo#672139], [((isnotnull(blockedForReplenishmentStartingFrom#672058) AND (validFrom#672131 < cast(blockedForReplenishmentStartingFrom#672058 as timestamp))) OR isnull(blockedForReplenishmentStartingFrom#672058))]
+- InMemoryRelation [product#6...
|
Disk Memory Serialized 2x Replicated
|
12 |
100.00% |
647.4 KiB |
0.0 B |
| 43106 |
Delta Table State #4 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-plant-plant/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
3.4 KiB |
0.0 B |
| 43110 |
Delta Table State with Stats #4 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-plant-plant/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
2.2 KiB |
0.0 B |
| 43123 |
Delta Table State #5 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-sourceofsupply-sourceofsupply/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
4.7 KiB |
0.0 B |
| 43127 |
Delta Table State with Stats #5 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/cornerstone/sap-cic-sourceofsupply-sourceofsupply/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
2.6 KiB |
0.0 B |
| 43163 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#672057, plant#672056, supplier#673271, validFrom#673441, validOn#673476, listedValidTo#673443, sosUuidFinal#673518 AS sourceOfSupplyUuid#673601, localTimeZoneCode#673209, prodPlantListingValidFrom#672148, prodPlantListingValidTo#672149]
+- Filter (((rank#673539 = 1) AND (rowNumber#673576 = 1)) AND ((sosTypePrio#673377 = 1) OR ((((sosTypePrio#673377 = 0) AND isnotnull(sosTypeBUuid#673493)) AND NOT (sosTypeBUuid#673493 = )) AND NOT (sosTypeBUuid#673493 = sourceOfSupplyUuid#673444))))
+- Window [row_number() windowspecdefinition(_w0#673579, _w1#673580, validOn#673476, sosTypePrio#673377 ASC NULLS FIRST, priority#673282 ASC NULLS FIRST, noPlant#673397 ASC NULLS FIRST, matchPurOrg#673418 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rowNumber#673576], [_w0#673579, _w1#673580, validOn#673476], [sosTypePrio#673377 ASC NULLS FIRST, priority#673282 ASC NULLS FIRST, noPlant#673397 ASC NULLS FIRST, matchPurOrg...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
2.4 MiB |
0.0 B |
| 43285 |
Delta Table State #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-schedulinggroupassignment/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
6.0 KiB |
0.0 B |
| 43289 |
Delta Table State with Stats #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-schedulinggroupassignment/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
5.1 KiB |
0.0 B |
| 43302 |
Delta Table State #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-schedulinggroup/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
2027.0 B |
0.0 B |
| 43306 |
Delta Table State with Stats #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-schedulinggroup/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
1475.0 B |
0.0 B |
| 43319 |
Delta Table State #2 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-orderdeliveryschedule/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
21.0 KiB |
0.0 B |
| 43323 |
Delta Table State with Stats #2 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/ods-internal/sap-cic-orderdeliveryscheduling-orderdeliveryschedule/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
15.8 KiB |
0.0 B |
| 44914 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#677632, plant#677633, supplier#677634, sourceOfSupplyUuid#677637, orderDateTime#678430, deliveryDateTime#678428, availabilityDateTime#678429, prodPlantListingValidFrom#677640, prodPlantListingValidTo#677641, nextAvailabilityDateTime#678440]
+- Filter (orderDateTime#678430 <= 2026-04-22 21:59:59)
+- Window [lead(availabilityDateTime#678429, 1, null) windowspecdefinition(_w0#678443, _w1#678444, availabilitydatetime#678429 ASC NULLS FIRST, specifiedwindowframe(RowFrame, 1, 1)) AS nextAvailabilityDateTime#678440], [_w0#678443, _w1#678444], [availabilitydatetime#678429 ASC NULLS FIRST]
+- Sort [_w0#678443 ASC NULLS FIRST, _w1#678444 ASC NULLS FIRST, availabilitydatetime#678429 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(_w0#678443, _w1#678444, 200), ENSURE_REQUIREMENTS, [plan_id=784406]
+- Project [product#677632, plant#677633, supplier#677634, sourceOfSupplyUuid#677637, cast(concat(items_orderDate#6...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
2.1 MiB |
0.0 B |
| 44924 |
AdaptiveSparkPlan isFinalPlan=false
+- Filter isnull(nextAvailabilityDateTime#678440)
+- InMemoryTableScan [product#677632, plant#677633, supplier#677634, sourceOfSupplyUuid#677637, orderDateTime#678430, deliveryDateTime#678428, availabilityDateTime#678429, prodPlantListingValidFrom#677640, prodPlantListingValidTo#677641, nextAvailabilityDateTime#678440], [isnull(nextAvailabilityDateTime#678440)]
+- InMemoryRelation [product#677632, plant#677633, supplier#677634, sourceOfSupplyUuid#677637, orderDateTime#678430, deliveryDateTime#678428, availabilityDateTime#678429, prodPlantListingValidFrom#677640, prodPlantListingValidTo#677641, nextAvailabilityDateTime#678440], StorageLevel(disk, memory, 2 replicas)
+- AdaptiveSparkPlan isFinalPlan=false
+- Project [product#677632, plant#677633, supplier#677634, sourceOfSupplyUuid#677637, orderDateTime#678430, deliveryDateTime#678428, availabilityDateTime#678429, prodPlantListingValidFrom#677640, prodPlantListingValidTo#677641,...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
8.2 KiB |
0.0 B |
| 46005 |
Delta Table State #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/supplier-group/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
1598.0 B |
0.0 B |
| 46009 |
Delta Table State with Stats #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/supplier-group/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
1050.0 B |
0.0 B |
| 46220 |
AdaptiveSparkPlan isFinalPlan=false
+- Project [product#760797.internalRefUUID AS PRODUCT#762768, plant#760798.internalRefUUID AS LOCATION#762769, supplier#760799.internalRefUUID AS SUPPLIER#762770, orderDateTime#761544 AS ORDERDATETIME#762771, schedulingGroup_internalRefUUID#761349 AS SCHEDULINGGROUPUUID#762772, schedulingGroup_displayId#761352 AS SCHEDULINGGROUPDISPLAYID#762773]
+- Filter isnotnull(nextAvailabilityDateTime#761557)
+- InMemoryTableScan [nextAvailabilityDateTime#761557, orderDateTime#761544, plant#760798, product#760797, schedulingGroup_displayId#761352, schedulingGroup_internalRefUUID#761349, supplier#760799], [isnotnull(nextAvailabilityDateTime#761557)]
+- InMemoryRelation [product#760797, plant#760798, supplier#760799, sourceOfSupplyUuid#760802, orderDateTime#761544, deliveryDateTime#761542, availabilityDateTime#761543, prodPlantListingValidFrom#760805, prodPlantListingValidTo#760806, supplierGroup#760807, schedulingGroup_internalRefUUID#761349, schedulingGroup_disp...
|
Disk Memory Serialized 2x Replicated
|
200 |
100.00% |
1271.8 KiB |
0.0 B |
| 46242 |
Delta Table State #0 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/prp-op-traceability-results/out/crp-workload-determination-service/scheduling-groups/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
33.9 KiB |
0.0 B |
| 46312 |
Delta Table State #1 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
3.1 KiB |
0.0 B |
| 46316 |
Delta Table State with Stats #1 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-dl-stream-service/prp/market-unit/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
1664.0 B |
0.0 B |
| 47137 |
Delta Table State #22 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-workload-determination-service/in/workload-dupl-lock-v2/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
3.9 KiB |
0.0 B |
| 47147 |
Delta Table State with Stats #22 - hdlfs://7da5304c-1f57-47fa-b75a-0f0b4349c280.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-workload-determination-service/in/workload-dupl-lock-v2/_delta_log
|
Disk Memory Serialized 1x Replicated
|
50 |
100.00% |
1050.0 B |
0.0 B |