SP1 - Details for Query 7814

Submitted Time: 2026/10/27 21:46:43
Duration: 2 s
Succeeded Jobs: 11332 11334 11335 11336 11337 11338 11339 11340 11341 11342 11343

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=" Project "]; 5 [labelType="html" label="SortMergeJoin number of output rows: 1,500 spill size: 0.0 B"]; } subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 7 [labelType="html" label="Sort sort time: 5 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 8 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 206.9 KiB number of coalesced partitions: 1"]; 9 [labelType="html" label="Exchange shuffle records written: 21,131 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: 21,131 local bytes read: 197.8 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.8 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: 197.8 KiB"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 80 ms"; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 105 ms"; 14 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 15 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 308.7 KiB number of coalesced partitions: 1"]; 16 [labelType="html" label="Exchange shuffle records written: 21,131 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: 21,131 local bytes read: 297.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: 3.0 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: 297.0 KiB"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 317 ms"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 722 ms"; 22 [labelType="html" label="Sort sort time: 6 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 373.5 KiB number of coalesced partitions: 1"]; 24 [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 cluster25 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 72 ms"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 336 ms"; 29 [labelType="html" label="Sort sort time: 11 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 30 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 427.2 KiB number of coalesced partitions: 1"]; 31 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (2 ms, 2 ms, 3 ms (stage 22892.0: task 28401)) 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 22892.0: task 28401)) 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 22892.0: task 28401))"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n429 ms (71 ms, 169 ms, 189 ms (stage 22892.0: task 28400))"; 33 [labelType="html" label=" Project "]; } 34 [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 cluster35 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 2.2 m"; 36 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 37 [labelType="html" label=" Project "]; } 38 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 34 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 39 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.8 KiB number of coalesced partitions: 1"]; 40 [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"]; 41 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 35 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster42 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 35 ms"; 43 [labelType="html" label=" Project "]; } 44 [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 cluster45 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 704 ms"; 46 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 47 [labelType="html" label=" Project "]; } 48 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 7 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 49 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 50 [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"]; 51 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 17 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster52 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 17 ms"; 53 [labelType="html" label=" Project "]; } 54 [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 cluster55 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 3.0 s"; 56 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 57 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 6.3 KiB number of coalesced partitions: 1"]; 58 [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.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: 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: 6.0 KiB"]; 59 [labelType="html" label="ObjectHashAggregate number of output rows: 268 time in aggregation build: 8 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 60 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 6.4 KiB number of coalesced partitions: 1"]; 61 [labelType="html" label="Exchange shuffle records written: 268 local merged chunks fetched: 0 shuffle write time: 4 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"]; 62 [labelType="html" label="ObjectHashAggregate number of output rows: 268 time in aggregation build: 12 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster63 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 12 ms"; 64 [labelType="html" label=" Project "]; 65 [labelType="html" label="Filter number of output rows: 283"]; 66 [labelType="html" label="ColumnarToRow number of output rows: 295 number of input batches: 1"]; } 67 [labelType="html" label="Scan parquet number of files read: 1 scan time: 3 ms metadata time: 0 ms size of files read: 16.7 KiB number of output rows: 295"]; subgraph cluster68 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 0 ms"; 69 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 70 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 15.7 KiB number of coalesced partitions: 1"]; 71 [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"]; 72 [labelType="html" label="ObjectHashAggregate number of output rows: 440 time in aggregation build: 35 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 73 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 28.5 KiB number of coalesced partitions: 1"]; 74 [labelType="html" label="Exchange shuffle records written: 447 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (1 ms, 1 ms, 1 ms (stage 22908.0: task 28409)) 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 22908.0: task 28411)) 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 22908.0: task 28408))"]; 75 [labelType="html" label="ObjectHashAggregate number of output rows: 447 time in aggregation build total (min, med, max (stageId: taskId)) 113 ms (15 ms, 20 ms, 24 ms (stage 22908.0: task 28408)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 22908.0: task 28409)) number of sort fallback tasks: 0"]; subgraph cluster76 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n113 ms (15 ms, 20 ms, 24 ms (stage 22908.0: task 28408))"; 77 [labelType="html" label=" Project "]; 78 [labelType="html" label="Filter number of output rows: 1,189"]; 79 [labelType="html" label="ColumnarToRow number of output rows: 1,201 number of input batches: 12"]; } 80 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 61 ms (6 ms, 12 ms, 14 ms (stage 22908.0: task 28408)) metadata time: 0 ms size of files read: 175.2 KiB number of output rows: 1,201"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 11->9; 12->11; 14->12; 15->14; 16->15; 18->16; 19->18; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 29->27; 30->29; 31->30; 33->31; 34->33; 36->27; 37->36; 38->37; 39->38; 40->39; 41->40; 43->41; 44->43; 46->20; 47->46; 48->47; 49->48; 50->49; 51->50; 53->51; 54->53; 56->12; 57->56; 58->57; 59->58; 60->59; 61->60; 62->61; 64->62; 65->64; 66->65; 67->66; 69->5; 70->69; 71->70; 72->71; 73->72; 74->73; 75->74; 77->75; 78->77; 79->78; 80->79; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, int_diff(array(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328)) AS COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041) AS COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327)) AS COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]

Project [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, coalesce(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, 0) AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, coalesce(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 0) AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, coalesce(SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218, 0) AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, coalesce(COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197, 0) AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, str_list_diff(COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195) AS COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345]

SortMergeJoin [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049], [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217], LeftOuter

WholeStageCodegen (17)

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

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, 10), ENSURE_REQUIREMENTS, [plan_id=1100539]

Project [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095 AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]

SortMergeJoin [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064], [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093], LeftOuter

WholeStageCodegen (14)

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

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, 10), ENSURE_REQUIREMENTS, [plan_id=1100441]

Project [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]

Project [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438], FullOuter

WholeStageCodegen (11)

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

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1100170]

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327], FullOuter

WholeStageCodegen (8)

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1099701]

Project [NO_ADMIN#2004618 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, str_to_dec(MNT_MON#2004758, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, str_to_dec(MNT_DMI#2004759, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, str_remove_space(NO_ADMIN#2004618, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]

WholeStageCodegen (1)

FileScan csv [NO_ADMIN#2004618,MNT_MON#2004758,MNT_DMI#2004759] 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#2010327 ASC NULLS FIRST], false, 0

Project [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]

WholeStageCodegen (7)

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789], functions=[sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, 10), ENSURE_REQUIREMENTS, [plan_id=1099714]

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789], functions=[partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#2008684, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, str_remove_space(str_extract_middle(_c0#2008684, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, str_to_dec(str_join(array(str_extract_middle(_c0#2008684, 83, 7), str_extract_middle(_c0#2008684, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795]

WholeStageCodegen (2)

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

Project [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]

WholeStageCodegen (10)

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014], functions=[sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, 10), ENSURE_REQUIREMENTS, [plan_id=1099735]

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014], functions=[partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#2007852, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, str_remove_space(str_extract_middle(_c0#2007852, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, str_to_dec(str_join(array(str_extract_middle(_c0#2007852, 65, 7), str_extract_middle(_c0#2007852, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020]

WholeStageCodegen (3)

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

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, 10), ENSURE_REQUIREMENTS, [plan_id=1100046]

ObjectHashAggregate(keys=[COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948], functions=[collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, 10), ENSURE_REQUIREMENTS, [plan_id=1099764]

ObjectHashAggregate(keys=[COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948], functions=[partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)])

Project [N%C2%B0+SEJOUR#2011694 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, UCD#2011696 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, round(str_to_dec(quantit%C3%A9s#2011698, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952]

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

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [N%C2%B0+SEJOUR#2011694,UCD#2011696,quantit%C3%A9s#2011698] Batched: true, DataFilters: [isnotnull(N%C2%B0+SEJOUR#2011694), isnotnull(str_remove_space(N%C2%B0+SEJOUR#2011694, 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#2015217 ASC NULLS FIRST], false, 0

WholeStageCodegen (16)

AQEShuffleRead coalesced

Exchange hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, 10), ENSURE_REQUIREMENTS, [plan_id=1100290]

ObjectHashAggregate(keys=[COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733], functions=[collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, 10), ENSURE_REQUIREMENTS, [plan_id=1099808]

ObjectHashAggregate(keys=[COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733], functions=[partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)])

Project [str_complete(N%C2%B0+s%C3%A9jour#2013768, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, code+LPP#2013771 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, str_to_dec(quantit%C3%A9#2013773, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738]

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

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [N%C2%B0+s%C3%A9jour#2013768,code+LPP#2013771,quantit%C3%A9#2013773] Batched: true, DataFilters: [isnotnull(str_complete(N%C2%B0+s%C3%A9jour#2013768, 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 (120)
+- == Final Plan ==
   CollectLimit (73)
   +- * Project (72)
      +- * Project (71)
         +- * SortMergeJoin LeftOuter (70)
            :- * Sort (56)
            :  +- AQEShuffleRead (55)
            :     +- ShuffleQueryStage (54), Statistics(sizeInBytes=2.8 MiB, rowCount=2.11E+4)
            :        +- Exchange (53)
            :           +- * Project (52)
            :              +- * SortMergeJoin LeftOuter (51)
            :                 :- * Sort (37)
            :                 :  +- AQEShuffleRead (36)
            :                 :     +- ShuffleQueryStage (35), Statistics(sizeInBytes=3.0 MiB, rowCount=2.11E+4)
            :                 :        +- Exchange (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 (50)
            :                    +- AQEShuffleRead (49)
            :                       +- ShuffleQueryStage (48), Statistics(sizeInBytes=21.2 KiB, rowCount=268)
            :                          +- Exchange (47)
            :                             +- ObjectHashAggregate (46)
            :                                +- AQEShuffleRead (45)
            :                                   +- ShuffleQueryStage (44), Statistics(sizeInBytes=25.4 KiB, rowCount=268)
            :                                      +- Exchange (43)
            :                                         +- ObjectHashAggregate (42)
            :                                            +- * Project (41)
            :                                               +- * Filter (40)
            :                                                  +- * ColumnarToRow (39)
            :                                                     +- Scan parquet  (38)
            +- * Sort (69)
               +- AQEShuffleRead (68)
                  +- ShuffleQueryStage (67), Statistics(sizeInBytes=46.1 KiB, rowCount=440)
                     +- Exchange (66)
                        +- ObjectHashAggregate (65)
                           +- AQEShuffleRead (64)
                              +- ShuffleQueryStage (63), Statistics(sizeInBytes=57.0 KiB, rowCount=447)
                                 +- Exchange (62)
                                    +- ObjectHashAggregate (61)
                                       +- * Project (60)
                                          +- * Filter (59)
                                             +- * ColumnarToRow (58)
                                                +- Scan parquet  (57)
+- == Initial Plan ==
   CollectLimit (119)
   +- Project (118)
      +- Project (117)
         +- SortMergeJoin LeftOuter (116)
            :- Sort (108)
            :  +- Exchange (107)
            :     +- Project (106)
            :        +- SortMergeJoin LeftOuter (105)
            :           :- Sort (97)
            :           :  +- Exchange (96)
            :           :     +- Project (95)
            :           :        +- Project (94)
            :           :           +- SortMergeJoin FullOuter (93)
            :           :              :- Sort (86)
            :           :              :  +- Exchange (85)
            :           :              :     +- Project (84)
            :           :              :        +- SortMergeJoin FullOuter (83)
            :           :              :           :- Sort (76)
            :           :              :           :  +- Exchange (75)
            :           :              :           :     +- Project (74)
            :           :              :           :        +- Scan csv  (1)
            :           :              :           +- Sort (82)
            :           :              :              +- Project (81)
            :           :              :                 +- ObjectHashAggregate (80)
            :           :              :                    +- Exchange (79)
            :           :              :                       +- ObjectHashAggregate (78)
            :           :              :                          +- Project (77)
            :           :              :                             +- Scan csv  (7)
            :           :              +- Sort (92)
            :           :                 +- Project (91)
            :           :                    +- ObjectHashAggregate (90)
            :           :                       +- Exchange (89)
            :           :                          +- ObjectHashAggregate (88)
            :           :                             +- Project (87)
            :           :                                +- Scan csv  (22)
            :           +- Sort (104)
            :              +- Exchange (103)
            :                 +- ObjectHashAggregate (102)
            :                    +- Exchange (101)
            :                       +- ObjectHashAggregate (100)
            :                          +- Project (99)
            :                             +- Filter (98)
            :                                +- Scan parquet  (38)
            +- Sort (115)
               +- Exchange (114)
                  +- ObjectHashAggregate (113)
                     +- Exchange (112)
                        +- ObjectHashAggregate (111)
                           +- Project (110)
                              +- Filter (109)
                                 +- Scan parquet  (57)


(1) Scan csv 
Output [3]: [NO_ADMIN#2004618, MNT_MON#2004758, MNT_DMI#2004759]
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#2004618 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, str_to_dec(MNT_MON#2004758, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, str_to_dec(MNT_DMI#2004759, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, str_remove_space(NO_ADMIN#2004618, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Input [3]: [NO_ADMIN#2004618, MNT_MON#2004758, MNT_DMI#2004759]

(3) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1099701]

(4) ShuffleQueryStage
Output [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: 0

(5) AQEShuffleRead
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: coalesced

(6) Sort [codegen id : 6]
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313 ASC NULLS FIRST], false, 0

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

(9) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)]
Aggregate Attributes [2]: [sum#2010378, buf#2010379]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]

(10) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, 10), ENSURE_REQUIREMENTS, [plan_id=1099714]

(11) ShuffleQueryStage
Output [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795)#2008817, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)#2008819]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795)#2008817 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)#2008819 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837]

(14) Project [codegen id : 7]
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837]

(15) Sort [codegen id : 7]
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327 ASC NULLS FIRST], false, 0

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

(17) Project [codegen id : 8]
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]

(18) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1100170]

(19) ShuffleQueryStage
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: 6

(20) AQEShuffleRead
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: coalesced

(21) Sort [codegen id : 9]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313 ASC NULLS FIRST], false, 0

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

(24) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)]
Aggregate Attributes [2]: [sum#2010501, buf#2010502]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]

(25) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, 10), ENSURE_REQUIREMENTS, [plan_id=1099735]

(26) ShuffleQueryStage
Output [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Arguments: 2

(27) AQEShuffleRead
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Arguments: coalesced

(28) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020)#2008045, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)#2008047]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020)#2008045 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)#2008047 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065]

(29) Project [codegen id : 10]
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065]

(30) Sort [codegen id : 10]
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438 ASC NULLS FIRST], false, 0

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

(32) Project [codegen id : 11]
Output [12]: [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]

(33) Project [codegen id : 11]
Output [13]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Input [12]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]

(34) Exchange
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, 10), ENSURE_REQUIREMENTS, [plan_id=1100441]

(35) ShuffleQueryStage
Output [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: 8

(36) AQEShuffleRead
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: coalesced

(37) Sort [codegen id : 12]
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064 ASC NULLS FIRST], false, 0

(38) Scan parquet 
Output [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]
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>

(39) ColumnarToRow [codegen id : 4]
Input [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]

(40) Filter [codegen id : 4]
Input [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]
Condition : (isnotnull(N%C2%B0+SEJOUR#2011694) AND isnotnull(str_remove_space(N%C2%B0+SEJOUR#2011694, ALL)))

(41) Project [codegen id : 4]
Output [3]: [N%C2%B0+SEJOUR#2011694 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, UCD#2011696 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, round(str_to_dec(quantit%C3%A9s#2011698, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952]
Input [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]

(42) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948]
Functions [2]: [partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)]
Aggregate Attributes [2]: [buf#2015149, sum#2015150]
Results [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]

(43) Exchange
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Arguments: hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, 10), ENSURE_REQUIREMENTS, [plan_id=1099764]

(44) ShuffleQueryStage
Output [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Arguments: 3

(45) AQEShuffleRead
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Arguments: coalesced

(46) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948]
Functions [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)]
Aggregate Attributes [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0)#2013042, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)#2013044]
Results [3]: [str_remove_space(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, ALL) AS SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0)#2013042 AS SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, dec_to_int(sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)#2013044) AS SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]

(47) Exchange
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, 10), ENSURE_REQUIREMENTS, [plan_id=1100046]

(48) ShuffleQueryStage
Output [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: 5

(49) AQEShuffleRead
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: coalesced

(50) Sort [codegen id : 13]
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093 ASC NULLS FIRST], false, 0

(51) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064]
Right keys [1]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093]
Join type: LeftOuter
Join condition: None

(52) Project [codegen id : 14]
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095 AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Input [16]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]

(53) Exchange
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, 10), ENSURE_REQUIREMENTS, [plan_id=1100539]

(54) ShuffleQueryStage
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: 9

(55) AQEShuffleRead
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: coalesced

(56) Sort [codegen id : 15]
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049 ASC NULLS FIRST], false, 0

(57) Scan parquet 
Output [3]: [N%C2%B0+s%C3%A9jour#2013768, code+LPP#2013771, quantit%C3%A9#2013773]
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>

(58) ColumnarToRow [codegen id : 5]
Input [3]: [N%C2%B0+s%C3%A9jour#2013768, code+LPP#2013771, quantit%C3%A9#2013773]

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

(60) Project [codegen id : 5]
Output [3]: [str_complete(N%C2%B0+s%C3%A9jour#2013768, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, code+LPP#2013771 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, str_to_dec(quantit%C3%A9#2013773, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738]
Input [3]: [N%C2%B0+s%C3%A9jour#2013768, code+LPP#2013771, quantit%C3%A9#2013773]

(61) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733]
Functions [2]: [partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)]
Aggregate Attributes [2]: [buf#2015277, sum#2015278]
Results [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]

(62) Exchange
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Arguments: hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, 10), ENSURE_REQUIREMENTS, [plan_id=1099808]

(63) ShuffleQueryStage
Output [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Arguments: 4

(64) AQEShuffleRead
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Arguments: coalesced

(65) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733]
Functions [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)]
Aggregate Attributes [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0)#2014781, sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)#2014783]
Results [3]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0)#2014781 AS SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, bigint_to_str(str_to_bigint(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733)) AS SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, coalesce(dec_to_int(sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)#2014783), 0) AS SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]

(66) Exchange
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, 10), ENSURE_REQUIREMENTS, [plan_id=1100290]

(67) ShuffleQueryStage
Output [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: 7

(68) AQEShuffleRead
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: coalesced

(69) Sort [codegen id : 16]
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217 ASC NULLS FIRST], false, 0

(70) SortMergeJoin [codegen id : 17]
Left keys [1]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Right keys [1]: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217]
Join type: LeftOuter
Join condition: None

(71) Project [codegen id : 17]
Output [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, coalesce(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, 0) AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, coalesce(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 0) AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, coalesce(SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218, 0) AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, coalesce(COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197, 0) AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, str_list_diff(COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195) AS COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]

(72) Project [codegen id : 17]
Output [20]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, int_diff(array(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328)) AS COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041) AS COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327)) AS COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345]

(73) CollectLimit
Input [20]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]
Arguments: 1500

(74) Project
Output [4]: [NO_ADMIN#2004618 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, str_to_dec(MNT_MON#2004758, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, str_to_dec(MNT_DMI#2004759, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, str_remove_space(NO_ADMIN#2004618, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Input [3]: [NO_ADMIN#2004618, MNT_MON#2004758, MNT_DMI#2004759]

(75) Exchange
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1099584]

(76) Sort
Input [4]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313 ASC NULLS FIRST], false, 0

(77) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#2008684, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, str_remove_space(str_extract_middle(_c0#2008684, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, str_to_dec(str_join(array(str_extract_middle(_c0#2008684, 83, 7), str_extract_middle(_c0#2008684, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795]
Input [1]: [_c0#2008684]

(78) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)]
Aggregate Attributes [2]: [sum#2010378, buf#2010379]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]

(79) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, 10), ENSURE_REQUIREMENTS, [plan_id=1099579]

(80) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789, sum#2010380, buf#2010381]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795)#2008817, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)#2008819]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#2008789 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#2008795)#2008817 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#2008791, 0, 0)#2008819 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837]

(81) Project
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2008835, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2008836, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2008837]

(82) Sort
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327 ASC NULLS FIRST], false, 0

(83) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327]
Join type: FullOuter
Join condition: None

(84) Project
Output [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#2010327, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#2010328, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#2010329, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#2010330]

(85) Exchange
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, 10), ENSURE_REQUIREMENTS, [plan_id=1099594]

(86) Sort
Input [8]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313 ASC NULLS FIRST], false, 0

(87) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#2007852, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, str_remove_space(str_extract_middle(_c0#2007852, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, str_to_dec(str_join(array(str_extract_middle(_c0#2007852, 65, 7), str_extract_middle(_c0#2007852, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020]
Input [1]: [_c0#2007852]

(88) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)]
Aggregate Attributes [2]: [sum#2010501, buf#2010502]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]

(89) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, 10), ENSURE_REQUIREMENTS, [plan_id=1099589]

(90) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014, sum#2010503, buf#2010504]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020)#2008045, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)#2008047]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#2008014 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#2008020)#2008045 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#2008016, 0, 0)#2008047 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065]

(91) Project
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2008063, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2008064, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2008065]

(92) Sort
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438 ASC NULLS FIRST], false, 0

(93) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438]
Join type: FullOuter
Join condition: None

(94) Project
Output [12]: [COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 AS COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 AS COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 AS COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419 AS COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420 AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 AS COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440 AS COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441 AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438), 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, str_if_with_rule(((isnotnull(01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439) AND NOT (01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, str_remove_space(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, ALL) AS COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Input [12]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#2009786, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#2010310, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#2010311, COL_7948E047_29EE_472A_BFFC_723098878DAD#2010313, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#2010417, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#2010418, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#2010419, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#2010420, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#2010438, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#2010439, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#2010440, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#2010441]

(95) Project
Output [13]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049 AS COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Input [12]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]

(96) Exchange
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: hashpartitioning(COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, 10), ENSURE_REQUIREMENTS, [plan_id=1099606]

(97) Sort
Input [13]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Arguments: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064 ASC NULLS FIRST], false, 0

(98) Filter
Input [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]
Condition : (isnotnull(N%C2%B0+SEJOUR#2011694) AND isnotnull(str_remove_space(N%C2%B0+SEJOUR#2011694, ALL)))

(99) Project
Output [3]: [N%C2%B0+SEJOUR#2011694 AS COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, UCD#2011696 AS COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, round(str_to_dec(quantit%C3%A9s#2011698, ##.##), 2) AS COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952]
Input [3]: [N%C2%B0+SEJOUR#2011694, UCD#2011696, quantit%C3%A9s#2011698]

(100) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948]
Functions [2]: [partial_collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), partial_sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)]
Aggregate Attributes [2]: [buf#2015149, sum#2015150]
Results [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]

(101) Exchange
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Arguments: hashpartitioning(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, 10), ENSURE_REQUIREMENTS, [plan_id=1099600]

(102) ObjectHashAggregate
Input [3]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, buf#2015151, sum#2015152]
Keys [1]: [COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948]
Functions [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0), sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)]
Aggregate Attributes [2]: [collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0)#2013042, sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)#2013044]
Results [3]: [str_remove_space(COL_F9F96C8E_88C5_4F50_8E38_8609DC933CEA#2012948, ALL) AS SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, collect_list(COL_FE6DD7C0_DDB4_47E8_93D7_9E21F1AB51C2#2012950, 0, 0)#2013042 AS SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, dec_to_int(sum(COL_84A517DB_D957_4EEE_B2A8_30FC7DFD16F7#2012952)#2013044) AS SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]

(103) Exchange
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: hashpartitioning(SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, 10), ENSURE_REQUIREMENTS, [plan_id=1099607]

(104) Sort
Input [3]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]
Arguments: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093 ASC NULLS FIRST], false, 0

(105) SortMergeJoin
Left keys [1]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064]
Right keys [1]: [SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093]
Join type: LeftOuter
Join condition: None

(106) Project
Output [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094 AS COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095 AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Input [16]: [COL_08BB1328_B413_455F_B93A_BA75BC9D58C2#2015064, COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, SYNTHESE_MO_237830_COL_946985B2_1317_4E0F_8860_BCC73CE1B319#2015093, SYNTHESE_MO_237830_COL_B8CDE493_0801_4B62_8E1C_AFF6E7148ADA#2015094, SYNTHESE_MO_237830_COL_8DD4151F_8897_4E18_BD0E_54DAC7D23021#2015095]

(107) Exchange
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: hashpartitioning(COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, 10), ENSURE_REQUIREMENTS, [plan_id=1099618]

(108) Sort
Input [14]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197]
Arguments: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049 ASC NULLS FIRST], false, 0

(109) Filter
Input [3]: [N%C2%B0+s%C3%A9jour#2013768, code+LPP#2013771, quantit%C3%A9#2013773]
Condition : (isnotnull(str_complete(N%C2%B0+s%C3%A9jour#2013768, 0, 20, LEFT)) AND isnotnull(bigint_to_str(str_to_bigint(str_complete(N%C2%B0+s%C3%A9jour#2013768, 0, 20, LEFT)))))

(110) Project
Output [3]: [str_complete(N%C2%B0+s%C3%A9jour#2013768, 0, 20, LEFT) AS COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, code+LPP#2013771 AS COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, str_to_dec(quantit%C3%A9#2013773, ##.##) AS COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738]
Input [3]: [N%C2%B0+s%C3%A9jour#2013768, code+LPP#2013771, quantit%C3%A9#2013773]

(111) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733]
Functions [2]: [partial_collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), partial_sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)]
Aggregate Attributes [2]: [buf#2015277, sum#2015278]
Results [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]

(112) Exchange
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Arguments: hashpartitioning(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, 10), ENSURE_REQUIREMENTS, [plan_id=1099612]

(113) ObjectHashAggregate
Input [3]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733, buf#2015279, sum#2015280]
Keys [1]: [COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733]
Functions [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0), sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)]
Aggregate Attributes [2]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0)#2014781, sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)#2014783]
Results [3]: [collect_list(COL_02B457D4_211D_4296_9D9B_D989AD1EFF12#2014736, 0, 0)#2014781 AS SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, bigint_to_str(str_to_bigint(COL_38C3BE50_A7EE_41B8_BB22_8A6D1B6C1A8A#2014733)) AS SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, coalesce(dec_to_int(sum(COL_9F6C8A6D_788E_42DB_A61A_6AA75EF360C7#2014738)#2014783), 0) AS SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]

(114) Exchange
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: hashpartitioning(SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, 10), ENSURE_REQUIREMENTS, [plan_id=1099619]

(115) Sort
Input [3]: [SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]
Arguments: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217 ASC NULLS FIRST], false, 0

(116) SortMergeJoin
Left keys [1]: [COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049]
Right keys [1]: [SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217]
Join type: LeftOuter
Join condition: None

(117) Project
Output [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, coalesce(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, 0) AS COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, coalesce(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, 0) AS COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216 AS COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, coalesce(SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218, 0) AS COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, coalesce(COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197, 0) AS COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, str_list_diff(COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195) AS COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015042, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015045, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015197, SYNTHESE_DMI_237847_COL_366ECB86_7C6B_4706_8A94_E56AA45C57E8#2015216, SYNTHESE_DMI_237847_COL_3EFE5338_508A_40B8_A657_9886B74C9033#2015217, SYNTHESE_DMI_237847_COL_C7F70CCE_BC78_4FA4_AA37_81FFA69995D5#2015218]

(118) Project
Output [20]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, int_diff(array(COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328)) AS COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, str_list_diff(COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041) AS COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, int_diff(array(COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327)) AS COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]
Input [17]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345]

(119) CollectLimit
Input [20]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]
Arguments: 1500

(120) AdaptiveSparkPlan
Output [20]: [COL_870D5DD8_785F_4241_BE94_4ED7392076A6#2015038, COL_B98B1CBB_4E31_42B4_80E7_F8C516FF3F78#2015039, COL_7EA093C9_8CBE_46E0_A190_F7AFC8154B23#2015040, COL_3DAD77C6_D8FE_4BB4_8BC0_7F2604CB9B99#2015043, COL_BEC49058_4F8E_4468_9587_938BD2A506E7#2015046, COL_F9E92A20_5CFF_40C3_A329_B99182D56C78#2015047, COL_E80F54AB_2D79_44E5_BFE2_DD16B4008536#2015048, COL_EEED4DDE_3E30_4DD6_9226_2EB2D5C004D0#2015049, COL_F6C97BD8_8B69_4695_8E8D_9D05D183D2E6#2015044, COL_1AA03D66_A526_400F_BE3E_70FACABD4BFD#2015322, COL_1FAB19BD_DBCD_4E48_BB84_CB30DF479847#2015195, COL_8A4B5EC0_11D8_405F_8BA3_922895ABC9E7#2015041, COL_7B94B2D2_A500_4114_972D_0AFB651693B8#2015325, COL_55EB23D4_FA9A_4108_BCB9_CC93E2FB6939#2015326, COL_EE7E8B39_59A3_4427_B978_B8CD999731EB#2015327, COL_B6FEF6ED_9FBD_4A22_912F_E6F9F0215F27#2015328, COL_77D514E6_EEE5_4C31_9C12_235C9A40AE23#2015345, COL_02AD9CE1_FC91_4BDF_9DB5_6B9DCDDDE72D#2015440, COL_37C9A1A8_DA05_4C88_8FD4_2650968B3595#2015441, COL_D987528B_6075_4A06_8CFC_BA3E63F0460B#2015442]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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