DC2 - Details for Query 103

Details for Query 103

Submitted Time: 2025/11/07 08:58:45
Duration: 0.4 s
Succeeded Jobs: 161 167 168 169

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))\n33 ms (1 ms, 2 ms, 4 ms (stage 242.0: task 635))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 17"]; } 5 [labelType="html" label="Generate number of output rows: 126"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n57 ms (2 ms, 3 ms, 13 ms (stage 240.0: task 631))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 1 ms (stage 242.0: task 633)) peak memory total (min, med, max (stageId: taskId)) 899.5 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 244.0: task 643)) number of output rows: 21 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 244.0: task 643))"]; } 8 [labelType="html" label=" CustomShuffleReader "]; 9 [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)) 3.1 KiB (104.0 B, 250.0 B, 390.0 B (stage 244.0: task 643)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 244.0: task 643)) remote bytes read: 0.0 B local blocks read: 14 remote blocks read: 0 data size: 3.7 KiB remote bytes read to disk: 0.0 B shuffle bytes written: 3.1 KiB"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n134 ms (38 ms, 96 ms, 96 ms (stage 229.0: task 623))"; 11 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 62 ms (4 ms, 58 ms, 58 ms (stage 229.0: task 623)) peak memory total (min, med, max (stageId: taskId)) 64.5 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 229.0: task 623)) number of output rows: 21 avg hash probe bucket list iters: 1"]; 12 [labelType="html" label=" Project "]; } 13 [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; 5->4; 7->5; 8->7; 9->8; 11->9; 12->11; 13->12; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319 AS COL_BA102F14_9089_4C81_87BE_910380380889#27474, str_extract_by_str(col0#27334, _, LEFT) AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27475, col1#27335 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27476, size(col1#27335, true) AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27477]

Filter NOT (size(col1#27335, true) <=> 0)

WholeStageCodegen (3)

Generate stack(6, Code postal_différence_SOURCE, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, SIRET_Différence_SOURCE, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, Mail_différence_SOURCE, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, téléphone_différence_SOURCE, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, Centrale_différence_SOURCE, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, CentraleCode_différence_SOURCE, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325), [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319], false, [col0#27334, col1#27335]

HashAggregate(keys=[COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274, 200), true, [id=#4190]

Project [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953 AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#26986 AS COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#26988 AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_0B2F2751_B02F_4102_A816_F8331A07385F#26990 AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#26992 AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#26994 AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_EC678074_436A_4798_97F2_6925F3E24131#26997 AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274]

WholeStageCodegen (1)

FileScan parquet [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953,COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#26986,COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#26988,COL_0B2F2751_B02F_4102_A816_F8331A07385F#26990,COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#26992,COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#26994,COL_EC678074_436A_4798_97F2_6925F3E24131#26997] Batched: false, 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_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5:a...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27466 AS COL_BA102F14_9089_4C81_87BE_910380380889#27474, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27467 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27475, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27468 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27476, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27469 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27477]
      +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27458 AS COL_BA102F14_9089_4C81_87BE_910380380889#27466, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27459 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27467, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27460 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27468, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27461 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27469]
         +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27450 AS COL_BA102F14_9089_4C81_87BE_910380380889#27458, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27451 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27459, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27452 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27460, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27453 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27461]
            +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27442 AS COL_BA102F14_9089_4C81_87BE_910380380889#27450, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27443 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27451, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27444 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27452, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27445 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27453]
               +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27434 AS COL_BA102F14_9089_4C81_87BE_910380380889#27442, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27435 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27443, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27436 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27444, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27437 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27445]
                  +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27426 AS COL_BA102F14_9089_4C81_87BE_910380380889#27434, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27427 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27435, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27428 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27436, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27429 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27437]
                     +- Project [cast(LISTE_DES_DIFFE_38221_COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27414 as string) AS COL_BA102F14_9089_4C81_87BE_910380380889#27426, cast(LISTE_DES_DIFFE_38221_COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27415 as string) AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27427, cast(LISTE_DES_DIFFE_38221_COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27416 as array<string>) AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27428, cast(LISTE_DES_DIFFE_38221_COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27417 as int) AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27429]
                        +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27403 AS LISTE_DES_DIFFE_38221_COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27414, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27404 AS LISTE_DES_DIFFE_38221_COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27415, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27405 AS LISTE_DES_DIFFE_38221_COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27416, COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364 AS LISTE_DES_DIFFE_38221_COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27417]
                           +- SubqueryAlias LISTE_DES_DIFFE_38221116
                              +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27403, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359 AS COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27404, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27405, COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364]
                                 +- Filter NOT (COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364 <=> cast(0 as int))
                                    +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359, size(COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, true) AS COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364]
                                       +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, str_extract_by_str(COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, cast(_ as string), cast(LEFT as string)) AS COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359]
                                          +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339 AS COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355]
                                             +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343]
                                                +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, col1#27335 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343]
                                                   +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, col0#27334 AS COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, col1#27335]
                                                      +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, col0#27334, col1#27335]
                                                         +- Generate stack(6, Code postal_différence_SOURCE, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, SIRET_Différence_SOURCE, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, Mail_différence_SOURCE, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, téléphone_différence_SOURCE, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, Centrale_différence_SOURCE, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, CentraleCode_différence_SOURCE, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325), false, [col0#27334, col1#27335]
                                                            +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282 AS COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283 AS COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284 AS COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285 AS COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286 AS COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287 AS COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288 AS COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325]
                                                               +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288]
                                                                  +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288]
                                                                     +- Aggregate [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268 AS COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_224A3191_A6FD_441D_9F36_10381046051D#27269 AS COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270 AS COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271 AS COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272 AS COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273 AS COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274 AS COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288, 1 AS NULL_1#27296]
                                                                        +- Project [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27254 AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27255 AS COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27256 AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27257 AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27258 AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27259 AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27260 AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274]
                                                                           +- Project [cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27139 as string) AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27254, cast(EVALUATION_QUAL_37976_COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#27172 as array<string>) AS COL_224A3191_A6FD_441D_9F36_10381046051D#27255, cast(EVALUATION_QUAL_37976_COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#27174 as array<string>) AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27256, cast(EVALUATION_QUAL_37976_COL_0B2F2751_B02F_4102_A816_F8331A07385F#27176 as array<string>) AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27257, cast(EVALUATION_QUAL_37976_COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#27178 as array<string>) AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27258, cast(EVALUATION_QUAL_37976_COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#27180 as array<string>) AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27259, cast(EVALUATION_QUAL_37976_COL_EC678074_436A_4798_97F2_6925F3E24131#27183 as array<string>) AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27260]
                                                                              +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26939 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27125, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26940 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27126, COL_1839416A_7E82_4851_9843_99CFBF41CD08#26941 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#27127, COL_30D07025_5684_4705_A04C_1C678E65ED32#26942 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#27128, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26943 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27129, COL_648D9173_ED6C_4044_8903_158C1196A3E2#26944 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#27130, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26945 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27131, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26946 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27132, COL_903F51D5_1E51_488D_9761_67785F7AF263#26947 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#27133, COL_07DE422A_6DBA_4611_A969_1471FD804B90#26948 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#27134, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26949 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27135, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26950 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27136, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26951 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27137, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26952 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27138, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27139, COL_898D946E_34EC_4196_88F6_338B6B38B05F#26954 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#27140, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26955 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27141, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26956 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27142, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26957 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27143, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26958 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27144, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26959 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27145, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26960 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27146, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26961 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27147, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26962 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27148, ... 37 more fields]
                                                                                 +- SubqueryAlias EVALUATION_QUAL_37976116
                                                                                    +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26939,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26940,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26941,COL_30D07025_5684_4705_A04C_1C678E65ED32#26942,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26943,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26944,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26945,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26946,COL_903F51D5_1E51_488D_9761_67785F7AF263#26947,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26948,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26949,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26950,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26951,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26952,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26954,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26955,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26956,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26957,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26958,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26959,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26960,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26961,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26962,... 37 more fields] parquet

== Analyzed Logical Plan ==
COL_BA102F14_9089_4C81_87BE_910380380889: string, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD: string, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B: array<string>, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4: int
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27466 AS COL_BA102F14_9089_4C81_87BE_910380380889#27474, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27467 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27475, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27468 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27476, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27469 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27477]
      +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27458 AS COL_BA102F14_9089_4C81_87BE_910380380889#27466, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27459 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27467, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27460 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27468, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27461 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27469]
         +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27450 AS COL_BA102F14_9089_4C81_87BE_910380380889#27458, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27451 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27459, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27452 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27460, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27453 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27461]
            +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27442 AS COL_BA102F14_9089_4C81_87BE_910380380889#27450, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27443 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27451, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27444 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27452, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27445 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27453]
               +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27434 AS COL_BA102F14_9089_4C81_87BE_910380380889#27442, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27435 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27443, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27436 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27444, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27437 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27445]
                  +- Project [COL_BA102F14_9089_4C81_87BE_910380380889#27426 AS COL_BA102F14_9089_4C81_87BE_910380380889#27434, COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27427 AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27435, COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27428 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27436, COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27429 AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27437]
                     +- Project [cast(LISTE_DES_DIFFE_38221_COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27414 as string) AS COL_BA102F14_9089_4C81_87BE_910380380889#27426, cast(LISTE_DES_DIFFE_38221_COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27415 as string) AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27427, cast(LISTE_DES_DIFFE_38221_COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27416 as array<string>) AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27428, cast(LISTE_DES_DIFFE_38221_COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27417 as int) AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27429]
                        +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27403 AS LISTE_DES_DIFFE_38221_COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27414, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27404 AS LISTE_DES_DIFFE_38221_COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27415, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27405 AS LISTE_DES_DIFFE_38221_COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27416, COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364 AS LISTE_DES_DIFFE_38221_COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27417]
                           +- SubqueryAlias LISTE_DES_DIFFE_38221116
                              +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27403, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359 AS COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27404, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27405, COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364]
                                 +- Filter NOT (COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364 <=> cast(0 as int))
                                    +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359, size(COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, true) AS COL_A77C6D22_2FC5_4093_B22C_90BBDEF62DBF#27364]
                                       +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355, str_extract_by_str(COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, cast(_ as string), cast(LEFT as string)) AS COL_E8AEBA04_8FAC_436E_91EB_F53BC2B755CE#27359]
                                          +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27353, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339 AS COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27354, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27355]
                                             +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343]
                                                +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, col1#27335 AS COL_DE61F66B_F3F4_4065_98ED_B535A8779A4E#27343]
                                                   +- Project [COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, col0#27334 AS COL_6B7011FA_EB84_4448_A62A_DC80179BAA23#27339, col1#27335]
                                                      +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319 AS COL_1EED3BB3_964B_4CE1_8ABF_855ABF2B5E42#27333, col0#27334, col1#27335]
                                                         +- Generate stack(6, Code postal_différence_SOURCE, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, SIRET_Différence_SOURCE, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, Mail_différence_SOURCE, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, téléphone_différence_SOURCE, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, Centrale_différence_SOURCE, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, CentraleCode_différence_SOURCE, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325), false, [col0#27334, col1#27335]
                                                            +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282 AS COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283 AS COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284 AS COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285 AS COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286 AS COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287 AS COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288 AS COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325]
                                                               +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288]
                                                                  +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288]
                                                                     +- Aggregate [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268 AS COL_D68969C9_9D84_4945_A226_64FA942ADF04#27282, COL_224A3191_A6FD_441D_9F36_10381046051D#27269 AS COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27283, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270 AS COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27284, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271 AS COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27285, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272 AS COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27286, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273 AS COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27287, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274 AS COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27288, 1 AS NULL_1#27296]
                                                                        +- Project [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27254 AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27255 AS COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27256 AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27257 AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27258 AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27259 AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27260 AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274]
                                                                           +- Project [cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27139 as string) AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27254, cast(EVALUATION_QUAL_37976_COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#27172 as array<string>) AS COL_224A3191_A6FD_441D_9F36_10381046051D#27255, cast(EVALUATION_QUAL_37976_COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#27174 as array<string>) AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27256, cast(EVALUATION_QUAL_37976_COL_0B2F2751_B02F_4102_A816_F8331A07385F#27176 as array<string>) AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27257, cast(EVALUATION_QUAL_37976_COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#27178 as array<string>) AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27258, cast(EVALUATION_QUAL_37976_COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#27180 as array<string>) AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27259, cast(EVALUATION_QUAL_37976_COL_EC678074_436A_4798_97F2_6925F3E24131#27183 as array<string>) AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27260]
                                                                              +- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26939 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#27125, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26940 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#27126, COL_1839416A_7E82_4851_9843_99CFBF41CD08#26941 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#27127, COL_30D07025_5684_4705_A04C_1C678E65ED32#26942 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#27128, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26943 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#27129, COL_648D9173_ED6C_4044_8903_158C1196A3E2#26944 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#27130, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26945 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#27131, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26946 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#27132, COL_903F51D5_1E51_488D_9761_67785F7AF263#26947 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#27133, COL_07DE422A_6DBA_4611_A969_1471FD804B90#26948 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#27134, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26949 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#27135, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26950 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#27136, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26951 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#27137, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26952 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#27138, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#27139, COL_898D946E_34EC_4196_88F6_338B6B38B05F#26954 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#27140, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26955 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#27141, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26956 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#27142, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26957 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#27143, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26958 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#27144, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26959 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#27145, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26960 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#27146, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26961 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#27147, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26962 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#27148, ... 37 more fields]
                                                                                 +- SubqueryAlias EVALUATION_QUAL_37976116
                                                                                    +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26939,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26940,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26941,COL_30D07025_5684_4705_A04C_1C678E65ED32#26942,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26943,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26944,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26945,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26946,COL_903F51D5_1E51_488D_9761_67785F7AF263#26947,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26948,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26949,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26950,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26951,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26952,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26954,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26955,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26956,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26957,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26958,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26959,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26960,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26961,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26962,... 37 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319 AS COL_BA102F14_9089_4C81_87BE_910380380889#27474, str_extract_by_str(col0#27334, _, LEFT) AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27475, col1#27335 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27476, size(col1#27335, true) AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27477]
      +- Filter NOT (size(col1#27335, true) <=> 0)
         +- Generate stack(6, Code postal_différence_SOURCE, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, SIRET_Différence_SOURCE, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, Mail_différence_SOURCE, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, téléphone_différence_SOURCE, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, Centrale_différence_SOURCE, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, CentraleCode_différence_SOURCE, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325), [1, 2, 3, 4, 5, 6], false, [col0#27334, col1#27335]
            +- Aggregate [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], [COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268 AS COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319, COL_224A3191_A6FD_441D_9F36_10381046051D#27269 AS COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270 AS COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271 AS COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272 AS COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273 AS COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274 AS COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325]
               +- Project [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953 AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#26986 AS COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#26988 AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_0B2F2751_B02F_4102_A816_F8331A07385F#26990 AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#26992 AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#26994 AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_EC678074_436A_4798_97F2_6925F3E24131#26997 AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274]
                  +- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#26939,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#26940,COL_1839416A_7E82_4851_9843_99CFBF41CD08#26941,COL_30D07025_5684_4705_A04C_1C678E65ED32#26942,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#26943,COL_648D9173_ED6C_4044_8903_158C1196A3E2#26944,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#26945,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#26946,COL_903F51D5_1E51_488D_9761_67785F7AF263#26947,COL_07DE422A_6DBA_4611_A969_1471FD804B90#26948,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#26949,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#26950,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#26951,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#26952,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953,COL_898D946E_34EC_4196_88F6_338B6B38B05F#26954,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#26955,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#26956,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#26957,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#26958,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#26959,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#26960,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#26961,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#26962,... 37 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(3) Project [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319 AS COL_BA102F14_9089_4C81_87BE_910380380889#27474, str_extract_by_str(col0#27334, _, LEFT) AS COL_4790CA6D_5EB8_4A4B_B9F4_0AAC779C91DD#27475, col1#27335 AS COL_116FD438_0E34_4EF4_96CC_E1B2B248028B#27476, size(col1#27335, true) AS COL_597C2C7B_E72B_48D9_BFE9_C689BE6E7AE4#27477]
      +- *(3) Filter NOT (size(col1#27335, true) <=> 0)
         +- Generate stack(6, Code postal_différence_SOURCE, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, SIRET_Différence_SOURCE, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, Mail_différence_SOURCE, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, téléphone_différence_SOURCE, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, Centrale_différence_SOURCE, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, CentraleCode_différence_SOURCE, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325), [COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319], false, [col0#27334, col1#27335]
            +- *(2) HashAggregate(keys=[COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], functions=[], output=[COL_D68969C9_9D84_4945_A226_64FA942ADF04#27319, COL_CC84D063_BB4F_4D2B_9F91_6DC7111BADA5#27320, COL_FDEF7363_55A4_47C4_936E_FE894DD5C658#27321, COL_7106C95A_0DCC_4EB8_9CC7_6A55309CAA16#27322, COL_16EF62D2_AC08_434D_AFD7_13A6D6CE46D3#27323, COL_0DA14CF4_1CB4_4198_A9C5_83A1F5D4EACF#27324, COL_A2F6E0D7_F74A_4F93_A9DD_0DDCCFB60BD6#27325])
               +- CustomShuffleReader coalesced
                  +- ShuffleQueryStage 0
                     +- Exchange hashpartitioning(COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274, 200), true, [id=#4190]
                        +- *(1) HashAggregate(keys=[COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274], functions=[], output=[COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274])
                           +- *(1) Project [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953 AS COL_431E843A_4FE2_4029_A9DA_28A6FC7AE71B#27268, COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#26986 AS COL_224A3191_A6FD_441D_9F36_10381046051D#27269, COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#26988 AS COL_3DF21BDC_58D1_4F3A_888B_C0B299B4CBB3#27270, COL_0B2F2751_B02F_4102_A816_F8331A07385F#26990 AS COL_B29FAC82_E7EB_4203_BDE4_F6E75C8D8902#27271, COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#26992 AS COL_CB9F4CBA_9A9B_4052_9017_E5E56A5430EB#27272, COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#26994 AS COL_0567E2DE_D66F_478C_AEDA_72EDE1FA195F#27273, COL_EC678074_436A_4798_97F2_6925F3E24131#26997 AS COL_E32422A1_29AD_4041_8DC5_994A0574ED69#27274]
                              +- FileScan parquet [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#26953,COL_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5#26986,COL_46186BFB_6059_4132_A13D_2AAEB05E9D8D#26988,COL_0B2F2751_B02F_4102_A816_F8331A07385F#26990,COL_643177E6_3B8E_4FC3_9F65_64FD68CF8BEF#26992,COL_2BC288C7_66BA_4B6A_A549_9ADCEB02FD7F#26994,COL_EC678074_436A_4798_97F2_6925F3E24131#26997] Batched: false, 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_DB9AE8A0_0B8E_4E38_9BC8_15FA6CFE90C5:a...