SP1 - Details for Query 7738

Submitted Time: 2026/10/27 21:28:03
Duration: 0.9 s
Succeeded Jobs: 11249 11250 11251 11252 11253 11254 11255 11256 11257 11258 11259

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 (17)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,500 spill size: 0.0 B"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 15.8 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 1,500 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: 1,500 local bytes read: 15.0 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: 203.4 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: 15.0 KiB"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 7 ms"; 10 [labelType="html" label=" LocalLimit "]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="SortMergeJoin number of output rows: 1,500 spill size: 0.0 B"]; } subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 26 ms"; 14 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 15 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 23.7 KiB number of coalesced partitions: 1"]; 16 [labelType="html" label="Exchange shuffle records written: 1,500 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: 1,500 local bytes read: 22.6 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: 214.5 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: 22.6 KiB"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 88 ms"; 18 [labelType="html" label=" LocalLimit "]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 122 ms"; 23 [labelType="html" label="Sort sort time: 4 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 24 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 373.5 KiB number of coalesced partitions: 1"]; 25 [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 cluster26 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 69 ms"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 218 ms"; 30 [labelType="html" label="Sort sort time: 12 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 31 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 427.2 KiB number of coalesced partitions: 1"]; 32 [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 22690.0: task 28279)) 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 22690.0: task 28280)) 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 22690.0: task 28280))"]; subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n265 ms (24 ms, 118 ms, 123 ms (stage 22690.0: task 28279))"; 34 [labelType="html" label=" Project "]; } 35 [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 cluster36 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 1.8 m"; 37 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 38 [labelType="html" label=" Project "]; } 39 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 13 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 40 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.8 KiB number of coalesced partitions: 1"]; 41 [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"]; 42 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 25 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 25 ms"; 44 [labelType="html" label=" Project "]; } 45 [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 cluster46 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 222 ms"; 47 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 48 [labelType="html" label=" Project "]; } 49 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 9 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 50 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 51 [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"]; 52 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 15 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster53 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 15 ms"; 54 [labelType="html" label=" Project "]; } 55 [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"]; subgraph cluster56 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 0 ms"; 57 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 58 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 5.9 KiB number of coalesced partitions: 1"]; 59 [labelType="html" label="Exchange shuffle records written: 268 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: 268 local bytes read: 5.6 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: 21.2 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: 5.6 KiB"]; 60 [labelType="html" label="ObjectHashAggregate number of output rows: 268 time in aggregation build: 24 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 61 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 6.4 KiB number of coalesced partitions: 1"]; 62 [labelType="html" label="Exchange shuffle records written: 268 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: 268 local bytes read: 6.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: 25.4 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: 6.1 KiB"]; 63 [labelType="html" label="ObjectHashAggregate number of output rows: 268 time in aggregation build: 29 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster64 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 29 ms"; 65 [labelType="html" label=" Project "]; 66 [labelType="html" label="Filter number of output rows: 283"]; 67 [labelType="html" label="ColumnarToRow number of output rows: 295 number of input batches: 1"]; } 68 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 16.7 KiB number of output rows: 295"]; subgraph cluster69 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 0 ms"; 70 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 71 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 15.7 KiB number of coalesced partitions: 1"]; 72 [labelType="html" label="Exchange shuffle records written: 440 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: 440 local bytes read: 15.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: 46.1 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: 15.1 KiB"]; 73 [labelType="html" label="ObjectHashAggregate number of output rows: 440 time in aggregation build: 28 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 74 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 28.5 KiB number of coalesced partitions: 1"]; 75 [labelType="html" label="Exchange shuffle records written: 447 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 15 ms (2 ms, 2 ms, 2 ms (stage 22694.0: task 28287)) 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: 447 local bytes read: 27.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 57.0 KiB (8.4 KiB, 9.7 KiB, 9.8 KiB (stage 22694.0: task 28286)) 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)) 27.2 KiB (4.2 KiB, 4.6 KiB, 4.8 KiB (stage 22694.0: task 28286))"]; 76 [labelType="html" label="ObjectHashAggregate number of output rows: 447 time in aggregation build total (min, med, max (stageId: taskId)) 148 ms (20 ms, 24 ms, 31 ms (stage 22694.0: task 28285)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 22694.0: task 28286)) number of sort fallback tasks: 0"]; subgraph cluster77 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n148 ms (20 ms, 24 ms, 31 ms (stage 22694.0: task 28285))"; 78 [labelType="html" label=" Project "]; 79 [labelType="html" label="Filter number of output rows: 1,189"]; 80 [labelType="html" label="ColumnarToRow number of output rows: 1,201 number of input batches: 12"]; } 81 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 36 ms (2 ms, 7 ms, 9 ms (stage 22694.0: task 28285)) metadata time: 0 ms size of files read: 175.2 KiB number of output rows: 1,201"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 16->15; 18->16; 19->18; 20->19; 21->20; 23->21; 24->23; 25->24; 27->25; 28->27; 30->28; 31->30; 32->31; 34->32; 35->34; 37->28; 38->37; 39->38; 40->39; 41->40; 42->41; 44->42; 45->44; 47->21; 48->47; 49->48; 50->49; 51->50; 52->51; 54->52; 55->54; 57->12; 58->57; 59->58; 60->59; 61->60; 62->61; 63->62; 65->63; 66->65; 67->66; 68->67; 70->4; 71->70; 72->71; 73->72; 74->73; 75->74; 76->75; 78->76; 79->78; 80->79; 81->80; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353 AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351) AS COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353)) AS COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]

SortMergeJoin [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956], [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352], LeftOuter

WholeStageCodegen (17)

Sort [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, 10), ENSURE_REQUIREMENTS, [plan_id=1093366]

LocalLimit 1500

Project [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183 AS COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]

SortMergeJoin [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128], [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181], LeftOuter

WholeStageCodegen (14)

Sort [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128 ASC NULLS FIRST], false, 0

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, 10), ENSURE_REQUIREMENTS, [plan_id=1093264]

LocalLimit 1500

Project [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]

Project [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136], FullOuter

WholeStageCodegen (11)

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

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092888]

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025], FullOuter

WholeStageCodegen (8)

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092517]

Project [NO_ADMIN#1972648 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, str_to_dec(MNT_MON#1972788, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, str_to_dec(MNT_DMI#1972789, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, str_remove_space(NO_ADMIN#1972648, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]

WholeStageCodegen (1)

FileScan csv [NO_ADMIN#1972648,MNT_MON#1972788,MNT_DMI#1972789] 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#1979025 ASC NULLS FIRST], false, 0

Project [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]

WholeStageCodegen (7)

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073], functions=[sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, 10), ENSURE_REQUIREMENTS, [plan_id=1092530]

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073], functions=[partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1976732, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, str_remove_space(str_extract_middle(_c0#1976732, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, str_to_dec(str_join(array(str_extract_middle(_c0#1976732, 83, 7), str_extract_middle(_c0#1976732, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079]

WholeStageCodegen (2)

FileScan csv [_c0#1976732] 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#1979136 ASC NULLS FIRST], false, 0

Project [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]

WholeStageCodegen (10)

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613], functions=[sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, 10), ENSURE_REQUIREMENTS, [plan_id=1092551]

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613], functions=[partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1976494, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, str_remove_space(str_extract_middle(_c0#1976494, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, str_to_dec(str_join(array(str_extract_middle(_c0#1976494, 65, 7), str_extract_middle(_c0#1976494, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619]

WholeStageCodegen (3)

FileScan csv [_c0#1976494] 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>

Sort [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181 ASC NULLS FIRST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, 10), ENSURE_REQUIREMENTS, [plan_id=1093018]

ObjectHashAggregate(keys=[COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635], functions=[collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, 10), ENSURE_REQUIREMENTS, [plan_id=1092581]

ObjectHashAggregate(keys=[COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635], functions=[partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)])

Project [N%C2%B0+SEJOUR#1981030 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, UCD#1981032 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, round(str_to_dec(quantit%C3%A9s#1981034, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639]

Filter (isnotnull(N%C2%B0+SEJOUR#1981030) AND isnotnull(str_remove_space(N%C2%B0+SEJOUR#1981030, ALL)))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [N%C2%B0+SEJOUR#1981030,UCD#1981032,quantit%C3%A9s#1981034] Batched: true, DataFilters: [isnotnull(N%C2%B0+SEJOUR#1981030), isnotnull(str_remove_space(N%C2%B0+SEJOUR#1981030, ALL))], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d7746602..., PartitionFilters: [], PushedFilters: [IsNotNull(`N%C2%B0+SEJOUR`)], ReadSchema: struct<N%C2%B0+SEJOUR:string,UCD:string,quantit%C3%A9s:string>

Sort [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352 ASC NULLS FIRST], false, 0

WholeStageCodegen (16)

AQEShuffleRead coalesced

Exchange hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, 10), ENSURE_REQUIREMENTS, [plan_id=1093033]

ObjectHashAggregate(keys=[COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644], functions=[collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, 10), ENSURE_REQUIREMENTS, [plan_id=1092626]

ObjectHashAggregate(keys=[COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644], functions=[partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)])

Project [str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, code+LPP#1981821 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, str_to_dec(quantit%C3%A9#1981823, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649]

Filter (isnotnull(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)) AND isnotnull(bigint_to_str(str_to_bigint(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)))))

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [N%C2%B0+s%C3%A9jour#1981818,code+LPP#1981821,quantit%C3%A9#1981823] Batched: true, DataFilters: [isnotnull(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)), isnotnull(bigint_to_str(str_t..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<N%C2%B0+s%C3%A9jour:string,code+LPP:string,quantit%C3%A9:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (122)
+- == Final Plan ==
   CollectLimit (74)
   +- * Project (73)
      +- * SortMergeJoin LeftOuter (72)
         :- * Sort (58)
         :  +- AQEShuffleRead (57)
         :     +- ShuffleQueryStage (56), Statistics(sizeInBytes=203.4 KiB, rowCount=1.50E+3)
         :        +- Exchange (55)
         :           +- * LocalLimit (54)
         :              +- * Project (53)
         :                 +- * SortMergeJoin LeftOuter (52)
         :                    :- * Sort (38)
         :                    :  +- AQEShuffleRead (37)
         :                    :     +- ShuffleQueryStage (36), Statistics(sizeInBytes=214.5 KiB, rowCount=1.50E+3)
         :                    :        +- Exchange (35)
         :                    :           +- * LocalLimit (34)
         :                    :              +- * Project (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)
         :                    +- * Sort (51)
         :                       +- AQEShuffleRead (50)
         :                          +- ShuffleQueryStage (49), Statistics(sizeInBytes=21.2 KiB, rowCount=268)
         :                             +- Exchange (48)
         :                                +- ObjectHashAggregate (47)
         :                                   +- AQEShuffleRead (46)
         :                                      +- ShuffleQueryStage (45), Statistics(sizeInBytes=25.4 KiB, rowCount=268)
         :                                         +- Exchange (44)
         :                                            +- ObjectHashAggregate (43)
         :                                               +- * Project (42)
         :                                                  +- * Filter (41)
         :                                                     +- * ColumnarToRow (40)
         :                                                        +- Scan parquet  (39)
         +- * Sort (71)
            +- AQEShuffleRead (70)
               +- ShuffleQueryStage (69), Statistics(sizeInBytes=46.1 KiB, rowCount=440)
                  +- Exchange (68)
                     +- ObjectHashAggregate (67)
                        +- AQEShuffleRead (66)
                           +- ShuffleQueryStage (65), Statistics(sizeInBytes=57.0 KiB, rowCount=447)
                              +- Exchange (64)
                                 +- ObjectHashAggregate (63)
                                    +- * Project (62)
                                       +- * Filter (61)
                                          +- * ColumnarToRow (60)
                                             +- Scan parquet  (59)
+- == Initial Plan ==
   CollectLimit (121)
   +- Project (120)
      +- SortMergeJoin LeftOuter (119)
         :- Sort (111)
         :  +- Exchange (110)
         :     +- LocalLimit (109)
         :        +- Project (108)
         :           +- SortMergeJoin LeftOuter (107)
         :              :- Sort (99)
         :              :  +- Exchange (98)
         :              :     +- LocalLimit (97)
         :              :        +- Project (96)
         :              :           +- Project (95)
         :              :              +- SortMergeJoin FullOuter (94)
         :              :                 :- Sort (87)
         :              :                 :  +- Exchange (86)
         :              :                 :     +- Project (85)
         :              :                 :        +- SortMergeJoin FullOuter (84)
         :              :                 :           :- Sort (77)
         :              :                 :           :  +- Exchange (76)
         :              :                 :           :     +- Project (75)
         :              :                 :           :        +- Scan csv  (1)
         :              :                 :           +- Sort (83)
         :              :                 :              +- Project (82)
         :              :                 :                 +- ObjectHashAggregate (81)
         :              :                 :                    +- Exchange (80)
         :              :                 :                       +- ObjectHashAggregate (79)
         :              :                 :                          +- Project (78)
         :              :                 :                             +- Scan csv  (7)
         :              :                 +- Sort (93)
         :              :                    +- Project (92)
         :              :                       +- ObjectHashAggregate (91)
         :              :                          +- Exchange (90)
         :              :                             +- ObjectHashAggregate (89)
         :              :                                +- Project (88)
         :              :                                   +- Scan csv  (22)
         :              +- Sort (106)
         :                 +- Exchange (105)
         :                    +- ObjectHashAggregate (104)
         :                       +- Exchange (103)
         :                          +- ObjectHashAggregate (102)
         :                             +- Project (101)
         :                                +- Filter (100)
         :                                   +- Scan parquet  (39)
         +- Sort (118)
            +- Exchange (117)
               +- ObjectHashAggregate (116)
                  +- Exchange (115)
                     +- ObjectHashAggregate (114)
                        +- Project (113)
                           +- Filter (112)
                              +- Scan parquet  (59)


(1) Scan csv 
Output [3]: [NO_ADMIN#1972648, MNT_MON#1972788, MNT_DMI#1972789]
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#1972648 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, str_to_dec(MNT_MON#1972788, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, str_to_dec(MNT_DMI#1972789, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, str_remove_space(NO_ADMIN#1972648, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Input [3]: [NO_ADMIN#1972648, MNT_MON#1972788, MNT_DMI#1972789]

(3) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092517]

(4) ShuffleQueryStage
Output [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: 0

(5) AQEShuffleRead
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: coalesced

(6) Sort [codegen id : 6]
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [1]: [_c0#1976732]
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#1976732, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, str_remove_space(str_extract_middle(_c0#1976732, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, str_to_dec(str_join(array(str_extract_middle(_c0#1976732, 83, 7), str_extract_middle(_c0#1976732, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079]
Input [1]: [_c0#1976732]

(9) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)]
Aggregate Attributes [2]: [sum#1979076, buf#1979077]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]

(10) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, 10), ENSURE_REQUIREMENTS, [plan_id=1092530]

(11) ShuffleQueryStage
Output [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079)#1977119, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)#1977121]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079)#1977119 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)#1977121 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175]

(14) Project [codegen id : 7]
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175]

(15) Sort [codegen id : 7]
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 8]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025]
Join type: FullOuter
Join condition: None

(17) Project [codegen id : 8]
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]

(18) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092888]

(19) ShuffleQueryStage
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: 5

(20) AQEShuffleRead
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: coalesced

(21) Sort [codegen id : 9]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011 ASC NULLS FIRST], false, 0

(22) Scan csv 
Output [1]: [_c0#1976494]
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#1976494, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, str_remove_space(str_extract_middle(_c0#1976494, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, str_to_dec(str_join(array(str_extract_middle(_c0#1976494, 65, 7), str_extract_middle(_c0#1976494, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619]
Input [1]: [_c0#1976494]

(24) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)]
Aggregate Attributes [2]: [sum#1979199, buf#1979200]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]

(25) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, 10), ENSURE_REQUIREMENTS, [plan_id=1092551]

(26) ShuffleQueryStage
Output [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Arguments: 2

(27) AQEShuffleRead
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Arguments: coalesced

(28) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619)#1976644, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)#1976646]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619)#1976644 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)#1976646 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664]

(29) Project [codegen id : 10]
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664]

(30) Sort [codegen id : 10]
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136 ASC NULLS FIRST], false, 0

(31) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136]
Join type: FullOuter
Join condition: None

(32) Project [codegen id : 11]
Output [12]: [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]

(33) Project [codegen id : 11]
Output [13]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [12]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]

(34) LocalLimit [codegen id : 11]
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 1500

(35) Exchange
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, 10), ENSURE_REQUIREMENTS, [plan_id=1093264]

(36) ShuffleQueryStage
Output [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 8

(37) AQEShuffleRead
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: coalesced

(38) Sort [codegen id : 12]
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128 ASC NULLS FIRST], false, 0

(39) Scan parquet 
Output [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d77466024fccdf18ace5a6e64d03/synthèse-MO-2025.xlsx_6fa2b969a426becf7b2379293a107a75]
PushedFilters: [IsNotNull(`N%C2%B0+SEJOUR`)]
ReadSchema: struct<N%C2%B0+SEJOUR:string,UCD:string,quantit%C3%A9s:string>

(40) ColumnarToRow [codegen id : 4]
Input [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]

(41) Filter [codegen id : 4]
Input [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]
Condition : (isnotnull(N%C2%B0+SEJOUR#1981030) AND isnotnull(str_remove_space(N%C2%B0+SEJOUR#1981030, ALL)))

(42) Project [codegen id : 4]
Output [3]: [N%C2%B0+SEJOUR#1981030 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, UCD#1981032 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, round(str_to_dec(quantit%C3%A9s#1981034, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639]
Input [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]

(43) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635]
Functions [2]: [partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)]
Aggregate Attributes [2]: [buf#1983284, sum#1983285]
Results [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]

(44) Exchange
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Arguments: hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, 10), ENSURE_REQUIREMENTS, [plan_id=1092581]

(45) ShuffleQueryStage
Output [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Arguments: 3

(46) AQEShuffleRead
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Arguments: coalesced

(47) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635]
Functions [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)]
Aggregate Attributes [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0)#1981681, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)#1981683]
Results [3]: [str_remove_space(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, ALL) AS SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0)#1981681 AS SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)#1981683 AS SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]

(48) Exchange
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, 10), ENSURE_REQUIREMENTS, [plan_id=1093018]

(49) ShuffleQueryStage
Output [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: 6

(50) AQEShuffleRead
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: coalesced

(51) Sort [codegen id : 13]
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181 ASC NULLS FIRST], false, 0

(52) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128]
Right keys [1]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181]
Join type: LeftOuter
Join condition: None

(53) Project [codegen id : 14]
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183 AS COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [16]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]

(54) LocalLimit [codegen id : 14]
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 1500

(55) Exchange
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, 10), ENSURE_REQUIREMENTS, [plan_id=1093366]

(56) ShuffleQueryStage
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 9

(57) AQEShuffleRead
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: coalesced

(58) Sort [codegen id : 15]
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 ASC NULLS FIRST], false, 0

(59) Scan parquet 
Output [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987f45e4002171a5d87dfdd/synthèse-DMI-2025.xls_41d136f5d26b76a99c371a1af7fc9e64]
ReadSchema: struct<N%C2%B0+s%C3%A9jour:string,code+LPP:string,quantit%C3%A9:string>

(60) ColumnarToRow [codegen id : 5]
Input [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]

(61) Filter [codegen id : 5]
Input [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]
Condition : (isnotnull(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)) AND isnotnull(bigint_to_str(str_to_bigint(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)))))

(62) Project [codegen id : 5]
Output [3]: [str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, code+LPP#1981821 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, str_to_dec(quantit%C3%A9#1981823, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649]
Input [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]

(63) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644]
Functions [2]: [partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)]
Aggregate Attributes [2]: [buf#1983412, sum#1983413]
Results [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]

(64) Exchange
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Arguments: hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, 10), ENSURE_REQUIREMENTS, [plan_id=1092626]

(65) ShuffleQueryStage
Output [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Arguments: 4

(66) AQEShuffleRead
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Arguments: coalesced

(67) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644]
Functions [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)]
Aggregate Attributes [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0)#1982691, sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)#1982693]
Results [3]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0)#1982691 AS SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, bigint_to_str(str_to_bigint(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644)) AS SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, coalesce(dec_to_int(sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)#1982693), 0) AS SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]

(68) Exchange
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, 10), ENSURE_REQUIREMENTS, [plan_id=1093033]

(69) ShuffleQueryStage
Output [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: 7

(70) AQEShuffleRead
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: coalesced

(71) Sort [codegen id : 16]
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352 ASC NULLS FIRST], false, 0

(72) SortMergeJoin [codegen id : 17]
Left keys [1]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Right keys [1]: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352]
Join type: LeftOuter
Join condition: None

(73) Project [codegen id : 17]
Output [18]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353 AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351) AS COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353)) AS COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]

(74) CollectLimit
Input [18]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]
Arguments: 1500

(75) Project
Output [4]: [NO_ADMIN#1972648 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, str_to_dec(MNT_MON#1972788, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, str_to_dec(MNT_DMI#1972789, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, str_remove_space(NO_ADMIN#1972648, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Input [3]: [NO_ADMIN#1972648, MNT_MON#1972788, MNT_DMI#1972789]

(76) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092397]

(77) Sort
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011 ASC NULLS FIRST], false, 0

(78) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1976732, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, str_remove_space(str_extract_middle(_c0#1976732, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, str_to_dec(str_join(array(str_extract_middle(_c0#1976732, 83, 7), str_extract_middle(_c0#1976732, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079]
Input [1]: [_c0#1976732]

(79) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)]
Aggregate Attributes [2]: [sum#1979076, buf#1979077]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]

(80) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, 10), ENSURE_REQUIREMENTS, [plan_id=1092392]

(81) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073, sum#1979078, buf#1979079]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079)#1977119, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)#1977121]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1977073 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1977079)#1977119 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1977075, 0, 0)#1977121 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175]

(82) Project
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1977173, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1977174, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1977175]

(83) Sort
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025 ASC NULLS FIRST], false, 0

(84) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025]
Join type: FullOuter
Join condition: None

(85) Project
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1979025, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1979026, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1979027, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1979028]

(86) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, 10), ENSURE_REQUIREMENTS, [plan_id=1092407]

(87) Sort
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011 ASC NULLS FIRST], false, 0

(88) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1976494, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, str_remove_space(str_extract_middle(_c0#1976494, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, str_to_dec(str_join(array(str_extract_middle(_c0#1976494, 65, 7), str_extract_middle(_c0#1976494, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619]
Input [1]: [_c0#1976494]

(89) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)]
Aggregate Attributes [2]: [sum#1979199, buf#1979200]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]

(90) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, 10), ENSURE_REQUIREMENTS, [plan_id=1092402]

(91) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613, sum#1979201, buf#1979202]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619)#1976644, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)#1976646]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1976613 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1976619)#1976644 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1976615, 0, 0)#1976646 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664]

(92) Project
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1976662, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1976663, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1976664]

(93) Sort
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136 ASC NULLS FIRST], false, 0

(94) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136]
Join type: FullOuter
Join condition: None

(95) Project
Output [12]: [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1978484, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1979008, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1979009, COL_7948E047_29EE_472A_BFFC_723098878DAD#1979011, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1979115, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1979116, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1979117, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1979118, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1979136, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1979137, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1979138, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1979139]

(96) Project
Output [13]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [12]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]

(97) LocalLimit
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 1500

(98) Exchange
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, 10), ENSURE_REQUIREMENTS, [plan_id=1092420]

(99) Sort
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128 ASC NULLS FIRST], false, 0

(100) Filter
Input [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]
Condition : (isnotnull(N%C2%B0+SEJOUR#1981030) AND isnotnull(str_remove_space(N%C2%B0+SEJOUR#1981030, ALL)))

(101) Project
Output [3]: [N%C2%B0+SEJOUR#1981030 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, UCD#1981032 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, round(str_to_dec(quantit%C3%A9s#1981034, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639]
Input [3]: [N%C2%B0+SEJOUR#1981030, UCD#1981032, quantit%C3%A9s#1981034]

(102) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635]
Functions [2]: [partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)]
Aggregate Attributes [2]: [buf#1983284, sum#1983285]
Results [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]

(103) Exchange
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Arguments: hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, 10), ENSURE_REQUIREMENTS, [plan_id=1092414]

(104) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, buf#1983286, sum#1983287]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635]
Functions [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)]
Aggregate Attributes [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0)#1981681, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)#1981683]
Results [3]: [str_remove_space(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#1981635, ALL) AS SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#1981637, 0, 0)#1981681 AS SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#1981639)#1981683 AS SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]

(105) Exchange
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, 10), ENSURE_REQUIREMENTS, [plan_id=1092421]

(106) Sort
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]
Arguments: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181 ASC NULLS FIRST], false, 0

(107) SortMergeJoin
Left keys [1]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128]
Right keys [1]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181]
Join type: LeftOuter
Join condition: None

(108) Project
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183 AS COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Input [16]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#1983128, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#1983181, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#1983182, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#1983183]

(109) LocalLimit
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: 1500

(110) Exchange
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, 10), ENSURE_REQUIREMENTS, [plan_id=1092433]

(111) Sort
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Arguments: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956 ASC NULLS FIRST], false, 0

(112) Filter
Input [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]
Condition : (isnotnull(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)) AND isnotnull(bigint_to_str(str_to_bigint(str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT)))))

(113) Project
Output [3]: [str_complete(N%C2%B0+s%C3%A9jour#1981818, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, code+LPP#1981821 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, str_to_dec(quantit%C3%A9#1981823, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649]
Input [3]: [N%C2%B0+s%C3%A9jour#1981818, code+LPP#1981821, quantit%C3%A9#1981823]

(114) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644]
Functions [2]: [partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)]
Aggregate Attributes [2]: [buf#1983412, sum#1983413]
Results [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]

(115) Exchange
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Arguments: hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, 10), ENSURE_REQUIREMENTS, [plan_id=1092427]

(116) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644, buf#1983414, sum#1983415]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644]
Functions [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)]
Aggregate Attributes [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0)#1982691, sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)#1982693]
Results [3]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#1982647, 0, 0)#1982691 AS SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, bigint_to_str(str_to_bigint(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#1982644)) AS SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, coalesce(dec_to_int(sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#1982649)#1982693), 0) AS SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]

(117) Exchange
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, 10), ENSURE_REQUIREMENTS, [plan_id=1092434]

(118) Sort
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]
Arguments: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352 ASC NULLS FIRST], false, 0

(119) SortMergeJoin
Left keys [1]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956]
Right keys [1]: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352]
Join type: LeftOuter
Join condition: None

(120) Project
Output [18]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353 AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351) AS COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353)) AS COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#1983351, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#1983352, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#1983353]

(121) CollectLimit
Input [18]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]
Arguments: 1500

(122) AdaptiveSparkPlan
Output [18]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#1982945, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#1982946, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#1982947, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#1982950, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#1982953, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#1982954, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#1982955, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#1982956, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#1982951, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#1982952, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#1983330, COL_27704BB2_8F01_422B_9619_26C780317E4A#1983331, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#1982948, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#1982949, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#1983469, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#1983470, COL_B8DA55A1_ACFF_4848_A16C_4BFCE7EA70BD#1983471, COL_73060424_42AB_428D_889D_59975F1FDE9C#1983472]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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