SP1 - Details for Query 7091

Submitted Time: 2026/10/27 20:33:49
Duration: 2 s
Succeeded Jobs: 10600 10601 10602 10603 10604 10605 10607 10609

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B 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: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 1.2 s"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 1.2 s peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 1.2 s"; 10 [labelType="html" label="Sort sort time: 4 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 680.2 KiB number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 21,131 local merged chunks fetched: 0 shuffle write time: 3 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: 658.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: 4.5 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: 658.1 KiB"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 144 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 358 ms"; 17 [labelType="html" label="Sort sort time: 4 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 18 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 674.0 KiB number of coalesced partitions: 1"]; 19 [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: 647.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.0 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 647.4 KiB"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 71 ms"; 21 [labelType="html" label=" Project "]; 22 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 226 ms"; 24 [labelType="html" label="Sort sort time: 9 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 25 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 807.3 KiB number of coalesced partitions: 1"]; 26 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 10 ms (2 ms, 2 ms, 5 ms (stage 21132.0: task 27391)) 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 21132.0: task 27390)) 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 21132.0: task 27389))"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n370 ms (41 ms, 164 ms, 165 ms (stage 21132.0: task 27389))"; 28 [labelType="html" label=" Project "]; } 29 [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 cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1.8 m"; 31 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 32 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 14 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 33 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.8 KiB number of coalesced partitions: 1"]; 34 [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"]; 35 [labelType="html" label="ObjectHashAggregate number of output rows: 445 time in aggregation build: 61 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 61 ms"; 37 [labelType="html" label=" Project "]; } 38 [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 cluster39 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 310 ms"; 40 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 41 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 7 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 42 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 9.6 KiB number of coalesced partitions: 1"]; 43 [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"]; 44 [labelType="html" label="ObjectHashAggregate number of output rows: 464 time in aggregation build: 54 ms spill size: 0.0 B number of sort fallback tasks: 1"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 54 ms"; 46 [labelType="html" label=" Project "]; } 47 [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 cluster48 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 1.2 s"; 49 [labelType="html" label="Sort sort time: 5 ms peak memory: 16.5 MiB spill size: 0.0 B"]; 50 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 72 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"]; } 51 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 176.3 KiB number of coalesced partitions: 1"]; 52 [labelType="html" label="Exchange shuffle records written: 21,122 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (1 ms, 1 ms, 3 ms (stage 21135.0: task 27396)) 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 21135.0: task 27395)) 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 21135.0: task 27395))"]; subgraph cluster53 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n305 ms (17 ms, 139 ms, 149 ms (stage 21135.0: task 27395))"; 54 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 281 ms (9 ms, 131 ms, 141 ms (stage 21135.0: task 27395)) peak memory total (min, med, max (stageId: taskId)) 32.8 MiB (256.0 KiB, 16.3 MiB, 16.3 MiB (stage 21135.0: task 27394)) 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 21135.0: task 27394))"]; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label="Filter number of output rows: 26,044"]; } 57 [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"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 17->15; 18->17; 19->18; 21->19; 22->21; 24->22; 25->24; 26->25; 28->26; 29->28; 31->22; 32->31; 33->32; 34->33; 35->34; 37->35; 38->37; 40->15; 41->40; 42->41; 43->42; 44->43; 46->44; 47->46; 49->8; 50->49; 51->50; 52->51; 54->52; 55->54; 56->55; 57->56; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (14)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1035017]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

Filter (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0), ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0), ), ))), 300305363) END)

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013], [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843], LeftOuter

WholeStageCodegen (13)

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

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034901]

Project [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776 AS COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777 AS COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779 AS COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776], FullOuter

WholeStageCodegen (10)

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

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034746]

Project [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027], FullOuter

WholeStageCodegen (7)

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034444]

Project [FINESS#1708919 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, NO_RSS#1708920 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, NO_ADMIN#1708921 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, DATE_ENT#1708922 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, DATE_SOR#1708923 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, str_to_dec(MNT_MON#1709061, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, str_to_dec(MNT_DMI#1709062, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, str_to_dec(MNT_MED_APAC#1709063, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, str_remove_space(NO_ADMIN#1708921, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]

WholeStageCodegen (1)

FileScan csv [FINESS#1708919,NO_RSS#1708920,NO_ADMIN#1708921,DATE_ENT#1708922,DATE_SOR#1708923,MNT_MON#1709061,MNT_DMI#1709062,MNT_MED_APAC#1709063] 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#1713027 ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489], functions=[sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, 10), ENSURE_REQUIREMENTS, [plan_id=1034457]

ObjectHashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489], functions=[partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1711384, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, str_remove_space(str_extract_middle(_c0#1711384, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, str_to_dec(str_join(array(str_extract_middle(_c0#1711384, 83, 7), str_extract_middle(_c0#1711384, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495]

WholeStageCodegen (2)

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

WholeStageCodegen (9)

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606], functions=[sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, 10), ENSURE_REQUIREMENTS, [plan_id=1034477]

ObjectHashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606], functions=[partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)])

Project [str_remove_space(str_extract_middle(_c0#1710487, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, str_remove_space(str_extract_middle(_c0#1710487, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, str_to_dec(str_join(array(str_extract_middle(_c0#1710487, 65, 7), str_extract_middle(_c0#1710487, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612]

WholeStageCodegen (3)

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

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

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, 10), ENSURE_REQUIREMENTS, [plan_id=1034498]

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

Project [str_remove_space(str_extract_middle(_c0#1708226, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]

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

WholeStageCodegen (4)

FileScan csv [_c0#1708226] Batched: false, DataFilters: [isnotnull(str_remove_space(str_extract_middle(_c0#1708226, 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 (84)
+- == Final Plan ==
   * HashAggregate (50)
   +- ShuffleQueryStage (49), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (48)
         +- * HashAggregate (47)
            +- * Project (46)
               +- * Filter (45)
                  +- * SortMergeJoin LeftOuter (44)
                     :- * Sort (34)
                     :  +- AQEShuffleRead (33)
                     :     +- ShuffleQueryStage (32), Statistics(sizeInBytes=4.5 MiB, rowCount=2.11E+4)
                     :        +- Exchange (31)
                     :           +- * Project (30)
                     :              +- * SortMergeJoin FullOuter (29)
                     :                 :- * Sort (20)
                     :                 :  +- AQEShuffleRead (19)
                     :                 :     +- ShuffleQueryStage (18), Statistics(sizeInBytes=4.0 MiB, rowCount=2.11E+4)
                     :                 :        +- Exchange (17)
                     :                 :           +- * Project (16)
                     :                 :              +- * SortMergeJoin FullOuter (15)
                     :                 :                 :- * Sort (6)
                     :                 :                 :  +- AQEShuffleRead (5)
                     :                 :                 :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=3.5 MiB, rowCount=2.11E+4)
                     :                 :                 :        +- Exchange (3)
                     :                 :                 :           +- * Project (2)
                     :                 :                 :              +- Scan csv  (1)
                     :                 :                 +- * Sort (14)
                     :                 :                    +- ObjectHashAggregate (13)
                     :                 :                       +- AQEShuffleRead (12)
                     :                 :                          +- ShuffleQueryStage (11), Statistics(sizeInBytes=53.8 KiB, rowCount=445)
                     :                 :                             +- Exchange (10)
                     :                 :                                +- ObjectHashAggregate (9)
                     :                 :                                   +- * Project (8)
                     :                 :                                      +- Scan csv  (7)
                     :                 +- * Sort (28)
                     :                    +- ObjectHashAggregate (27)
                     :                       +- AQEShuffleRead (26)
                     :                          +- ShuffleQueryStage (25), Statistics(sizeInBytes=43.8 KiB, rowCount=464)
                     :                             +- Exchange (24)
                     :                                +- ObjectHashAggregate (23)
                     :                                   +- * Project (22)
                     :                                      +- Scan csv  (21)
                     +- * Sort (43)
                        +- * HashAggregate (42)
                           +- AQEShuffleRead (41)
                              +- ShuffleQueryStage (40), Statistics(sizeInBytes=825.1 KiB, rowCount=2.11E+4)
                                 +- Exchange (39)
                                    +- * HashAggregate (38)
                                       +- * Project (37)
                                          +- * Filter (36)
                                             +- Scan csv  (35)
+- == Initial Plan ==
   HashAggregate (83)
   +- Exchange (82)
      +- HashAggregate (81)
         +- Project (80)
            +- Filter (79)
               +- SortMergeJoin LeftOuter (78)
                  :- Sort (71)
                  :  +- Exchange (70)
                  :     +- Project (69)
                  :        +- SortMergeJoin FullOuter (68)
                  :           :- Sort (62)
                  :           :  +- Exchange (61)
                  :           :     +- Project (60)
                  :           :        +- SortMergeJoin FullOuter (59)
                  :           :           :- Sort (53)
                  :           :           :  +- Exchange (52)
                  :           :           :     +- Project (51)
                  :           :           :        +- Scan csv  (1)
                  :           :           +- Sort (58)
                  :           :              +- ObjectHashAggregate (57)
                  :           :                 +- Exchange (56)
                  :           :                    +- ObjectHashAggregate (55)
                  :           :                       +- Project (54)
                  :           :                          +- Scan csv  (7)
                  :           +- Sort (67)
                  :              +- ObjectHashAggregate (66)
                  :                 +- Exchange (65)
                  :                    +- ObjectHashAggregate (64)
                  :                       +- Project (63)
                  :                          +- Scan csv  (21)
                  +- Sort (77)
                     +- HashAggregate (76)
                        +- Exchange (75)
                           +- HashAggregate (74)
                              +- Project (73)
                                 +- Filter (72)
                                    +- Scan csv  (35)


(1) Scan csv 
Output [8]: [FINESS#1708919, NO_RSS#1708920, NO_ADMIN#1708921, DATE_ENT#1708922, DATE_SOR#1708923, MNT_MON#1709061, MNT_DMI#1709062, MNT_MED_APAC#1709063]
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#1708919 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, NO_RSS#1708920 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, NO_ADMIN#1708921 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, DATE_ENT#1708922 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, DATE_SOR#1708923 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, str_to_dec(MNT_MON#1709061, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, str_to_dec(MNT_DMI#1709062, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, str_to_dec(MNT_MED_APAC#1709063, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, str_remove_space(NO_ADMIN#1708921, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Input [8]: [FINESS#1708919, NO_RSS#1708920, NO_ADMIN#1708921, DATE_ENT#1708922, DATE_SOR#1708923, MNT_MON#1709061, MNT_DMI#1709062, MNT_MED_APAC#1709063]

(3) Exchange
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034444]

(4) ShuffleQueryStage
Output [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: 0

(5) AQEShuffleRead
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: coalesced

(6) Sort [codegen id : 5]
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

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

(9) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)]
Aggregate Attributes [2]: [sum#1713094, buf#1713095]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]

(10) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, 10), ENSURE_REQUIREMENTS, [plan_id=1034457]

(11) ShuffleQueryStage
Output [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Arguments: coalesced

(13) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495)#1711517, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)#1711519]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495)#1711517 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, size(collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)#1711519, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]

(14) Sort [codegen id : 6]
Input [3]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027 ASC NULLS FIRST], false, 0

(15) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027]
Join type: FullOuter
Join condition: None

(16) Project [codegen id : 7]
Output [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]

(17) Exchange
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034746]

(18) ShuffleQueryStage
Output [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: 4

(19) AQEShuffleRead
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: coalesced

(20) Sort [codegen id : 8]
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

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

(22) Project [codegen id : 3]
Output [3]: [str_remove_space(str_extract_middle(_c0#1710487, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, str_remove_space(str_extract_middle(_c0#1710487, 40, 15), ALL) AS COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, str_to_dec(str_join(array(str_extract_middle(_c0#1710487, 65, 7), str_extract_middle(_c0#1710487, 72, 3)), .), ##.##) AS COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612]
Input [1]: [_c0#1710487]

(23) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)]
Aggregate Attributes [2]: [sum#1714614, buf#1714615]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]

(24) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, 10), ENSURE_REQUIREMENTS, [plan_id=1034477]

(25) ShuffleQueryStage
Output [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Arguments: 2

(26) AQEShuffleRead
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Arguments: coalesced

(27) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612)#1710637, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)#1710639]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612)#1710637 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, size(collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)#1710639, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]

(28) Sort [codegen id : 9]
Input [3]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776 ASC NULLS FIRST], false, 0

(29) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776]
Join type: FullOuter
Join condition: None

(30) Project [codegen id : 10]
Output [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776 AS COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777 AS COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779 AS COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]

(31) Exchange
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034901]

(32) ShuffleQueryStage
Output [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: 5

(33) AQEShuffleRead
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: coalesced

(34) Sort [codegen id : 11]
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

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

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

(37) Project [codegen id : 4]
Output [1]: [str_remove_space(str_extract_middle(_c0#1708226, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Input [1]: [_c0#1708226]

(38) HashAggregate [codegen id : 4]
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1714906L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]

(39) Exchange
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, 10), ENSURE_REQUIREMENTS, [plan_id=1034498]

(40) ShuffleQueryStage
Output [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Arguments: 3

(41) AQEShuffleRead
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Arguments: coalesced

(42) HashAggregate [codegen id : 12]
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1708889L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, count(1)#1708889L AS RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]

(43) Sort [codegen id : 12]
Input [2]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843 ASC NULLS FIRST], false, 0

(44) SortMergeJoin [codegen id : 13]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843]
Join type: LeftOuter
Join condition: None

(45) Filter [codegen id : 13]
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300305363) END)

(46) Project [codegen id : 13]
Output: []
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]

(47) HashAggregate [codegen id : 13]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1715258L]
Results [1]: [count#1715259L]

(48) Exchange
Input [1]: [count#1715259L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1035017]

(49) ShuffleQueryStage
Output [1]: [count#1715259L]
Arguments: 6

(50) HashAggregate [codegen id : 14]
Input [1]: [count#1715259L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1715255L]
Results [1]: [count(1)#1715255L AS count#1715256L]

(51) Project
Output [9]: [FINESS#1708919 AS COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, NO_RSS#1708920 AS COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, NO_ADMIN#1708921 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, DATE_ENT#1708922 AS COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, DATE_SOR#1708923 AS COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, str_to_dec(MNT_MON#1709061, ##.##) AS COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, str_to_dec(MNT_DMI#1709062, ##.##) AS COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, str_to_dec(MNT_MED_APAC#1709063, ##.##) AS COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, str_remove_space(NO_ADMIN#1708921, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Input [8]: [FINESS#1708919, NO_RSS#1708920, NO_ADMIN#1708921, DATE_ENT#1708922, DATE_SOR#1708923, MNT_MON#1709061, MNT_DMI#1709062, MNT_MED_APAC#1709063]

(52) Exchange
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034347]

(53) Sort
Input [9]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

(54) Project
Output [3]: [str_remove_space(str_extract_middle(_c0#1711384, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, str_remove_space(str_extract_middle(_c0#1711384, 58, 15), ALL) AS COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, str_to_dec(str_join(array(str_extract_middle(_c0#1711384, 83, 7), str_extract_middle(_c0#1711384, 90, 3)), .), ##.##) AS COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495]
Input [1]: [_c0#1711384]

(55) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489]
Functions [2]: [partial_sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), partial_collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)]
Aggregate Attributes [2]: [sum#1713094, buf#1713095]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]

(56) Exchange
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, 10), ENSURE_REQUIREMENTS, [plan_id=1034343]

(57) ObjectHashAggregate
Input [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489, sum#1713096, buf#1713097]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489]
Functions [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495), collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)]
Aggregate Attributes [2]: [sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495)#1711517, collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)#1711519]
Results [3]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1711489 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, sum(COL_D5BDC7DD_D44E_48A3_9B1C_9502698A4711#1711495)#1711517 AS 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, size(collect_list(COL_F040A5AE_067B_4C74_963F_E0BF37DB3062#1711491, 0, 0)#1711519, true) AS 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]

(58) Sort
Input [3]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027 ASC NULLS FIRST], false, 0

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

(60) Project
Output [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027 AS COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028 AS COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030 AS COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1713027, 01_DMI_DECOUPAG_237714_COL_4FCA0043_B8FD_4D9C_9131_E8FB6612BA97#1713028, 01_DMI_DECOUPAG_237714_COL_EBE89F4A_8933_4794_A848_EDBB02E98148#1713030]

(61) Exchange
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034356]

(62) Sort
Input [12]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

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

(64) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606]
Functions [2]: [partial_sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), partial_collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)]
Aggregate Attributes [2]: [sum#1714614, buf#1714615]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]

(65) Exchange
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, 10), ENSURE_REQUIREMENTS, [plan_id=1034352]

(66) ObjectHashAggregate
Input [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606, sum#1714616, buf#1714617]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606]
Functions [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612), collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)]
Aggregate Attributes [2]: [sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612)#1710637, collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)#1710639]
Results [3]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1710606 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, sum(COL_0A5C8316_2B1D_4079_A885_539ABDD6AE21#1710612)#1710637 AS 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, size(collect_list(COL_598B29E8_BB51_4807_8D73_C5DC95DC0A1B#1710608, 0, 0)#1710639, true) AS 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]

(67) Sort
Input [3]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776 ASC NULLS FIRST], false, 0

(68) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776]
Join type: FullOuter
Join condition: None

(69) Project
Output [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776 AS COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777 AS COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779 AS COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1713776, 01_MOLECULES_ON_237708_COL_9BBF5C06_6C17_49B2_A3FE_90EF3C683E13#1713777, 01_MOLECULES_ON_237708_COL_8F51A0D2_4AFF_4145_8D18_ECF39F6D96AC#1713779]

(70) Exchange
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, 10), ENSURE_REQUIREMENTS, [plan_id=1034365]

(71) Sort
Input [15]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013 ASC NULLS FIRST], false, 0

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

(73) Project
Output [1]: [str_remove_space(str_extract_middle(_c0#1708226, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Input [1]: [_c0#1708226]

(74) HashAggregate
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1714906L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]

(75) Exchange
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, 10), ENSURE_REQUIREMENTS, [plan_id=1034361]

(76) HashAggregate
Input [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805, count#1714907L]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1708889L]
Results [2]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1708805 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, count(1)#1708889L AS RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]

(77) Sort
Input [2]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843 ASC NULLS FIRST], false, 0

(78) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843]
Join type: LeftOuter
Join condition: None

(79) Filter
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484)), 300305363) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013)), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363)) THEN false ELSE Contains(cast(COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820)), 300305363) END) OR CASE WHEN isnull(Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8)) THEN false ELSE Contains(cast(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363)) THEN false ELSE Contains(cast(COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823 as string), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843)), 300305363) END) OR CASE WHEN isnull(Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363)) THEN false ELSE Contains(cast(RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L as string), 300305363) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8)) THEN false ELSE Contains(cast(dec_diff(array(COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821)) as string), 3.00305363E8) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), str_join(array(str_join(array(séjour, str_if_with_rule(isnotnull(COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820), COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599)), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821) AND NOT (COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821 <=> 0.0)) AND (COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat MO > 0),  ), ))), 300305363) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300305363)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((isnotnull(COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600) AND NOT (COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600 <=> 0.0)) AND (COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011 <=> 0.0)), str_join(array(str_join(array(Séjour, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486), :), MNT=0 dans VisualValoSej et Somme Prix Achat DMI > 0),  ), ))), 300305363) END)

(80) Project
Output: []
Input [17]: [COL_A550BCCC_9BE4_4A7E_B8C2_C79C2F4C596B#1712484, COL_91F8175D_C130_4A24_9C58_B4A1293D24D5#1712485, COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1712486, COL_0DBBD117_79DB_447B_BFE1_357047D1E2BE#1712487, COL_BCA5A9C9_0944_4896_9F41_F17E7B2E9808#1712488, COL_BFF77BEA_200A_4C53_B471_B525369EA9A7#1713010, COL_69559A5C_0C41_4CB2_96CF_04A925684F4F#1713011, COL_A697FBC1_9722_4BF2_BAA6_230B6A4E5695#1713012, COL_7948E047_29EE_472A_BFFC_723098878DAD#1713013, COL_D83A595E_7901_4A79_9DA3_AB68A1511B8A#1713599, COL_39C8884B_DA27_4330_98D0_A2BF04D115A7#1713600, COL_7079D2AA_3FE2_46EB_982D_2356206AD269#1713602, COL_9C202D8A_4F64_42F0_A65F_71942C7BE40E#1714820, COL_733BDCC1_2882_46E4_BA7E_7CBC295735A6#1714821, COL_89B5256A_2333_4D3C_912C_E97E66B52D35#1714823, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1714843, RSS_DECOUPAGE_237747_COL_DA12DA4A_7F92_4A9F_B834_A5427EABE846#1714844L]

(81) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1715258L]
Results [1]: [count#1715259L]

(82) Exchange
Input [1]: [count#1715259L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1034373]

(83) HashAggregate
Input [1]: [count#1715259L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1715255L]
Results [1]: [count(1)#1715255L AS count#1715256L]

(84) AdaptiveSparkPlan
Output [1]: [count#1715256L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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