== Physical Plan ==
Execute SaveIntoDataSourceCommand (1)
+- SaveIntoDataSourceCommand (2)
+- Project (100)
+- Project (99)
+- Project (98)
+- Project (97)
+- Project (96)
+- Project (95)
+- Join (94)
:- Project (89)
: +- Project (88)
: +- Project (87)
: +- Join (86)
: :- Project (82)
: : +- Join (81)
: : :- Project (77)
: : : +- Project (76)
: : : +- Project (75)
: : : +- Project (74)
: : : +- Project (73)
: : : +- Project (72)
: : : +- Project (71)
: : : +- Project (70)
: : : +- Project (69)
: : : +- Project (68)
: : : +- Project (67)
: : : +- Join (66)
: : : :- Project (62)
: : : : +- Project (61)
: : : : +- Project (60)
: : : : +- Project (59)
: : : : +- Project (58)
: : : : +- Project (57)
: : : : +- Join (56)
: : : : :- Project (53)
: : : : : +- Join (52)
: : : : : :- Project (49)
: : : : : : +- Project (48)
: : : : : : +- Project (47)
: : : : : : +- Project (46)
: : : : : : +- Project (45)
: : : : : : +- Join (44)
: : : : : : :- Project (41)
: : : : : : : +- Project (40)
: : : : : : : +- Join (39)
: : : : : : : :- Join (35)
: : : : : : : : :- SubqueryAlias (32)
: : : : : : : : : +- Project (31)
: : : : : : : : : +- Project (30)
: : : : : : : : : +- Project (29)
: : : : : : : : : +- Project (28)
: : : : : : : : : +- Project (27)
: : : : : : : : : +- Project (26)
: : : : : : : : : +- Project (25)
: : : : : : : : : +- Project (24)
: : : : : : : : : +- Join (23)
: : : : : : : : : :- Project (19)
: : : : : : : : : : +- Project (18)
: : : : : : : : : : +- Project (17)
: : : : : : : : : : +- Project (16)
: : : : : : : : : : +- Join (15)
: : : : : : : : : : :- Project (10)
: : : : : : : : : : : +- Project (9)
: : : : : : : : : : : +- Join (8)
: : : : : : : : : : : :- RepartitionByExpression (4)
: : : : : : : : : : : : +- LogicalRelation (3)
: : : : : : : : : : : +- SubqueryAlias (7)
: : : : : : : : : : : +- Repartition (6)
: : : : : : : : : : : +- LogicalRelation (5)
: : : : : : : : : : +- SubqueryAlias (14)
: : : : : : : : : : +- Filter (13)
: : : : : : : : : : +- Repartition (12)
: : : : : : : : : : +- LogicalRelation (11)
: : : : : : : : : +- SubqueryAlias (22)
: : : : : : : : : +- Repartition (21)
: : : : : : : : : +- LogicalRelation (20)
: : : : : : : : +- SubqueryAlias (34)
: : : : : : : : +- LocalRelation (33)
: : : : : : : +- SubqueryAlias (38)
: : : : : : : +- Filter (37)
: : : : : : : +- LocalRelation (36)
: : : : : : +- Aggregate (43)
: : : : : : +- LocalRelation (42)
: : : : : +- Repartition (51)
: : : : : +- LogicalRelation (50)
: : : : +- Repartition (55)
: : : : +- LogicalRelation (54)
: : : +- Project (65)
: : : +- Project (64)
: : : +- LocalRelation (63)
: : +- SubqueryAlias (80)
: : +- Repartition (79)
: : +- LogicalRelation (78)
: +- SubqueryAlias (85)
: +- Repartition (84)
: +- LogicalRelation (83)
+- Project (93)
+- Project (92)
+- Repartition (91)
+- LogicalRelation (90)
(1) Execute SaveIntoDataSourceCommand
Output: []
(2) SaveIntoDataSourceCommand
Arguments: org.apache.spark.sql.delta.sources.DeltaDataSource@702b5b85, [__partition_columns=["shardId","sequenceId"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/prod-plant-snapshot/10000002110], Overwrite
(3) LogicalRelation
Arguments: parquet, [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903], false
(4) RepartitionByExpression
Arguments: [product#913886, plant#913881], 25
(5) LogicalRelation
Arguments: parquet, [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928], false
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#913891 <=> internalUUID#913906)
(9) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 25 more fields]
(10) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 1 more fields]
(11) LogicalRelation
Arguments: parquet, [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#913935.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#913886 <=> product#913936.internalRefUUID) AND (plant#913881 <=> plant#913935.internalRefUUID))
(16) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(17) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(18) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 12 more fields]
(19) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 4 more fields]
(20) LogicalRelation
Arguments: parquet, [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961], false
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#913886 = internalUUID#913951)
(24) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 17 more fields]
(25) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 5 more fields]
(26) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 6 more fields]
(27) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 7 more fields]
(28) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(29) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(30) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 9 more fields]
(31) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#913993, plant#913994, logisticalRoundingRule#913995]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#913986 <=> logisticalRoundingProfile#913993) AND (plant#913881 <=> plant#913994.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#914020, plant#914021, logisticalRoundingRule#914022]
(37) Filter
Arguments: isnull(plant#914021.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#913986 <=> logisticalRoundingProfile#914020)
(40) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 17 more fields]
(41) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#914011, unitOfMeasure#914012]
(43) Aggregate
Arguments: [logisticalRoundingRule#914011], [logisticalRoundingRule#914011, collect_list(unitOfMeasure#914012.internalRefUUID, 0, 0) AS preferredUOMs#914013]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#914024.logisticalRoundingRule = logisticalRoundingRule#914011)
(45) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(46) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(47) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(49) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#913886 <=> product#914037) AND (plant#913881 <=> plant#914038)) AND (orderDateTime#913887 <=> orderDateTime#914039))
(53) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#914041, descriptions#914042, minServiceLevel#914043, minServiceLevelMinStock#914044, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047, profileType#914048, eventtype#914049], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#914040 <=> constraintProfile#914041)
(57) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 20 more fields]
(58) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(59) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(60) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 15 more fields]
(61) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 15 more fields]
(62) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#914078, orderProposalItemId#914079, constraintOverwrites#914080]
(64) Project
Arguments: [orderProposalId#914078, orderProposalItemId#914079, filter(constraintOverwrites#914080, lambdafunction(((isnotnull(lambda x_2379#914082.label) AND isnotnull(lambda x_2379#914082.isActive)) AND (((lambda x_2379#914082.isActive = false) OR isnotnull(lambda x_2379#914082.value)) OR (lambda x_2379#914082.label <=> minOrderQuantity))), lambda x_2379#914082, false)) AS constraintOverwrites#914081]
(65) Project
Arguments: [orderProposalId#914078, orderProposalItemId#914079, transform(constraintOverwrites#914081, lambdafunction(struct(label, lambda x_2380#914087.label, value, CASE WHEN ((lambda x_2380#914087.label = minOrderQuantity) OR (lambda x_2380#914087.label = lockedOrderQuantity)) THEN round(lambda x_2380#914087.value, 0) ELSE lambda x_2380#914087.value END, isActive, lambda x_2380#914087.isActive), lambda x_2380#914087, false)) AS constraintOverwrites#914086]
(66) Join
Arguments: LeftOuter, ((orderProposalId#913895L = cast(orderProposalId#914078 as bigint)) AND (orderProposalItemId#913903 = orderProposalItemId#914079))
(67) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(68) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(69) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 14 more fields]
(72) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 16 more fields]
(74) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 17 more fields]
(75) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 18 more fields]
(76) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 19 more fields]
(77) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#914117, internalUUID#914118, code#914119, name#914120, commercialCode#914121, isoCode#914122], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) Join
Arguments: LeftOuter, (filter(filter(productInformation#913962.unitOfMeasures, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID <=> internalUUID#914118)
(82) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(83) LogicalRelation
Arguments: parquet, [systemId#914153, internalUUID#914154, code#914155, name#914156, commercialCode#914157, isoCode#914158], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) Join
Arguments: LeftOuter, (filter(filter(productInformation#913962.unitOfMeasures, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID <=> internalUUID#914154)
(87) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(88) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(89) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191], false
(91) Repartition
Arguments: 25, true
(92) Project
Arguments: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191, cast(null as string) AS supplyingPlant#914193]
(93) Project
Arguments: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191, supplyingPlant#914193, cast(null as string) AS productGroup#914194]
(94) Join
Arguments: LeftOuter, (((((((supplierGroup#913879 <=> supplierGroup#914189) AND (supplier#913880 <=> supplier#914184)) AND (subrange#913883 <=> subrange#914185)) AND (plant#913881 <=> plant#914186)) AND (deliveryDateTime#913882 <=> deliveryDateTime#914187)) AND (supplyingPlant#913884 <=> supplyingPlant#914193)) AND (productGroup#913885 <=> productGroup#914194))
(95) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(96) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(97) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(98) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(99) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]