SP1 - Details for Query 7148

Submitted Time: 2026/10/27 20:38:54
Duration: 1 s
Succeeded Jobs: 10654 10655 10656 10657 10658

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,500"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 5 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 373.5 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 21,127 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 21,127 local bytes read: 356.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 2.3 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 356.2 KiB"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 129 ms"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 392 ms"; 13 [labelType="html" label="Sort sort time: 9 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 14 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 427.2 KiB number of coalesced partitions: 1"]; 15 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 2 ms (stage 21259.0: task 27463)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 21,121 local bytes read: 404.3 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1650.1 KiB (51.8 KiB, 799.1 KiB, 799.1 KiB (stage 21259.0: task 27462)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 404.3 KiB (14.6 KiB, 194.0 KiB, 195.8 KiB (stage 21259.0: task 27462))"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n444 ms (51 ms, 189 ms, 204 ms (stage 21259.0: task 27461))"; 17 [labelType="html" label=" Project "]; } 18 [labelType="html" label="Scan csv number of output rows: 21,121 number of files read: 1 metadata time: 0 ms size of files read: 8.3 MiB"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 3.2 m"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 21 [labelType="html" label=" Project "]; } 22 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 6 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 23 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.8 KiB number of coalesced partitions: 1"]; 24 [labelType="html" label="Exchange shuffle records written: 445 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 445 local bytes read: 17.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 53.8 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 17.9 KiB"]; 25 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 40 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 40 ms"; 27 [labelType="html" label=" Project "]; } 28 [labelType="html" label="Scan csv number of output rows: 1,216 number of files read: 1 metadata time: 0 ms size of files read: 111.6 KiB"]; subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 30 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 31 [labelType="html" label=" Project "]; } 32 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 12 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 33 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 34 [labelType="html" label="Exchange shuffle records written: 464 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 464 local bytes read: 9.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 43.8 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 9.1 KiB"]; 35 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 19 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 19 ms"; 37 [labelType="html" label=" Project "]; } 38 [labelType="html" label="Scan csv number of output rows: 486 number of files read: 1 metadata time: 0 ms size of files read: 50.8 KiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 15->14; 17->15; 18->17; 20->11; 21->20; 22->21; 23->22; 24->23; 25->24; 27->25; 28->27; 30->4; 31->30; 32->31; 33->32; 34->33; 35->34; 37->35; 38->37; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436], FullOuter

WholeStageCodegen (9)

Sort [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039463]

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322], FullOuter

WholeStageCodegen (6)

Sort [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039257]

Project [NO_ADMIN#1731382 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, str_to_dec(MNT_MON#1731522, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, str_to_dec(MNT_DMI#1731523, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, str_remove_space(NO_ADMIN#1731382, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]

WholeStageCodegen (1)

FileScan csv [NO_ADMIN#1731382,MNT_MON#1731522,MNT_DMI#1731523] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<NO_ADMIN:string,MNT_MON:string,MNT_DMI:string>

Sort [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 ASC NULLS FIRST], false, 0

Project [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]

WholeStageCodegen (5)

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481], functions=[sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, 10), ENSURE_REQUIREMENTS, [plan_id=1039270]

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481], functions=[partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1735352, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, str_remove_space(str_extract_middle(_c0#1735352, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, str_to_dec(str_join(array(str_extract_middle(_c0#1735352, 83, 7), str_extract_middle(_c0#1735352, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487]

WholeStageCodegen (2)

FileScan csv [_c0#1735352] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/DMI_M12_2025_237543/DMI-M12-2025 - BIS...., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Sort [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436 ASC NULLS FIRST], false, 0

Project [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]

WholeStageCodegen (8)

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660], functions=[sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, 10), ENSURE_REQUIREMENTS, [plan_id=1039298]

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660], functions=[partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1734375, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, str_remove_space(str_extract_middle(_c0#1734375, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, str_to_dec(str_join(array(str_extract_middle(_c0#1734375, 65, 7), str_extract_middle(_c0#1734375, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666]

WholeStageCodegen (3)

FileScan csv [_c0#1734375] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/MOLECULES_ONERE_237545/MO-M12-2025.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (56)
+- == Final Plan ==
   CollectLimit (33)
   +- * Project (32)
      +- * SortMergeJoin FullOuter (31)
         :- * Sort (21)
         :  +- AQEShuffleRead (20)
         :     +- ShuffleQueryStage (19), Statistics(sizeInBytes=2.3 MiB, rowCount=2.11E+4)
         :        +- Exchange (18)
         :           +- * Project (17)
         :              +- * SortMergeJoin FullOuter (16)
         :                 :- * Sort (6)
         :                 :  +- AQEShuffleRead (5)
         :                 :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=1650.1 KiB, rowCount=2.11E+4)
         :                 :        +- Exchange (3)
         :                 :           +- * Project (2)
         :                 :              +- Scan csv  (1)
         :                 +- * Sort (15)
         :                    +- * Project (14)
         :                       +- ObjectHashAggregate (13)
         :                          +- AQEShuffleRead (12)
         :                             +- ShuffleQueryStage (11), Statistics(sizeInBytes=53.8 KiB, rowCount=445)
         :                                +- Exchange (10)
         :                                   +- ObjectHashAggregate (9)
         :                                      +- * Project (8)
         :                                         +- Scan csv  (7)
         +- * Sort (30)
            +- * Project (29)
               +- ObjectHashAggregate (28)
                  +- AQEShuffleRead (27)
                     +- ShuffleQueryStage (26), Statistics(sizeInBytes=43.8 KiB, rowCount=464)
                        +- Exchange (25)
                           +- ObjectHashAggregate (24)
                              +- * Project (23)
                                 +- Scan csv  (22)
+- == Initial Plan ==
   CollectLimit (55)
   +- Project (54)
      +- SortMergeJoin FullOuter (53)
         :- Sort (46)
         :  +- Exchange (45)
         :     +- Project (44)
         :        +- SortMergeJoin FullOuter (43)
         :           :- Sort (36)
         :           :  +- Exchange (35)
         :           :     +- Project (34)
         :           :        +- Scan csv  (1)
         :           +- Sort (42)
         :              +- Project (41)
         :                 +- ObjectHashAggregate (40)
         :                    +- Exchange (39)
         :                       +- ObjectHashAggregate (38)
         :                          +- Project (37)
         :                             +- Scan csv  (7)
         +- Sort (52)
            +- Project (51)
               +- ObjectHashAggregate (50)
                  +- Exchange (49)
                     +- ObjectHashAggregate (48)
                        +- Project (47)
                           +- Scan csv  (22)


(1) Scan csv 
Output [3]: [NO_ADMIN#1731382, MNT_MON#1731522, MNT_DMI#1731523]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<NO_ADMIN:string,MNT_MON:string,MNT_DMI:string>

(2) Project [codegen id : 1]
Output [4]: [NO_ADMIN#1731382 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, str_to_dec(MNT_MON#1731522, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, str_to_dec(MNT_DMI#1731523, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, str_remove_space(NO_ADMIN#1731382, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Input [3]: [NO_ADMIN#1731382, MNT_MON#1731522, MNT_DMI#1731523]

(3) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039257]

(4) ShuffleQueryStage
Output [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: 0

(5) AQEShuffleRead
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: coalesced

(6) Sort [codegen id : 4]
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [1]: [_c0#1735352]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/DMI_M12_2025_237543/DMI-M12-2025 - BIS.txt]
ReadSchema: struct<_c0:string>

(8) Project [codegen id : 2]
Output [3]: [str_remove_space(str_extract_middle(_c0#1735352, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, str_remove_space(str_extract_middle(_c0#1735352, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, str_to_dec(str_join(array(str_extract_middle(_c0#1735352, 83, 7), str_extract_middle(_c0#1735352, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487]
Input [1]: [_c0#1735352]

(9) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)]
Aggregate Attributes [2]: [sum#1737376, buf#1737377]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]

(10) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, 10), ENSURE_REQUIREMENTS, [plan_id=1039270]

(11) ShuffleQueryStage
Output [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487)#1735509, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)#1735511]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487)#1735509 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)#1735511 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529]

(14) Project [codegen id : 5]
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529]

(15) Sort [codegen id : 5]
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322]
Join type: FullOuter
Join condition: None

(17) Project [codegen id : 6]
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]

(18) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039463]

(19) ShuffleQueryStage
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: 3

(20) AQEShuffleRead
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: coalesced

(21) Sort [codegen id : 7]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

(22) Scan csv 
Output [1]: [_c0#1734375]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/MOLECULES_ONERE_237545/MO-M12-2025.txt]
ReadSchema: struct<_c0:string>

(23) Project [codegen id : 3]
Output [3]: [str_remove_space(str_extract_middle(_c0#1734375, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, str_remove_space(str_extract_middle(_c0#1734375, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, str_to_dec(str_join(array(str_extract_middle(_c0#1734375, 65, 7), str_extract_middle(_c0#1734375, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666]
Input [1]: [_c0#1734375]

(24) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)]
Aggregate Attributes [2]: [sum#1737501, buf#1737502]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]

(25) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, 10), ENSURE_REQUIREMENTS, [plan_id=1039298]

(26) ShuffleQueryStage
Output [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Arguments: 2

(27) AQEShuffleRead
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Arguments: coalesced

(28) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666)#1734709, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)#1734711]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666)#1734709 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)#1734711 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729]

(29) Project [codegen id : 8]
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729]

(30) Sort [codegen id : 8]
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436 ASC NULLS FIRST], false, 0

(31) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436]
Join type: FullOuter
Join condition: None

(32) Project [codegen id : 9]
Output [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]

(33) CollectLimit
Input [12]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]
Arguments: 1500

(34) Project
Output [4]: [NO_ADMIN#1731382 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, str_to_dec(MNT_MON#1731522, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, str_to_dec(MNT_DMI#1731523, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, str_remove_space(NO_ADMIN#1731382, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Input [3]: [NO_ADMIN#1731382, MNT_MON#1731522, MNT_DMI#1731523]

(35) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039212]

(36) Sort
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

(37) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1735352, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, str_remove_space(str_extract_middle(_c0#1735352, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, str_to_dec(str_join(array(str_extract_middle(_c0#1735352, 83, 7), str_extract_middle(_c0#1735352, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487]
Input [1]: [_c0#1735352]

(38) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)]
Aggregate Attributes [2]: [sum#1737376, buf#1737377]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]

(39) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, 10), ENSURE_REQUIREMENTS, [plan_id=1039207]

(40) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481, sum#1737378, buf#1737379]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487)#1735509, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)#1735511]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1735481 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1735487)#1735509 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1735483, 0, 0)#1735511 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529]

(41) Project
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1735527, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1735528, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1735529]

(42) Sort
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 ASC NULLS FIRST], false, 0

(43) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322]
Join type: FullOuter
Join condition: None

(44) Project
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1737322, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1737323, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1737324, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1737325]

(45) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, 10), ENSURE_REQUIREMENTS, [plan_id=1039222]

(46) Sort
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307 ASC NULLS FIRST], false, 0

(47) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1734375, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, str_remove_space(str_extract_middle(_c0#1734375, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, str_to_dec(str_join(array(str_extract_middle(_c0#1734375, 65, 7), str_extract_middle(_c0#1734375, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666]
Input [1]: [_c0#1734375]

(48) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)]
Aggregate Attributes [2]: [sum#1737501, buf#1737502]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]

(49) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, 10), ENSURE_REQUIREMENTS, [plan_id=1039217]

(50) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660, sum#1737503, buf#1737504]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666)#1734709, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)#1734711]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1734660 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1734666)#1734709 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1734662, 0, 0)#1734711 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729]

(51) Project
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1734727, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1734728, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1734729]

(52) Sort
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436 ASC NULLS FIRST], false, 0

(53) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436]
Join type: FullOuter
Join condition: None

(54) Project
Output [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1736598, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1737304, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1737305, COL_7948E047_29EE_472A_BFFC_723098878DAD#1737307, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1737415, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1737416, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1737417, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1737418, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1737436, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1737437, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1737438, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1737439]

(55) CollectLimit
Input [12]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]
Arguments: 1500

(56) AdaptiveSparkPlan
Output [12]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1738347, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1738348, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1738349, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1738350, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1738351, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1738352, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1738353, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1738354, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1738355, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1738356, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1738357, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1738358]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet