DC2 - Details for Query 126

Details for Query 126

Submitted Time: 2026/04/29 06:52:25
Duration: 3 s
Succeeded Jobs: 212 228 229 230

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 (2)\n \nduration: total (min, med, max (stageId: taskId))\n36 ms (1 ms, 2 ms, 7 ms (stage 366.0: task 1214))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 5 ms (0 ms, 0 ms, 4 ms (stage 364.0: task 1211)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 366.0: task 1215)) number of output rows: 525 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 366.0: task 1215))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 525 shuffle write time total (min, med, max (stageId: taskId)) 314 ms (22 ms, 23 ms, 268 ms (stage 329.0: task 1068)) records read: 525 local bytes read total (min, med, max (stageId: taskId)) 86.6 KiB (4.8 KiB, 6.8 KiB, 7.1 KiB (stage 366.0: task 1215)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 366.0: task 1215)) remote bytes read: 0.0 B local blocks read: 39 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 89.2 KiB (17.8 KiB, 17.8 KiB, 53.5 KiB (stage 329.0: task 1068)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 86.6 KiB (18.6 KiB, 19.2 KiB, 48.8 KiB (stage 329.0: task 1068))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.0 s (32 ms, 841 ms, 2.8 s (stage 329.0: task 1066))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 3.9 s (1 ms, 792 ms, 2.8 s (stage 329.0: task 1066)) peak memory total (min, med, max (stageId: taskId)) 193.0 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 329.0: task 1068)) number of output rows: 525 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 329.0: task 1068))"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="ColumnarToRow number of output rows: 4,081,140 number of input batches: 999"]; } 10 [labelType="html" label="Scan parquet number of files read: 4 scan time total (min, med, max (stageId: taskId)) 74 ms (1 ms, 9 ms, 61 ms (stage 329.0: task 1066)) metadata time: 0 ms size of files read: 2.8 MiB number of output rows: 4,081,140"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], functions=[sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint))])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239, 200), true, [id=#6010]

HashAggregate(keys=[COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], functions=[partial_sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint))])

Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101 AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110 AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113 AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236, COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109 AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111 AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105 AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105,COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF:string,COL_12F7A423_7020_42EE_AA20_1968D13CA12B:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29330 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29346, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29331 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29347, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29332 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29348, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29333 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29349, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29335L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29350L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29336 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29351, COL_E9180009_6167_42DE_8E0E_A65E92428945#29334 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29352, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29337 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29353]
      +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29314 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29330, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29315 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29331, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29316 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29332, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29317 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29333, COL_E9180009_6167_42DE_8E0E_A65E92428945#29318 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29334, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29319L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29335L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29320 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29336, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29321 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29337]
         +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29314, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29315, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29316, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29317, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29318, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29319L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29320, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29305 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29321]
            +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297, str_extract(str_join(struct(COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA, COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_57B4075D_935A_405F_909C_E95C9AB00BC0, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287), cast(- as string)), cast(LEFT as string), cast(35 as bigint)) AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29305]
               +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L, str_extract(str_join(struct(COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288), cast(- as string)), cast(LEFT as string), cast(35 as bigint)) AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297]
                  +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29273 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29274 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29275 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29276 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29277 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29278L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L]
                     +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29273, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29274, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29275, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29276, COL_E9180009_6167_42DE_8E0E_A65E92428945#29250 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29277, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29278L]
                        +- Sort true
                           +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L]
                              +- Aggregate [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, 1 AS NULL_1#29259, sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint)) AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L]
                                 +- Project [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29222 AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29223 AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29224 AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29225 AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29226 AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29227 AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239]
                                    +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29170 as string) AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29222, cast(GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29179 as string) AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29223, cast(GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29182 as int) AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29224, cast(GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#29178 as string) AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29225, cast(GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29180 as string) AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29226, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29174 as string) AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29227]
                                       +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29170, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29102 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29171, COL_D34C5A28_828A_40CE_8921_CE19A666620F#29103 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#29172, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29104 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29173, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29174, COL_682B1361_587D_4660_AA5C_CF033B72E213#29106 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#29175, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29107 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29176, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29108 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29177, COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#29178, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29179, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29180, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29112 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29181, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29182, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29114 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29183, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29115 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29184, COL_5762487D_DE41_41F2_B7B8_34135953C74B#29116 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#29185, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29117 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29186, COL_9978526E_040F_4765_A07A_494530767825#29118 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#29187, COL_37C9528B_3792_4759_A918_47801365FFEC#29119 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#29188, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29120 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29189, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29121 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29190, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29122 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29191, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29123 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29192]
                                          +- SubqueryAlias GOUPEMENTS_DE_C_21721117
                                             +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29102,COL_D34C5A28_828A_40CE_8921_CE19A666620F#29103,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29104,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105,COL_682B1361_587D_4660_AA5C_CF033B72E213#29106,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29107,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29108,COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29112,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29114,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29115,COL_5762487D_DE41_41F2_B7B8_34135953C74B#29116,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29117,COL_9978526E_040F_4765_A07A_494530767825#29118,COL_37C9528B_3792_4759_A918_47801365FFEC#29119,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29120,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29121,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29122,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29123] parquet

== Analyzed Logical Plan ==
COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA: string, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF: string, COL_57B4075D_935A_405F_909C_E95C9AB00BC0: string, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF: string, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14: bigint, COL_697B73A8_9BB5_4862_92E3_D7213638760F: string, COL_E9180009_6167_42DE_8E0E_A65E92428945: string, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29330 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29346, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29331 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29347, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29332 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29348, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29333 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29349, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29335L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29350L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29336 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29351, COL_E9180009_6167_42DE_8E0E_A65E92428945#29334 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29352, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29337 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29353]
      +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29314 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29330, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29315 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29331, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29316 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29332, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29317 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29333, COL_E9180009_6167_42DE_8E0E_A65E92428945#29318 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29334, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29319L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29335L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29320 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29336, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29321 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29337]
         +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29314, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29315, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29316, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29317, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29318, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29319L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297 AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29320, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29305 AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29321]
            +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297, str_extract(str_join(struct(COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA, COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_57B4075D_935A_405F_909C_E95C9AB00BC0, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287), cast(- as string)), cast(LEFT as string), cast(35 as bigint)) AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29305]
               +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L, str_extract(str_join(struct(COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288), cast(- as string)), cast(LEFT as string), cast(35 as bigint)) AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29297]
                  +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29273 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29285, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29274 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29286, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29275 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29287, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29276 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29288, COL_E9180009_6167_42DE_8E0E_A65E92428945#29277 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29289, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29278L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29290L]
                     +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29273, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29274, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29275, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29276, COL_E9180009_6167_42DE_8E0E_A65E92428945#29250 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29277, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29278L]
                        +- Sort true
                           +- Project [COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L]
                              +- Aggregate [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, 1 AS NULL_1#29259, sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint)) AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L]
                                 +- Project [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29222 AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29223 AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29224 AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29225 AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29226 AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29227 AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239]
                                    +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29170 as string) AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29222, cast(GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29179 as string) AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29223, cast(GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29182 as int) AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29224, cast(GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#29178 as string) AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29225, cast(GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29180 as string) AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29226, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29174 as string) AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29227]
                                       +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29170, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29102 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29171, COL_D34C5A28_828A_40CE_8921_CE19A666620F#29103 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#29172, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29104 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29173, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29174, COL_682B1361_587D_4660_AA5C_CF033B72E213#29106 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#29175, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29107 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29176, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29108 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29177, COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#29178, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29179, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29180, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29112 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29181, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29182, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29114 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29183, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29115 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29184, COL_5762487D_DE41_41F2_B7B8_34135953C74B#29116 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#29185, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29117 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29186, COL_9978526E_040F_4765_A07A_494530767825#29118 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#29187, COL_37C9528B_3792_4759_A918_47801365FFEC#29119 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#29188, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29120 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29189, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29121 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29190, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29122 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29191, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29123 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29192]
                                          +- SubqueryAlias GOUPEMENTS_DE_C_21721117
                                             +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29102,COL_D34C5A28_828A_40CE_8921_CE19A666620F#29103,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29104,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105,COL_682B1361_587D_4660_AA5C_CF033B72E213#29106,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29107,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29108,COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29112,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29114,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29115,COL_5762487D_DE41_41F2_B7B8_34135953C74B#29116,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29117,COL_9978526E_040F_4765_A07A_494530767825#29118,COL_37C9528B_3792_4759_A918_47801365FFEC#29119,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29120,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29121,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29122,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29123] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], [COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234 AS COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235 AS COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237 AS COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238 AS COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint)) AS COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L, str_extract(str_join(struct(COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238), -), LEFT, 35) AS COL_697B73A8_9BB5_4862_92E3_D7213638760F#29351, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239 AS COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, str_extract(str_join(struct(COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA, COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_57B4075D_935A_405F_909C_E95C9AB00BC0, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237), -), LEFT, 35) AS COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29353]
      +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101 AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110 AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113 AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236, COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109 AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111 AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105 AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239]
         +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#29102,COL_D34C5A28_828A_40CE_8921_CE19A666620F#29103,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#29104,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105,COL_682B1361_587D_4660_AA5C_CF033B72E213#29106,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#29107,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#29108,COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#29112,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#29114,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#29115,COL_5762487D_DE41_41F2_B7B8_34135953C74B#29116,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#29117,COL_9978526E_040F_4765_A07A_494530767825#29118,COL_37C9528B_3792_4759_A918_47801365FFEC#29119,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#29120,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#29121,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#29122,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#29123] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(2) HashAggregate(keys=[COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], functions=[sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint))], output=[COL_A266D217_5ACC_4E7F_AC45_0B43C7B123AA#29246, COL_A5F8A674_4077_4566_BEB8_38F1F0F1F1FF#29247, COL_57B4075D_935A_405F_909C_E95C9AB00BC0#29248, COL_0D1E5EA8_EBDE_4C41_B956_3B75D5C81ABF#29249, COL_170B43F6_1E0B_4B45_8830_5E50FA8E7A14#29258L, COL_697B73A8_9BB5_4862_92E3_D7213638760F#29351, COL_E9180009_6167_42DE_8E0E_A65E92428945#29250, COL_72F27EB4_1D2F_40F7_BE04_FAF43140886B#29353])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239, 200), true, [id=#6010]
               +- *(1) HashAggregate(keys=[COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239], functions=[partial_sum(cast(COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236 as bigint))], output=[COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239, sum#29363L])
                  +- *(1) Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101 AS COL_3B8F3957_4BA8_42FB_812D_16623934B768#29234, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110 AS COL_D5846A9B_AF2B_4EA7_8259_2A052F017EB1#29235, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113 AS COL_E3C56653_404F_4D29_ABC6_36C7A6C175E9#29236, COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109 AS COL_C7B0FB7D_931F_42D9_BF13_8A70E1DF94DD#29237, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111 AS COL_06F9C7CB_2E65_45A9_ACF4_3434B79AC6E5#29238, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105 AS COL_30FC0642_9472_48A9_8945_28B0480E55B1#29239]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#29101,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#29105,COL_B6226726_5203_4CE7_928C_112167B1E3F6#29109,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#29110,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#29111,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#29113] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF:string,COL_12F7A423_7020_42EE_AA20_1968D13CA12B:s...