DC2 - Details for Query 100

Details for Query 100

Submitted Time: 2025/11/07 08:58:45
Duration: 0.4 s
Succeeded Jobs: 157 164 165

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))\n8 ms (2 ms, 3 ms, 3 ms (stage 237.0: task 629))"; 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))\n17 ms (2 ms, 3 ms, 12 ms (stage 235.0: task 627))"; 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 237.0: task 628)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 237.0: task 629)) 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: 5 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))\n176 ms (36 ms, 140 ms, 140 ms (stage 222.0: task 598))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 100 ms (7 ms, 93 ms, 93 ms (stage 222.0: task 598)) peak memory total (min, med, max (stageId: taskId)) 64.5 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 222.0: task 598)) 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#26877, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26935, col1#26878 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26936]

WholeStageCodegen (3)

Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870), false, [col0#26877, col1#26878]

HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824, 200), true, [id=#4121]

Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26530 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26533 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26522 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26526 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26524 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26528 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824]

WholeStageCodegen (1)

FileScan parquet [COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26522,COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26524,COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26526,COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26528,COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26530,COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26533] 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#26931 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26935, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26932 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26936]
      +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26927 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26931, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26928 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26932]
         +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26921 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26927, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26922 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26928]
            +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26917 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26921, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26918 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26922]
               +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26913 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26917, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26914 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26918]
                  +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26909 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26913, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26910 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26914]
                     +- Project [cast(LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26903 as string) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26909, cast(LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26904 as array<string>) AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26910]
                        +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26897 AS LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26903, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26898 AS LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26904]
                           +- SubqueryAlias LISTE_DES_DIFFE_38174118
                              +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26893 AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26897, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26898]
                                 +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890, str_extract_by_str(COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, cast(_ as string), cast(LEFT as string)) AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26893]
                                    +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890]
                                       +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884]
                                          +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, col1#26878 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884]
                                             +- Project [col0#26877 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, col1#26878]
                                                +- Project [col0#26877, col1#26878]
                                                   +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870), false, [col0#26877, col1#26878]
                                                      +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870]
                                                         +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837]
                                                            +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837]
                                                               +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837, 1 AS NULL_1#26845]
                                                                  +- Filter true
                                                                     +- Project [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26805 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26806 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26807 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26808 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26809 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26810 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824, COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#26811]
                                                                        +- Project [cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26732 as array<string>) AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26805, cast(EVALUATION_QUAL_37976_COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26735 as array<string>) AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26806, cast(EVALUATION_QUAL_37976_COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26724 as array<string>) AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26807, cast(EVALUATION_QUAL_37976_COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26728 as array<string>) AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26808, cast(EVALUATION_QUAL_37976_COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26726 as array<string>) AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26809, cast(EVALUATION_QUAL_37976_COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26730 as array<string>) AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26810, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26690 as string) AS COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#26811]
                                                                           +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26473 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26676, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26474 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26677, COL_1839416A_7E82_4851_9843_99CFBF41CD08#26475 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#26678, COL_30D07025_5684_4705_A04C_1C678E65ED32#26476 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#26679, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26477 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26680, COL_648D9173_ED6C_4044_8903_158C1196A3E2#26478 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#26681, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26479 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26682, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26480 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26683, COL_903F51D5_1E51_488D_9761_67785F7AF263#26481 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#26684, COL_07DE422A_6DBA_4611_A969_1471FD804B90#26482 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#26685, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26483 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26686, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26484 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26687, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26485 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26688, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26486 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26689, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26487 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26690, COL_898D946E_34EC_4196_88F6_338B6B38B05F#26488 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#26691, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26489 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26692, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26490 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26693, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26491 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26694, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26492 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26695, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26493 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26696, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26494 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26697, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26495 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26698, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26496 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26699, ... 37 more fields]
                                                                              +- SubqueryAlias EVALUATION_QUAL_37976118
                                                                                 +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26473,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26474,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26475,COL_30D07025_5684_4705_A04C_1C678E65ED32#26476,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26477,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26478,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26479,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26480,COL_903F51D5_1E51_488D_9761_67785F7AF263#26481,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26482,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26483,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26484,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26485,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26486,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26487,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26488,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26489,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26490,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26491,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26492,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26493,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26494,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26495,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26496,... 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#26931 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26935, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26932 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26936]
      +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26927 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26931, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26928 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26932]
         +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26921 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26927, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26922 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26928]
            +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26917 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26921, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26918 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26922]
               +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26913 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26917, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26914 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26918]
                  +- Project [COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26909 AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26913, COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26910 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26914]
                     +- Project [cast(LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26903 as string) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26909, cast(LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26904 as array<string>) AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26910]
                        +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26897 AS LISTE_DES_DIFFE_38174_COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26903, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26898 AS LISTE_DES_DIFFE_38174_COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26904]
                           +- SubqueryAlias LISTE_DES_DIFFE_38174118
                              +- Project [COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26893 AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26897, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26898]
                                 +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890, str_extract_by_str(COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, cast(_ as string), cast(LEFT as string)) AS COL_B0479092_2AED_4545_8425_F1DA13D7B10D#26893]
                                    +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26889, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26890]
                                       +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884]
                                          +- Project [COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, col1#26878 AS COL_AA6737BD_34E8_43B4_9CA5_53E56DB75276#26884]
                                             +- Project [col0#26877 AS COL_CAD54FFC_6504_4DBA_AF21_F928392C9867#26881, col1#26878]
                                                +- Project [col0#26877, col1#26878]
                                                   +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870), false, [col0#26877, col1#26878]
                                                      +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870]
                                                         +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837]
                                                            +- Project [COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837]
                                                               +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26832, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26833, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26834, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#26835, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26836, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#26837, 1 AS NULL_1#26845]
                                                                  +- Filter true
                                                                     +- Project [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26805 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26806 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26807 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26808 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26809 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26810 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824, COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#26811]
                                                                        +- Project [cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26732 as array<string>) AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26805, cast(EVALUATION_QUAL_37976_COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26735 as array<string>) AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26806, cast(EVALUATION_QUAL_37976_COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26724 as array<string>) AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26807, cast(EVALUATION_QUAL_37976_COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26728 as array<string>) AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26808, cast(EVALUATION_QUAL_37976_COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26726 as array<string>) AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26809, cast(EVALUATION_QUAL_37976_COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26730 as array<string>) AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26810, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26690 as string) AS COL_E7DFEDFB_6AD7_4076_85F7_DA8199157A6F#26811]
                                                                           +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26473 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26676, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26474 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26677, COL_1839416A_7E82_4851_9843_99CFBF41CD08#26475 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#26678, COL_30D07025_5684_4705_A04C_1C678E65ED32#26476 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#26679, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26477 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26680, COL_648D9173_ED6C_4044_8903_158C1196A3E2#26478 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#26681, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26479 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26682, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26480 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26683, COL_903F51D5_1E51_488D_9761_67785F7AF263#26481 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#26684, COL_07DE422A_6DBA_4611_A969_1471FD804B90#26482 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#26685, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26483 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26686, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26484 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26687, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26485 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26688, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26486 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26689, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26487 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26690, COL_898D946E_34EC_4196_88F6_338B6B38B05F#26488 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#26691, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26489 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26692, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26490 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26693, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26491 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26694, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26492 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26695, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26493 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26696, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26494 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26697, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26495 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26698, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26496 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26699, ... 37 more fields]
                                                                              +- SubqueryAlias EVALUATION_QUAL_37976118
                                                                                 +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26473,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26474,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26475,COL_30D07025_5684_4705_A04C_1C678E65ED32#26476,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26477,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26478,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26479,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26480,COL_903F51D5_1E51_488D_9761_67785F7AF263#26481,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26482,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26483,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26484,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26485,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26486,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26487,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26488,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26489,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26490,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26491,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26492,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26493,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26494,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26495,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26496,... 37 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [str_extract_by_str(col0#26877, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26935, col1#26878 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26936]
      +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870), [0, 1, 2, 3, 4, 5], false, [col0#26877, col1#26878]
         +- Aggregate [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], [COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819 AS COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820 AS COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821 AS COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822 AS COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823 AS COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824 AS COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870]
            +- Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26530 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26533 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26522 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26526 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26524 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26528 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824]
               +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26473,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26474,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26475,COL_30D07025_5684_4705_A04C_1C678E65ED32#26476,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26477,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26478,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26479,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26480,COL_903F51D5_1E51_488D_9761_67785F7AF263#26481,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26482,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26483,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26484,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26485,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26486,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26487,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26488,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26489,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26490,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26491,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26492,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26493,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26494,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26495,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26496,... 37 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(3) Project [str_extract_by_str(col0#26877, _, LEFT) AS COL_70DA8422_D35D_41FF_AB1F_EEF50927AAAC#26935, col1#26878 AS COL_5508BFB7_F8F2_4175_B0E5_B9A9A91AD129#26936]
      +- Generate stack(6, Centrale_différence_GLOBAL, COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, CentraleCode_différence_GLOBAL, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, Code postal_différence_GLOBAL, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, Mail_différence_GLOBAL, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, SIRET_Différence_GLOBAL, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, téléphone_différence_GLOBAL, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870), false, [col0#26877, col1#26878]
         +- *(2) HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], functions=[], output=[COL_08BE7DE8_AD7A_4BC5_96D9_1C0F5D691566#26865, COL_2B21DDEE_60F8_428D_ACB8_3E0490C9BA0D#26866, COL_DC9BC6D5_3711_49B9_8016_8DD93F8800CA#26867, COL_438FEE29_33EB_4F7E_852D_819696713A1E#26868, COL_52AE1ED7_DF53_40C1_8E3B_36048DD1BD24#26869, COL_7D92FAE8_0D22_439F_9D60_338F72940683#26870])
            +- CustomShuffleReader coalesced
               +- ShuffleQueryStage 0
                  +- Exchange hashpartitioning(COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824, 200), true, [id=#4121]
                     +- *(1) HashAggregate(keys=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824], functions=[], output=[COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824])
                        +- *(1) Project [COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26530 AS COL_AA436480_759D_45DD_88A1_D37D3C211A6F#26819, COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26533 AS COL_272C1345_0298_4360_800C_017E28EBA4D4#26820, COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26522 AS COL_F61FB7D7_A6C9_4E62_B010_ECCF4AA029D3#26821, COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26526 AS COL_D8D523FA_7C2A_40E6_A2E9_C47D39D20B0E#26822, COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26524 AS COL_56844C82_D25D_4588_9EF4_8BB040B045D6#26823, COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26528 AS COL_1A53D1DE_C12C_42A7_8EEC_584FBB702E97#26824]
                           +- FileScan parquet [COL_3A29E2C4_9238_4543_9392_D12F0CDE9AD5#26522,COL_9166B3C7_5C3B_42DD_9A8A_54C20ECFD032#26524,COL_FD9D7440_E7B2_4E0A_AA95_D6BAAB305E26#26526,COL_7A58A5D6_C58B_4EA0_83D1_E4538CCB16C2#26528,COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#26530,COL_F5A0F811_EE02_420F_BA0B_D95579544D85#26533] 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...