== 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@3aed3c7c, [__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/10000002109], Overwrite
(3) LogicalRelation
Arguments: parquet, [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169], false
(4) RepartitionByExpression
Arguments: [product#826152, plant#826147], 25
(5) LogicalRelation
Arguments: parquet, [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194], false
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#826157 <=> internalUUID#826172)
(9) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 25 more fields]
(10) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 1 more fields]
(11) LogicalRelation
Arguments: parquet, [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#826201.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#826152 <=> product#826202.internalRefUUID) AND (plant#826147 <=> plant#826201.internalRefUUID))
(16) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(17) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(18) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 12 more fields]
(19) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 4 more fields]
(20) LogicalRelation
Arguments: parquet, [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227], false
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#826152 = internalUUID#826217)
(24) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 17 more fields]
(25) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 5 more fields]
(26) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 6 more fields]
(27) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 7 more fields]
(28) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(29) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(30) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 9 more fields]
(31) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826259) AND (plant#826147 <=> plant#826260.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826286, plant#826287, logisticalRoundingRule#826288]
(37) Filter
Arguments: isnull(plant#826287.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826286)
(40) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 17 more fields]
(41) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#826277, unitOfMeasure#826278]
(43) Aggregate
Arguments: [logisticalRoundingRule#826277], [logisticalRoundingRule#826277, collect_list(unitOfMeasure#826278.internalRefUUID, 0, 0) AS preferredUOMs#826279]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#826290.logisticalRoundingRule = logisticalRoundingRule#826277)
(45) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(46) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(47) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(49) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#826152 <=> product#826303) AND (plant#826147 <=> plant#826304)) AND (orderDateTime#826153 <=> orderDateTime#826305))
(53) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#826307, descriptions#826308, minServiceLevel#826309, minServiceLevelMinStock#826310, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313, profileType#826314, eventtype#826315], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#826306 <=> constraintProfile#826307)
(57) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 20 more fields]
(58) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(59) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(60) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 15 more fields]
(61) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 15 more fields]
(62) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#826344, orderProposalItemId#826345, constraintOverwrites#826346]
(64) Project
Arguments: [orderProposalId#826344, orderProposalItemId#826345, filter(constraintOverwrites#826346, lambdafunction(((isnotnull(lambda x_2152#826348.label) AND isnotnull(lambda x_2152#826348.isActive)) AND (((lambda x_2152#826348.isActive = false) OR isnotnull(lambda x_2152#826348.value)) OR (lambda x_2152#826348.label <=> minOrderQuantity))), lambda x_2152#826348, false)) AS constraintOverwrites#826347]
(65) Project
Arguments: [orderProposalId#826344, orderProposalItemId#826345, transform(constraintOverwrites#826347, lambdafunction(struct(label, lambda x_2153#826353.label, value, CASE WHEN ((lambda x_2153#826353.label = minOrderQuantity) OR (lambda x_2153#826353.label = lockedOrderQuantity)) THEN round(lambda x_2153#826353.value, 0) ELSE lambda x_2153#826353.value END, isActive, lambda x_2153#826353.isActive), lambda x_2153#826353, false)) AS constraintOverwrites#826352]
(66) Join
Arguments: LeftOuter, ((orderProposalId#826161L = cast(orderProposalId#826344 as bigint)) AND (orderProposalItemId#826169 = orderProposalItemId#826345))
(67) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(68) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(69) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 14 more fields]
(72) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 16 more fields]
(74) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 17 more fields]
(75) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 18 more fields]
(76) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 19 more fields]
(77) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#826405, internalUUID#826406, code#826407, name#826408, commercialCode#826409, isoCode#826410], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) Join
Arguments: LeftOuter, (filter(filter(productInformation#826228.unitOfMeasures, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID <=> internalUUID#826406)
(82) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(83) LogicalRelation
Arguments: parquet, [systemId#826441, internalUUID#826442, code#826443, name#826444, commercialCode#826445, isoCode#826446], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) Join
Arguments: LeftOuter, (filter(filter(productInformation#826228.unitOfMeasures, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID <=> internalUUID#826442)
(87) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(88) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(89) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479], false
(91) Repartition
Arguments: 25, true
(92) Project
Arguments: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479, cast(null as string) AS supplyingPlant#826481]
(93) Project
Arguments: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479, supplyingPlant#826481, cast(null as string) AS productGroup#826482]
(94) Join
Arguments: LeftOuter, (((((((supplierGroup#826145 <=> supplierGroup#826477) AND (supplier#826146 <=> supplier#826472)) AND (subrange#826149 <=> subrange#826473)) AND (plant#826147 <=> plant#826474)) AND (deliveryDateTime#826148 <=> deliveryDateTime#826475)) AND (supplyingPlant#826150 <=> supplyingPlant#826481)) AND (productGroup#826151 <=> productGroup#826482))
(95) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(96) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(97) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(98) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(99) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]