DC2 - Details for Query 56

Details for Query 56

Submitted Time: 2026/03/05 07:13:49
Duration: 0.5 s
Succeeded Jobs: 95 100 102

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n7 ms (2 ms, 2 ms, 3 ms (stage 166.0: task 490))"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Generate number of output rows: 6"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n28 ms (3 ms, 3 ms, 22 ms (stage 166.0: task 490))"; 6 [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 169.0: task 492)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 169.0: task 493)) number of output rows: 1 avg hash probe bucket list iters: 1"]; } 7 [labelType="html" label=" CustomShuffleReader "]; 8 [labelType="html" label="Exchange shuffle records written: 1 shuffle write time: 3 ms records read: 1 local bytes read: 860.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 1 remote blocks read: 0 data size: 1104.0 B remote bytes read to disk: 0.0 B shuffle bytes written: 860.0 B"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n160 ms (34 ms, 126 ms, 126 ms (stage 155.0: task 472))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 93 ms (4 ms, 89 ms, 89 ms (stage 155.0: task 472)) peak memory total (min, med, max (stageId: taskId)) 64.5 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 155.0: task 472)) number of output rows: 1 avg hash probe bucket list iters: 1"]; 11 [labelType="html" label=" Project "]; } 12 [labelType="html" label="Scan parquet number of output rows: 5,424 number of files read: 2 metadata time: 0 ms size of files read: 582.8 KiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [str_extract_by_str(col0#10361, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10664, col1#10362 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10665]

WholeStageCodegen (3)

Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232), false, [col0#10361, col1#10362]

HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186, 200), true, [id=#2604]

Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#9789 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#9792 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#9781 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#9785 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#9783 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#9787 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186]

WholeStageCodegen (1)

FileScan parquet [COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#9781,COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#9783,COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#9785,COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#9787,COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#9789,COL_F5A0F811_EE02_420F_BA0B_D95579544D85#9792] Batched: false, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EVALUATION_QUAL_37976], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5:array<string>,COL_9166B3C7_5C3B_42DD_9A8A_54C20EC...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10640 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10664, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10641 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10665]
      +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10636 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10640, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10637 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10641]
         +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10630 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10636, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10631 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10637]
            +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10626 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10630, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10627 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10631]
               +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10622 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10626, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10623 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10627]
                  +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10617 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10622, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10618 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10623]
                     +- Project [cast(LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10552 as string) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10617, cast(LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10553 as array<string>) AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10618]
                        +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10463 AS LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10552, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10464 AS LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10553]
                           +- SubqueryAlias LISTE_DES_DIFFE_38174115
                              +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10438 AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10463, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10464]
                                 +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374, str_extract_by_str(COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, cast(_ as string), cast(LEFT as string)) AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10438]
                                    +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374]
                                       +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368]
                                          +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, col1#10362 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368]
                                             +- Project [col0#10361 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, col1#10362]
                                                +- Project [col0#10361, col1#10362]
                                                   +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232), false, [col0#10361, col1#10362]
                                                      +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232]
                                                         +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199]
                                                            +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199]
                                                               +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199, 1 AS NULL_1#10207]
                                                                  +- Filter true
                                                                     +- Project [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10167 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10168 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10169 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10170 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10171 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10172 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186, COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#10173]
                                                                        +- Project [cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10094 as array<string>) AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10167, cast(EVALUATION_QUAL_37976_COL_F5A0F811_EE02_420F_BA0B_D95579544D85#10097 as array<string>) AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10168, cast(EVALUATION_QUAL_37976_COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#10086 as array<string>) AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10169, cast(EVALUATION_QUAL_37976_COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#10090 as array<string>) AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10170, cast(EVALUATION_QUAL_37976_COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#10088 as array<string>) AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10171, cast(EVALUATION_QUAL_37976_COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#10092 as array<string>) AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10172, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10052 as string) AS COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#10173]
                                                                           +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9733 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10038, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9734 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10039, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9735 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10040, COL_30D07025_5684_4705_A04C_1C678E65ED32#9736 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10041, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9737 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10042, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9738 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10043, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9739 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10044, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9740 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10045, COL_903F51D5_1E51_488D_9761_67785F7AF263#9741 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10046, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9742 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10047, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9743 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10048, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9744 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10049, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9745 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10050, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9746 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10051, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9747 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10052, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9748 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10053, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9749 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10054, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9750 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10055, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9751 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10056, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9752 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10057, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9753 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10058, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9754 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10059, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9755 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10060, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9756 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10061, ... 37 more fields]
                                                                              +- SubqueryAlias EVALUATION_QUAL_37976115
                                                                                 +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9733,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9734,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9735,COL_30D07025_5684_4705_A04C_1C678E65ED32#9736,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9737,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9738,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9739,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9740,COL_903F51D5_1E51_488D_9761_67785F7AF263#9741,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9742,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9743,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9744,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9745,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9746,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9747,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9748,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9749,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9750,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9751,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9752,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9753,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9754,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9755,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9756,... 37 more fields] parquet

== Analyzed Logical Plan ==
COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC: string, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129: array<string>
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10640 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10664, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10641 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10665]
      +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10636 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10640, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10637 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10641]
         +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10630 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10636, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10631 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10637]
            +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10626 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10630, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10627 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10631]
               +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10622 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10626, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10623 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10627]
                  +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10617 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10622, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10618 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10623]
                     +- Project [cast(LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10552 as string) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10617, cast(LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10553 as array<string>) AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10618]
                        +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10463 AS LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10552, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10464 AS LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10553]
                           +- SubqueryAlias LISTE_DES_DIFFE_38174115
                              +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10438 AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10463, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10464]
                                 +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374, str_extract_by_str(COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, cast(_ as string), cast(LEFT as string)) AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#10438]
                                    +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10373, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10374]
                                       +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368]
                                          +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, col1#10362 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#10368]
                                             +- Project [col0#10361 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#10365, col1#10362]
                                                +- Project [col0#10361, col1#10362]
                                                   +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232), false, [col0#10361, col1#10362]
                                                      +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232]
                                                         +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199]
                                                            +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199]
                                                               +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10194, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10195, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10196, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#10197, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10198, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#10199, 1 AS NULL_1#10207]
                                                                  +- Filter true
                                                                     +- Project [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10167 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10168 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10169 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10170 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10171 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10172 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186, COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#10173]
                                                                        +- Project [cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10094 as array<string>) AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10167, cast(EVALUATION_QUAL_37976_COL_F5A0F811_EE02_420F_BA0B_D95579544D85#10097 as array<string>) AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10168, cast(EVALUATION_QUAL_37976_COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#10086 as array<string>) AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10169, cast(EVALUATION_QUAL_37976_COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#10090 as array<string>) AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10170, cast(EVALUATION_QUAL_37976_COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#10088 as array<string>) AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10171, cast(EVALUATION_QUAL_37976_COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#10092 as array<string>) AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10172, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10052 as string) AS COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#10173]
                                                                           +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9733 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10038, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9734 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10039, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9735 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10040, COL_30D07025_5684_4705_A04C_1C678E65ED32#9736 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10041, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9737 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10042, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9738 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10043, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9739 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10044, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9740 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10045, COL_903F51D5_1E51_488D_9761_67785F7AF263#9741 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10046, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9742 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10047, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9743 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10048, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9744 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10049, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9745 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10050, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9746 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10051, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9747 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10052, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9748 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10053, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9749 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10054, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9750 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10055, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9751 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10056, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9752 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10057, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9753 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10058, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9754 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10059, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9755 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10060, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9756 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10061, ... 37 more fields]
                                                                              +- SubqueryAlias EVALUATION_QUAL_37976115
                                                                                 +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9733,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9734,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9735,COL_30D07025_5684_4705_A04C_1C678E65ED32#9736,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9737,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9738,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9739,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9740,COL_903F51D5_1E51_488D_9761_67785F7AF263#9741,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9742,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9743,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9744,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9745,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9746,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9747,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9748,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9749,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9750,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9751,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9752,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9753,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9754,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9755,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9756,... 37 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [str_extract_by_str(col0#10361, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10664, col1#10362 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10665]
      +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232), [0, 1, 2, 3, 4, 5], false, [col0#10361, col1#10362]
         +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232]
            +- Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#9789 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#9792 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#9781 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#9785 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#9783 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#9787 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186]
               +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9733,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9734,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9735,COL_30D07025_5684_4705_A04C_1C678E65ED32#9736,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9737,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9738,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9739,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9740,COL_903F51D5_1E51_488D_9761_67785F7AF263#9741,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9742,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9743,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9744,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9745,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9746,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9747,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9748,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9749,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9750,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9751,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9752,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9753,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9754,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9755,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9756,... 37 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(3) Project [str_extract_by_str(col0#10361, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#10664, col1#10362 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#10665]
      +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232), false, [col0#10361, col1#10362]
         +- *(2) HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], functions=[], output=[COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#10227, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#10228, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#10229, COL_438FEE29_33EB_4F7E_852D_819696713A1E#10230, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#10231, COL_7D92FAE8_0D22_439F_9D60_338F72940683#10232])
            +- CustomShuffleReader coalesced
               +- ShuffleQueryStage 0
                  +- Exchange hashpartitioning(COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186, 200), true, [id=#2604]
                     +- *(1) HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186], functions=[], output=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186])
                        +- *(1) Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#9789 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#10181, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#9792 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#10182, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#9781 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#10183, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#9785 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#10184, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#9783 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#10185, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#9787 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#10186]
                           +- FileScan parquet [COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#9781,COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#9783,COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#9785,COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#9787,COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#9789,COL_F5A0F811_EE02_420F_BA0B_D95579544D85#9792] Batched: false, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EVALUATION_QUAL_37976], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5:array<string>,COL_9166B3C7_5C3B_42DD_9A8A_54C20EC...