DC2 - Details for Query 108

Details for Query 108

Submitted Time: 2025/11/07 08:58:45
Duration: 0.8 s
Succeeded Jobs: 172 175 178 179

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 "]; 2 [labelType="html" label="HashAggregate spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 252.0: task 652)) time in aggregation build total (min, med, max (stageId: taskId)) 186 ms (6 ms, 7 ms, 36 ms (stage 252.0: task 652)) peak memory total (min, med, max (stageId: taskId)) 1285.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 252.0: task 652)) number of output rows: 231 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 252.0: task 652))"]; 3 [labelType="html" label="HashAggregate spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 252.0: task 652)) time in aggregation build total (min, med, max (stageId: taskId)) 378 ms (8 ms, 13 ms, 107 ms (stage 252.0: task 652)) peak memory total (min, med, max (stageId: taskId)) 1285.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 252.0: task 652)) number of output rows: 231 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 252.0: task 652))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n378 ms (8 ms, 13 ms, 107 ms (stage 252.0: task 652))"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 194 ms (5 ms, 8 ms, 23 ms (stage 258.0: task 673)) peak memory total (min, med, max (stageId: taskId)) 1285.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 252.0: task 652)) number of output rows: 378 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 252.0: task 652))"]; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 142 ms (3 ms, 5 ms, 20 ms (stage 258.0: task 673)) peak memory total (min, med, max (stageId: taskId)) 5.0 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 252.0: task 652)) number of output rows: 378 avg hash probe bucket list iters: 0"]; 7 [labelType="html" label=" Project "]; } 8 [labelType="html" label="Generate number of output rows: 378"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n291 ms (7 ms, 11 ms, 66 ms (stage 252.0: task 652))"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 252.0: task 652)) peak memory total (min, med, max (stageId: taskId)) 1285.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 252.0: task 652)) number of output rows: 21 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 252.0: task 652))"]; } 12 [labelType="html" label=" CustomShuffleReader "]; 13 [labelType="html" label="Exchange shuffle records written: 21 shuffle write time: 6 ms records read: 21 local bytes read total (min, med, max (stageId: taskId)) 2.3 KiB (94.0 B, 113.0 B, 189.0 B (stage 252.0: task 652)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 252.0: task 652)) remote bytes read: 0.0 B local blocks read: 20 remote blocks read: 0 data size: 3.9 KiB remote bytes read to disk: 0.0 B shuffle bytes written: 2.3 KiB"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n96 ms (35 ms, 61 ms, 61 ms (stage 247.0: task 647))"; 15 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 30 ms (3 ms, 27 ms, 27 ms (stage 247.0: task 647)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 247.0: task 648)) number of output rows: 21 avg hash probe bucket list iters: 0"]; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="ColumnarToRow number of output rows: 5,424 number of input batches: 2"]; } 18 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 6 ms (3 ms, 3 ms, 3 ms (stage 247.0: task 648)) metadata time: 0 ms size of files read: 582.8 KiB number of output rows: 5,424"]; 1->0; 2->1; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], functions=[pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)])

HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], functions=[partial_pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)])

HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], functions=[sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L)])

HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], functions=[partial_sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L)])

Project [col1#28118L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(col0#28117)), INIT)) THEN false ELSE Contains(str_remove_accent(upper(col0#28117)), INIT) END, Avant traitement qualité, Après traitement qualité) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, str_join(struct(col1, str_transform_case(str_replace_extend(col0#28117, [ (Init) - Vide ou Null_SUM, (Final) - Vide ou Null_SUM, (Init) - Vide ou null_SUM], [,,]), UPPER), col2, non renseigné), - ) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297]

WholeStageCodegen (3)

Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L], false, [col0#28117, col1#28118L]

Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L]

HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], functions=[first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true), sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)), sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)), sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)), sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)), sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)), sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)), sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)), sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)), sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)), sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)), sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)), sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)), sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)), sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)), sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)), sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)), sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)), sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint))])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, 200), true, [id=#4389]

HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], functions=[partial_first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true), partial_sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)), partial_sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)), partial_sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)), partial_sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)), partial_sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)), partial_sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)), partial_sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)), partial_sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)), partial_sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)), partial_sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)), partial_sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)), partial_sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)), partial_sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)), partial_sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)), partial_sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)), partial_sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)), partial_sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)), partial_sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint))])

Project [COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27538 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905, COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27541 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906, COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27544 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907, COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27540 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908, COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27545 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909, COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27528 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910, COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27529 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911, COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27527 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912, COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27525 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913, COL_45927A2C_7B5E_46F0_B288_4E446278061F#27535 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914, COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27534 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915, COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27531 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916, COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27530 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917, COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27533 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918, COL_726D968C_42FA_4E31_BD79_225187FD2C06#27532 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919, COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27536 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920, COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27537 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921, COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27526 AS COL_013B4432_4745_457D_A136_EA9290A58319#27922, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513 AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27542L AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27525,COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27526,COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27527,COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27528,COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27529,COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27530,COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27531,COL_726D968C_42FA_4E31_BD79_225187FD2C06#27532,COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27533,COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27534,COL_45927A2C_7B5E_46F0_B288_4E446278061F#27535,COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27536,COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27537,COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27538,COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27540,COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27541,COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27542L,COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27544,COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27545] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EVALUATION_QUAL_37976], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_09DD6C48_8262_414D_9D00_17FFFC613E44:string,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2:i...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29212 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29240, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29213 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29241, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29214L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29242L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29215 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29243, COL_F347CA59_C1A7_4324_B43B_588C17452144#29216L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29244L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29217 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29245, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29218 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29246, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29219L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29247L]
      +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29196 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29212, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29197 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29213, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29198L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29214L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29199 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29215, COL_F347CA59_C1A7_4324_B43B_588C17452144#29200L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29216L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29201 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29217, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29202 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29218, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29203L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29219L]
         +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29147 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29196, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29148 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29197, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29149L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29198L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29150 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29199, COL_F347CA59_C1A7_4324_B43B_588C17452144#29151L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29200L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29152 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29201, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29153 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29202, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29154L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29203L]
            +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29131 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29147, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29132 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29148, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29133L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29149L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29134 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29150, COL_F347CA59_C1A7_4324_B43B_588C17452144#29135L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29151L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29136 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29152, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29137 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29153, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29138L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29154L]
               +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29115 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29131, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29116 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29132, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29117L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29133L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29118 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29134, COL_F347CA59_C1A7_4324_B43B_588C17452144#29119L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29135L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29120 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29136, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29121 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29137, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29122L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29138L]
                  +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29098 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29115, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29099 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29116, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29100L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29117L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29101 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29118, COL_F347CA59_C1A7_4324_B43B_588C17452144#29102L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29119L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29103 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29120, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29104 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29121, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29105L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29122L]
                     +- Project [cast(QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#29069 as string) AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29098, cast(QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29070 as string) AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29099, cast(QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29071L as bigint) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29100L, cast(QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#29072 as string) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29101, cast(QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29073L as bigint) AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29102L, cast(QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29074 as string) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29103, cast(QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29075 as double) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29104, cast(QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#29076L as bigint) AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29105L]
                        +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28950 AS QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#29069, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28951 AS QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29070, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28952L AS QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29071L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28953 AS QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#29072, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28954L AS QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29073L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28955 AS QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29074, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28956 AS QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29075, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28957L AS QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#29076L]
                           +- SubqueryAlias QUALITE_SYNTHES_38119115
                              +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28950, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28951, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28952L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#28953, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28954L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28955, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28922 AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28956, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28957L]
                                 +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28922]
                                    +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851]
                                       +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#28767]
                                          +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28750 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28752L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28753L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L]
                                             +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28750, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28744L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28752L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28753L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L]
                                                +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28744L]
                                                   +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                      +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                         +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, Avant traitement qualité_NULL_1#28487, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                            +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478[0] AS Après traitement qualité_NULL_1#28485, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478[1] AS Avant traitement qualité_NULL_1#28487, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                               +- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, 1 AS `NULL_1`#28349, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484]
                                                                  +- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, 1 AS 1 AS `NULL_1`#28349, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L]
                                                                     +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( -  as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297]
                                                                        +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291]
                                                                           +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28202 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28203L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L]
                                                                              +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28202, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28128L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28203L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L]
                                                                                 +- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123, col1#28118L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28128L]
                                                                                    +- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, col0#28117 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123, col1#28118L]
                                                                                       +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, col0#28117, col1#28118L]
                                                                                          +- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28075L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28076L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28077L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28078L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28079L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28080L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28081L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28082L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28083L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28084L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28085L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28117, col1#28118L]
                                                                                             +- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28075L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28076L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28077L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28078L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28079L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28080L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28081L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28082L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28083L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28084L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28085L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28086L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28087L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28088L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28089L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28090L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28091L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28092L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28093L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L]
                                                                                                +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                   +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                      +- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, 1 AS NULL_1#28010, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27924L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                         +- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27862 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27863 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27864 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27865 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27866 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27867 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27868 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27869 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27870 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27871 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27872 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27873 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27874 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27875 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27876 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27877 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27878 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921, COL_013B4432_4745_457D_A136_EA9290A58319#27879 AS COL_013B4432_4745_457D_A136_EA9290A58319#27922, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27861 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27923, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27880L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27924L, COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                                                                                                            +- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27717 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27861, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27756 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27862, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27759 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27863, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27762 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27864, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27758 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27865, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27763 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27866, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27746 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27867, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27747 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27868, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27745 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27869, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27743 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27870, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#27753 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27871, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27752 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27872, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27749 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27873, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27748 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27874, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27751 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27875, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#27750 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27876, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27754 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27877, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27755 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27878, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27744 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#27879, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#27761L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27880L, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27731 as string) AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, cast(EVALUATION_QUAL_37976_COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27760L as bigint) AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                                                                                                               +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27499 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27717, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27500 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27718, COL_1839416A_7E82_4851_9843_99CFBF41CD08#27501 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#27719, COL_30D07025_5684_4705_A04C_1C678E65ED32#27502 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#27720, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27503 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27721, COL_648D9173_ED6C_4044_8903_158C1196A3E2#27504 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#27722, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27505 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27723, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27506 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27724, COL_903F51D5_1E51_488D_9761_67785F7AF263#27507 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#27725, COL_07DE422A_6DBA_4611_A969_1471FD804B90#27508 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#27726, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27509 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27727, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27510 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27728, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27511 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27729, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27512 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27730, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27731, COL_898D946E_34EC_4196_88F6_338B6B38B05F#27514 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#27732, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27515 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27733, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27516 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27734, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27517 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27735, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27518 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27736, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27519 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27737, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27520 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27738, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27521 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27739, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27522 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27740, ... 37 more fields]
                                                                                                                  +- SubqueryAlias EVALUATION_QUAL_37976115
                                                                                                                     +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27499,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27500,COL_1839416A_7E82_4851_9843_99CFBF41CD08#27501,COL_30D07025_5684_4705_A04C_1C678E65ED32#27502,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27503,COL_648D9173_ED6C_4044_8903_158C1196A3E2#27504,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27505,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27506,COL_903F51D5_1E51_488D_9761_67785F7AF263#27507,COL_07DE422A_6DBA_4611_A969_1471FD804B90#27508,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27509,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27510,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27511,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27512,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513,COL_898D946E_34EC_4196_88F6_338B6B38B05F#27514,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27515,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27516,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27517,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27518,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27519,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27520,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27521,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27522,... 37 more fields] parquet

== Analyzed Logical Plan ==
COL_9980B029_8A00_4A2E_9348_EBFAB996E811: string, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E: string, COL_C7677B53_41ED_4612_9DA8_AC26770B1876: bigint, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5: string, COL_F347CA59_C1A7_4324_B43B_588C17452144: bigint, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52: string, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6: double, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29212 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29240, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29213 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29241, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29214L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29242L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29215 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29243, COL_F347CA59_C1A7_4324_B43B_588C17452144#29216L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29244L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29217 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29245, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29218 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29246, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29219L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29247L]
      +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29196 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29212, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29197 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29213, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29198L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29214L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29199 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29215, COL_F347CA59_C1A7_4324_B43B_588C17452144#29200L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29216L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29201 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29217, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29202 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29218, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29203L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29219L]
         +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29147 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29196, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29148 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29197, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29149L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29198L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29150 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29199, COL_F347CA59_C1A7_4324_B43B_588C17452144#29151L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29200L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29152 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29201, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29153 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29202, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29154L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29203L]
            +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29131 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29147, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29132 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29148, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29133L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29149L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29134 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29150, COL_F347CA59_C1A7_4324_B43B_588C17452144#29135L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29151L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29136 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29152, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29137 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29153, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29138L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29154L]
               +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29115 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29131, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29116 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29132, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29117L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29133L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29118 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29134, COL_F347CA59_C1A7_4324_B43B_588C17452144#29119L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29135L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29120 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29136, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29121 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29137, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29122L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29138L]
                  +- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29098 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29115, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29099 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29116, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29100L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29117L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29101 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29118, COL_F347CA59_C1A7_4324_B43B_588C17452144#29102L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29119L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29103 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29120, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29104 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29121, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29105L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29122L]
                     +- Project [cast(QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#29069 as string) AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29098, cast(QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29070 as string) AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29099, cast(QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29071L as bigint) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29100L, cast(QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#29072 as string) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29101, cast(QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29073L as bigint) AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29102L, cast(QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29074 as string) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29103, cast(QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29075 as double) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29104, cast(QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#29076L as bigint) AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29105L]
                        +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28950 AS QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#29069, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28951 AS QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29070, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28952L AS QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29071L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28953 AS QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#29072, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28954L AS QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29073L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28955 AS QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29074, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28956 AS QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29075, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28957L AS QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#29076L]
                           +- SubqueryAlias QUALITE_SYNTHES_38119115
                              +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28950, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28951, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28952L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#28953, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28954L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28955, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28922 AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28956, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28957L]
                                 +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#28922]
                                    +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_70424811_2DDC_469F_8639_7777D23A61D6#28767, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#28851]
                                       +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#28767]
                                          +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28750 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28759, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28752L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28760L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28753L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28761L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L]
                                             +- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28750, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28744L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28752L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28753L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L]
                                                +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#28744L]
                                                   +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#28658L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                      +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                         +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, Avant traitement qualité_NULL_1#28487, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                            +- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478[0] AS Après traitement qualité_NULL_1#28485, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28486L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478[1] AS Avant traitement qualité_NULL_1#28487, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#28488L]
                                                               +- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, 1 AS `NULL_1`#28349, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#28478, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#28484]
                                                                  +- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, 1 AS 1 AS `NULL_1`#28349, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L]
                                                                     +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( -  as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297]
                                                                        +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291]
                                                                           +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28202 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28285, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28203L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L]
                                                                              +- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28202, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28128L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28203L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L]
                                                                                 +- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123, col1#28118L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28128L]
                                                                                    +- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, col0#28117 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#28123, col1#28118L]
                                                                                       +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28115, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28116L, col0#28117, col1#28118L]
                                                                                          +- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28075L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28076L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28077L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28078L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28079L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28080L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28081L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28082L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28083L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28084L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28085L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28117, col1#28118L]
                                                                                             +- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28075L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28076L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28077L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28078L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28079L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28080L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28081L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28082L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28083L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28084L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28085L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28086L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28087L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28088L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28089L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28090L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28091L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28092L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28093L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L]
                                                                                                +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                   +- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                      +- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, 1 AS NULL_1#28010, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27924L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#27971L, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                                                                                                         +- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27862 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27863 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27864 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27865 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27866 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27867 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27868 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27869 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27870 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27871 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27872 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27873 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27874 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27875 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27876 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27877 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27878 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921, COL_013B4432_4745_457D_A136_EA9290A58319#27879 AS COL_013B4432_4745_457D_A136_EA9290A58319#27922, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27861 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27923, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27880L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27924L, COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                                                                                                            +- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27717 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#27861, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27756 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27862, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27759 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27863, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27762 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27864, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27758 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27865, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27763 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27866, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27746 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27867, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27747 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27868, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27745 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27869, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27743 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27870, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#27753 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27871, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27752 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27872, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27749 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27873, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27748 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27874, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27751 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27875, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#27750 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27876, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27754 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27877, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27755 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27878, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27744 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#27879, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#27761L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#27880L, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27731 as string) AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, cast(EVALUATION_QUAL_37976_COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27760L as bigint) AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                                                                                                               +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27499 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27717, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27500 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27718, COL_1839416A_7E82_4851_9843_99CFBF41CD08#27501 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#27719, COL_30D07025_5684_4705_A04C_1C678E65ED32#27502 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#27720, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27503 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27721, COL_648D9173_ED6C_4044_8903_158C1196A3E2#27504 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#27722, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27505 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27723, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27506 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27724, COL_903F51D5_1E51_488D_9761_67785F7AF263#27507 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#27725, COL_07DE422A_6DBA_4611_A969_1471FD804B90#27508 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#27726, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27509 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27727, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27510 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27728, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27511 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27729, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27512 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27730, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27731, COL_898D946E_34EC_4196_88F6_338B6B38B05F#27514 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#27732, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27515 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27733, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27516 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27734, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27517 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27735, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27518 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27736, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27519 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27737, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27520 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27738, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27521 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27739, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27522 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27740, ... 37 more fields]
                                                                                                                  +- SubqueryAlias EVALUATION_QUAL_37976115
                                                                                                                     +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27499,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27500,COL_1839416A_7E82_4851_9843_99CFBF41CD08#27501,COL_30D07025_5684_4705_A04C_1C678E65ED32#27502,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27503,COL_648D9173_ED6C_4044_8903_158C1196A3E2#27504,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27505,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27506,COL_903F51D5_1E51_488D_9761_67785F7AF263#27507,COL_07DE422A_6DBA_4611_A969_1471FD804B90#27508,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27509,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27510,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27511,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27512,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513,COL_898D946E_34EC_4196_88F6_338B6B38B05F#27514,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27515,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27516,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27517,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27518,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27519,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27520,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27521,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27522,... 37 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29240, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29241, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29242L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0), COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, 100.0)), 2)), col2, %)) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29243, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[0] AS COL_F347CA59_C1A7_4324_B43B_588C17452144#29244L, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[0], COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L)), col2, 100.0)), 2)), col2, %)), (?<![0-9])%, Pas de traitement) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29245, dec_operator(DIFFERENCE, struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0), COL_1AD867EF_74A9_4253_97E3_892B44C7C916, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)[0])) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29246, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29247L]
      +- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L]
         +- Project [col1#28118L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(col0#28117)), INIT)) THEN false ELSE Contains(str_remove_accent(upper(col0#28117)), INIT) END, Avant traitement qualité, Après traitement qualité) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, str_join(struct(col1, str_transform_case(str_replace_extend(col0#28117, [ (Init) - Vide ou Null_SUM, (Final) - Vide ou Null_SUM, (Init) - Vide ou null_SUM], [,,]), UPPER), col2, non renseigné),  - ) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297]
            +- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17], false, [col0#28117, col1#28118L]
               +- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L]
                  +- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L]
                     +- Project [COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27538 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905, COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27541 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906, COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27544 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907, COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27540 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908, COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27545 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909, COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27528 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910, COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27529 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911, COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27527 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912, COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27525 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913, COL_45927A2C_7B5E_46F0_B288_4E446278061F#27535 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914, COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27534 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915, COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27531 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916, COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27530 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917, COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27533 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918, COL_726D968C_42FA_4E31_BD79_225187FD2C06#27532 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919, COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27536 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920, COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27537 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921, COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27526 AS COL_013B4432_4745_457D_A136_EA9290A58319#27922, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513 AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27542L AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                        +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27499,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27500,COL_1839416A_7E82_4851_9843_99CFBF41CD08#27501,COL_30D07025_5684_4705_A04C_1C678E65ED32#27502,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27503,COL_648D9173_ED6C_4044_8903_158C1196A3E2#27504,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27505,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27506,COL_903F51D5_1E51_488D_9761_67785F7AF263#27507,COL_07DE422A_6DBA_4611_A969_1471FD804B90#27508,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27509,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27510,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27511,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27512,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513,COL_898D946E_34EC_4196_88F6_338B6B38B05F#27514,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27515,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27516,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27517,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27518,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27519,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27520,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27521,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27522,... 37 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], functions=[pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)], output=[COL_9980B029_8A00_4A2E_9348_EBFAB996E811#29240, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#29241, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#29242L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#29243, COL_F347CA59_C1A7_4324_B43B_588C17452144#29244L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#29245, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#29246, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#29247L])
      +- HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L], functions=[partial_pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L, Après traitement qualité, Avant traitement qualité, 0, 0)], output=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, Après traitement qualité#28481L, Avant traitement qualité#28482L])
         +- *(3) HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], functions=[sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L)], output=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#28337, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#28338, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#28339L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#28350L])
            +- *(3) HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291], functions=[partial_sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L)], output=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, sum#29443L])
               +- *(3) Project [col1#28118L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#28286L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#28204, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#28205L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(col0#28117)), INIT)) THEN false ELSE Contains(str_remove_accent(upper(col0#28117)), INIT) END, Avant traitement qualité, Après traitement qualité) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#28291, str_join(struct(col1, str_transform_case(str_replace_extend(col0#28117, [ (Init) - Vide ou Null_SUM, (Final) - Vide ou Null_SUM, (Init) - Vide ou null_SUM], [,,]), UPPER), col2, non renseigné),  - ) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#28297]
                  +- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L], false, [col0#28117, col1#28118L]
                     +- *(2) Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L]
                        +- *(2) HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], functions=[first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true), sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)), sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)), sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)), sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)), sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)), sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)), sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)), sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)), sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)), sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)), sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)), sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)), sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)), sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)), sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)), sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)), sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)), sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint))], output=[COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#27947, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#27973L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#27975L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#27977L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#27979L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#27981L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#27983L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#27985L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#27987L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#27989L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#27991L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#27993L, COL_9968307D_4589_4C17_884D_E5235BA04755#27995L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#27997L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#27999L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28001L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28003L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28005L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28007L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28009L])
                           +- CustomShuffleReader coalesced
                              +- ShuffleQueryStage 0
                                 +- Exchange hashpartitioning(COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, 200), true, [id=#4389]
                                    +- *(1) HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881], functions=[partial_first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L, true), partial_sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905 as bigint)), partial_sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910 as bigint)), partial_sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911 as bigint)), partial_sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912 as bigint)), partial_sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913 as bigint)), partial_sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914 as bigint)), partial_sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915 as bigint)), partial_sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916 as bigint)), partial_sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917 as bigint)), partial_sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918 as bigint)), partial_sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919 as bigint)), partial_sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920 as bigint)), partial_sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921 as bigint)), partial_sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#27922 as bigint)), partial_sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906 as bigint)), partial_sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907 as bigint)), partial_sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908 as bigint)), partial_sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909 as bigint))], output=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, first#29468L, valueSet#29469, sum#29470L, sum#29471L, sum#29472L, sum#29473L, sum#29474L, sum#29475L, sum#29476L, sum#29477L, sum#29478L, sum#29479L, sum#29480L, sum#29481L, sum#29482L, sum#29483L, sum#29484L, sum#29485L, sum#29486L, sum#29487L])
                                       +- *(1) Project [COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27538 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#27905, COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27541 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#27906, COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27544 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#27907, COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27540 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#27908, COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27545 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#27909, COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27528 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#27910, COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27529 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#27911, COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27527 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#27912, COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27525 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#27913, COL_45927A2C_7B5E_46F0_B288_4E446278061F#27535 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#27914, COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27534 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#27915, COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27531 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#27916, COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27530 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#27917, COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27533 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#27918, COL_726D968C_42FA_4E31_BD79_225187FD2C06#27532 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#27919, COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27536 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#27920, COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27537 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#27921, COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27526 AS COL_013B4432_4745_457D_A136_EA9290A58319#27922, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513 AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#27881, COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27542L AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#27882L]
                                          +- *(1) ColumnarToRow
                                             +- FileScan parquet [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27513,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#27525,COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#27526,COL_464A280A_485C_42DC_883D_1B8FCCF5258D#27527,COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#27528,COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#27529,COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#27530,COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#27531,COL_726D968C_42FA_4E31_BD79_225187FD2C06#27532,COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#27533,COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#27534,COL_45927A2C_7B5E_46F0_B288_4E446278061F#27535,COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#27536,COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#27537,COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#27538,COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#27540,COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#27541,COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#27542L,COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#27544,COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#27545] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EVALUATION_QUAL_37976], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_09DD6C48_8262_414D_9D00_17FFFC613E44:string,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2:i...