SP1 - Details for Query 7122

Submitted Time: 2026/10/27 20:36:27
Duration: 2 s
Succeeded Jobs: 10633 10634 10635 10636 10637 10638 10639

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 (13)\n \nduration: 1.0 s"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 1"]; 5 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 1.0 s"; 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: 714.2 KiB number of coalesced partitions: 1"]; 9 [labelType="html" label="Exchange shuffle records written: 21,131 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,131 local bytes read: 680.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: 4.9 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: 680.9 KiB"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 72 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 (8)\n \nduration: 168 ms"; 14 [labelType="html" label="Sort sort time: 4 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 15 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 700.6 KiB number of coalesced partitions: 1"]; 16 [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: 667.4 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: 4.2 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: 667.4 KiB"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 60 ms"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 138 ms"; 21 [labelType="html" label="Sort sort time: 9 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 22 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 807.3 KiB number of coalesced partitions: 1"]; 23 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 11 ms (2 ms, 2 ms, 6 ms (stage 21215.0: task 27436)) 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: 763.8 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)) 3.5 MiB (114.0 KiB, 1758.1 KiB, 1758.1 KiB (stage 21215.0: task 27435)) 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)) 763.8 KiB (26.0 KiB, 368.4 KiB, 369.4 KiB (stage 21215.0: task 27434))"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n328 ms (23 ms, 151 ms, 154 ms (stage 21215.0: task 27434))"; 25 [labelType="html" label=" Project "]; } 26 [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 cluster27 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1.4 m"; 28 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 29 [labelType="html" label=" Project "]; } 30 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 6 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 31 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.8 KiB number of coalesced partitions: 1"]; 32 [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"]; 33 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 33 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 33 ms"; 35 [labelType="html" label=" Project "]; } 36 [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 cluster37 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 146 ms"; 38 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 39 [labelType="html" label=" Project "]; } 40 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 8 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 41 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 42 [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"]; 43 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 13 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster44 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 13 ms"; 45 [labelType="html" label=" Project "]; } 46 [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 cluster47 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 1.0 s"; 48 [labelType="html" label="Sort sort time: 6 ms peak memory: 16.5 MiB spill size: 0.0 B"]; 49 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 15 ms peak memory: 17.0 MiB number of output rows: 21,121 number of sort fallback tasks: 0 avg hash probes per key: 1.5"]; } 50 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 176.3 KiB number of coalesced partitions: 1"]; 51 [labelType="html" label="Exchange shuffle records written: 21,122 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 39 ms (1 ms, 3 ms, 34 ms (stage 21218.0: task 27441)) 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,122 local bytes read: 166.6 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)) 825.1 KiB (6.6 KiB, 395.2 KiB, 423.3 KiB (stage 21218.0: task 27440)) 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)) 166.6 KiB (2.4 KiB, 79.6 KiB, 84.6 KiB (stage 21218.0: task 27440))"]; subgraph cluster52 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n320 ms (13 ms, 125 ms, 182 ms (stage 21218.0: task 27439))"; 53 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 260 ms (6 ms, 113 ms, 141 ms (stage 21218.0: task 27439)) peak memory total (min, med, max (stageId: taskId)) 32.8 MiB (256.0 KiB, 16.3 MiB, 16.3 MiB (stage 21218.0: task 27440)) number of output rows: 21,122 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 21218.0: task 27440))"]; 54 [labelType="html" label=" Project "]; 55 [labelType="html" label="Filter number of output rows: 26,044"]; } 56 [labelType="html" label="Scan csv number of output rows: 26,044 number of files read: 1 metadata time: 0 ms size of files read: 8.0 MiB"]; 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; 21->19; 22->21; 23->22; 25->23; 26->25; 28->19; 29->28; 30->29; 31->30; 32->31; 33->32; 35->33; 36->35; 38->12; 39->38; 40->39; 41->40; 42->41; 43->42; 45->43; 46->45; 48->5; 49->48; 50->49; 51->50; 53->51; 54->53; 55->54; 56->55; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413 AS COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L AS COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) AS COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) AS COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ) AS COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ) AS COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]

Filter (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ))), 300387085) END)

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151], [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413], LeftOuter

WholeStageCodegen (13)

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

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037998]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276], FullOuter

WholeStageCodegen (10)

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

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037857]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165], FullOuter

WholeStageCodegen (7)

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037554]

Project [FINESS#1721410 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, NO_RSS#1721411 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, NO_ADMIN#1721412 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, DATE_ENT#1721413 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, DATE_SOR#1721414 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, str_to_dec(MNT_MON#1721552, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, str_to_dec(MNT_DMI#1721553, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, str_to_dec(MNT_MED_APAC#1721554, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, str_remove_space(NO_ADMIN#1721412, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]

WholeStageCodegen (1)

FileScan csv [FINESS#1721410,NO_RSS#1721411,NO_ADMIN#1721412,DATE_ENT#1721413,DATE_SOR#1721414,MNT_MON#1721552,MNT_DMI#1721553,MNT_MED_APAC#1721554] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,MNT_MON:string...

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

Project [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]

WholeStageCodegen (6)

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627], functions=[sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, 10), ENSURE_REQUIREMENTS, [plan_id=1037567]

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627], functions=[partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1725522, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, str_remove_space(str_extract_middle(_c0#1725522, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, str_to_dec(str_join(array(str_extract_middle(_c0#1725522, 83, 7), str_extract_middle(_c0#1725522, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633]

WholeStageCodegen (2)

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

Project [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]

WholeStageCodegen (9)

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410], functions=[sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, 10), ENSURE_REQUIREMENTS, [plan_id=1037588]

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410], functions=[partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1725273, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, str_remove_space(str_extract_middle(_c0#1725273, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, str_to_dec(str_join(array(str_extract_middle(_c0#1725273, 65, 7), str_extract_middle(_c0#1725273, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416]

WholeStageCodegen (3)

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

HashAggregate(keys=[COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268], functions=[count(1)])

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, 10), ENSURE_REQUIREMENTS, [plan_id=1037619]

HashAggregate(keys=[COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268], functions=[partial_count(1)])

Project [str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]

Filter isnotnull(str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL))

WholeStageCodegen (4)

FileScan csv [_c0#1720487] Batched: false, DataFilters: [isnotnull(str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL))], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSS_M12_2025_237542/RSS- 420780652.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (83)
+- == Final Plan ==
   CollectLimit (49)
   +- * Project (48)
      +- * Filter (47)
         +- * SortMergeJoin LeftOuter (46)
            :- * Sort (36)
            :  +- AQEShuffleRead (35)
            :     +- ShuffleQueryStage (34), Statistics(sizeInBytes=4.9 MiB, rowCount=2.11E+4)
            :        +- Exchange (33)
            :           +- * Project (32)
            :              +- * SortMergeJoin FullOuter (31)
            :                 :- * Sort (21)
            :                 :  +- AQEShuffleRead (20)
            :                 :     +- ShuffleQueryStage (19), Statistics(sizeInBytes=4.2 MiB, rowCount=2.11E+4)
            :                 :        +- Exchange (18)
            :                 :           +- * Project (17)
            :                 :              +- * SortMergeJoin FullOuter (16)
            :                 :                 :- * Sort (6)
            :                 :                 :  +- AQEShuffleRead (5)
            :                 :                 :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=3.5 MiB, 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 (45)
               +- * HashAggregate (44)
                  +- AQEShuffleRead (43)
                     +- ShuffleQueryStage (42), Statistics(sizeInBytes=825.1 KiB, rowCount=2.11E+4)
                        +- Exchange (41)
                           +- * HashAggregate (40)
                              +- * Project (39)
                                 +- * Filter (38)
                                    +- Scan csv  (37)
+- == Initial Plan ==
   CollectLimit (82)
   +- Project (81)
      +- Filter (80)
         +- SortMergeJoin LeftOuter (79)
            :- Sort (72)
            :  +- Exchange (71)
            :     +- Project (70)
            :        +- SortMergeJoin FullOuter (69)
            :           :- Sort (62)
            :           :  +- Exchange (61)
            :           :     +- Project (60)
            :           :        +- SortMergeJoin FullOuter (59)
            :           :           :- Sort (52)
            :           :           :  +- Exchange (51)
            :           :           :     +- Project (50)
            :           :           :        +- Scan csv  (1)
            :           :           +- Sort (58)
            :           :              +- Project (57)
            :           :                 +- ObjectHashAggregate (56)
            :           :                    +- Exchange (55)
            :           :                       +- ObjectHashAggregate (54)
            :           :                          +- Project (53)
            :           :                             +- Scan csv  (7)
            :           +- Sort (68)
            :              +- Project (67)
            :                 +- ObjectHashAggregate (66)
            :                    +- Exchange (65)
            :                       +- ObjectHashAggregate (64)
            :                          +- Project (63)
            :                             +- Scan csv  (22)
            +- Sort (78)
               +- HashAggregate (77)
                  +- Exchange (76)
                     +- HashAggregate (75)
                        +- Project (74)
                           +- Filter (73)
                              +- Scan csv  (37)


(1) Scan csv 
Output [8]: [FINESS#1721410, NO_RSS#1721411, NO_ADMIN#1721412, DATE_ENT#1721413, DATE_SOR#1721414, MNT_MON#1721552, MNT_DMI#1721553, MNT_MED_APAC#1721554]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,MNT_MON:string,MNT_DMI:string,MNT_MED_APAC:string>

(2) Project [codegen id : 1]
Output [9]: [FINESS#1721410 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, NO_RSS#1721411 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, NO_ADMIN#1721412 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, DATE_ENT#1721413 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, DATE_SOR#1721414 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, str_to_dec(MNT_MON#1721552, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, str_to_dec(MNT_DMI#1721553, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, str_to_dec(MNT_MED_APAC#1721554, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, str_remove_space(NO_ADMIN#1721412, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Input [8]: [FINESS#1721410, NO_RSS#1721411, NO_ADMIN#1721412, DATE_ENT#1721413, DATE_SOR#1721414, MNT_MON#1721552, MNT_DMI#1721553, MNT_MED_APAC#1721554]

(3) Exchange
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037554]

(4) ShuffleQueryStage
Output [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: 0

(5) AQEShuffleRead
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: coalesced

(6) Sort [codegen id : 5]
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

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

(9) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)]
Aggregate Attributes [2]: [sum#1727216, buf#1727217]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]

(10) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, 10), ENSURE_REQUIREMENTS, [plan_id=1037567]

(11) ShuffleQueryStage
Output [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633)#1725655, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)#1725657]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633)#1725655 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)#1725657 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675]

(14) Project [codegen id : 6]
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675]

(15) Sort [codegen id : 6]
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165]
Join type: FullOuter
Join condition: None

(17) Project [codegen id : 7]
Output [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]

(18) Exchange
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037857]

(19) ShuffleQueryStage
Output [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: 4

(20) AQEShuffleRead
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: coalesced

(21) Sort [codegen id : 8]
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

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

(24) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)]
Aggregate Attributes [2]: [sum#1727339, buf#1727340]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]

(25) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, 10), ENSURE_REQUIREMENTS, [plan_id=1037588]

(26) ShuffleQueryStage
Output [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Arguments: 2

(27) AQEShuffleRead
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Arguments: coalesced

(28) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416)#1725441, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)#1725443]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416)#1725441 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)#1725443 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461]

(29) Project [codegen id : 9]
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461]

(30) Sort [codegen id : 9]
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276 ASC NULLS FIRST], false, 0

(31) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276]
Join type: FullOuter
Join condition: None

(32) Project [codegen id : 10]
Output [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276 AS COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277 AS COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278 AS COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279 AS COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]

(33) Exchange
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037998]

(34) ShuffleQueryStage
Output [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: 5

(35) AQEShuffleRead
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: coalesced

(36) Sort [codegen id : 11]
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

(37) Scan csv 
Output [1]: [_c0#1720487]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSS_M12_2025_237542/RSS- 420780652.txt]
ReadSchema: struct<_c0:string>

(38) Filter [codegen id : 4]
Input [1]: [_c0#1720487]
Condition : isnotnull(str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL))

(39) Project [codegen id : 4]
Output [1]: [str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Input [1]: [_c0#1720487]

(40) HashAggregate [codegen id : 4]
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1727476L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]

(41) Exchange
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, 10), ENSURE_REQUIREMENTS, [plan_id=1037619]

(42) ShuffleQueryStage
Output [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Arguments: 3

(43) AQEShuffleRead
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Arguments: coalesced

(44) HashAggregate [codegen id : 12]
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1721352L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, count(1)#1721352L AS RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]

(45) Sort [codegen id : 12]
Input [2]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413 ASC NULLS FIRST], false, 0

(46) SortMergeJoin [codegen id : 13]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413]
Join type: LeftOuter
Join condition: None

(47) Filter [codegen id : 13]
Input [19]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300387085) END)

(48) Project [codegen id : 13]
Output [24]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413 AS COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L AS COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) AS COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) AS COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]
Input [19]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]

(49) CollectLimit
Input [24]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]
Arguments: 1500

(50) Project
Output [9]: [FINESS#1721410 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, NO_RSS#1721411 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, NO_ADMIN#1721412 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, DATE_ENT#1721413 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, DATE_SOR#1721414 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, str_to_dec(MNT_MON#1721552, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, str_to_dec(MNT_DMI#1721553, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, str_to_dec(MNT_MED_APAC#1721554, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, str_remove_space(NO_ADMIN#1721412, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Input [8]: [FINESS#1721410, NO_RSS#1721411, NO_ADMIN#1721412, DATE_ENT#1721413, DATE_SOR#1721414, MNT_MON#1721552, MNT_DMI#1721553, MNT_MED_APAC#1721554]

(51) Exchange
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037478]

(52) Sort
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

(53) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1725522, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, str_remove_space(str_extract_middle(_c0#1725522, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, str_to_dec(str_join(array(str_extract_middle(_c0#1725522, 83, 7), str_extract_middle(_c0#1725522, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633]
Input [1]: [_c0#1725522]

(54) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)]
Aggregate Attributes [2]: [sum#1727216, buf#1727217]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]

(55) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, 10), ENSURE_REQUIREMENTS, [plan_id=1037473]

(56) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627, sum#1727218, buf#1727219]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633)#1725655, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)#1725657]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1725627 AS COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1725633)#1725655 AS COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1725629, 0, 0)#1725657 AS COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675]

(57) Project
Output [4]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675 AS 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, size(COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]
Input [3]: [COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1725673, COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1725674, COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1725675]

(58) Sort
Input [4]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165 ASC NULLS FIRST], false, 0

(59) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165]
Join type: FullOuter
Join condition: None

(60) Project
Output [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167 AS COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1727165, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1727166, 01_DMI_DECOUPAG_237714_COL_E81EF7B0_01E6_4AA0_8C40_EDDFA15A663F#1727167, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1727168]

(61) Exchange
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037488]

(62) Sort
Input [13]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

(63) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1725273, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, str_remove_space(str_extract_middle(_c0#1725273, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, str_to_dec(str_join(array(str_extract_middle(_c0#1725273, 65, 7), str_extract_middle(_c0#1725273, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416]
Input [1]: [_c0#1725273]

(64) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)]
Aggregate Attributes [2]: [sum#1727339, buf#1727340]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]

(65) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, 10), ENSURE_REQUIREMENTS, [plan_id=1037483]

(66) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410, sum#1727341, buf#1727342]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416)#1725441, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)#1725443]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1725410 AS COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1725416)#1725441 AS COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1725412, 0, 0)#1725443 AS COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461]

(67) Project
Output [4]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461 AS 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, size(COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]
Input [3]: [COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1725459, COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1725460, COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1725461]

(68) Sort
Input [4]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276 ASC NULLS FIRST], false, 0

(69) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276]
Join type: FullOuter
Join condition: None

(70) Project
Output [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276 AS COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277 AS COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278 AS COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279 AS COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1727276, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1727277, 01_MOLECULES_ON_237708_COL_A6806796_8041_41B8_9FE8_E4AC89885E74#1727278, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1727279]

(71) Exchange
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, 10), ENSURE_REQUIREMENTS, [plan_id=1037497]

(72) Sort
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151 ASC NULLS FIRST], false, 0

(73) Filter
Input [1]: [_c0#1720487]
Condition : isnotnull(str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL))

(74) Project
Output [1]: [str_remove_space(str_extract_middle(_c0#1720487, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Input [1]: [_c0#1720487]

(75) HashAggregate
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1727476L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]

(76) Exchange
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, 10), ENSURE_REQUIREMENTS, [plan_id=1037493]

(77) HashAggregate
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268, count#1727477L]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1721352L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1721268 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, count(1)#1721352L AS RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]

(78) Sort
Input [2]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413 ASC NULLS FIRST], false, 0

(79) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413]
Join type: LeftOuter
Join condition: None

(80) Filter
Input [19]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622)), 300387085) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151)), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390)), 300387085) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393 as string), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413)), 300387085) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L as string), 300387085) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) as string), 3.00387085E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300387085) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300387085)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300387085) END)

(81) Project
Output [24]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413 AS COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L AS COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256)) AS COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391)) AS COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ) AS COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ) AS COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]
Input [19]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1727413, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1727414L]

(82) CollectLimit
Input [24]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]
Arguments: 1500

(83) AdaptiveSparkPlan
Output [24]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1726622, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1726623, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1726624, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1726625, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1726626, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1727148, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1727149, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1727150, COL_7948E047_29EE_472A_BFFC_723098878DAD#1727151, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1727255, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1727256, COL_81387DBF_EB63_4E9C_8FF4_90F5FC4D3A4A#1727257, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1727258, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1727390, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1727391, COL_C57BA7DE_5981_45CA_804F_64BDD3C948B6#1727392, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1727393, COL_1D43C4C0_AE5C_43DC_ABA0_79E72CBFE6D4#1727770, COL_3B76CC9E_15AD_4146_ADF0_E51262B0273B#1727771L, COL_B76B4963_04A1_4775_AD0C_A8C8D12E32EC#1727772, COL_E151C115_133D_43F0_B7F2_3D04EC2C9E7A#1727773, COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1727774, COL_38DD5D0F_E9B5_495B_BA9B_2087179C0422#1727775, COL_A767E3C2_9432_4B23_B183_2DC747AE79DA#1727776]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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