DC2 - Details for Query 117

Details for Query 117

Submitted Time: 2026/04/29 06:52:24
Duration: 4 s
Succeeded Jobs: 201 221

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n758 ms (28 ms, 54 ms, 96 ms (stage 349.0: task 1149))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 77 ms (1 ms, 6 ms, 11 ms (stage 349.0: task 1130)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 349.0: task 1130)) number of output rows: 35,389 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.1, 1.1 (stage 349.0: task 1130))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 35,389 shuffle write time total (min, med, max (stageId: taskId)) 378 ms (33 ms, 126 ms, 218 ms (stage 311.0: task 1012)) records read: 35,389 local bytes read total (min, med, max (stageId: taskId)) 2.9 MiB (70.9 KiB, 242.8 KiB, 246.8 KiB (stage 349.0: task 1143)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 349.0: task 1130)) remote bytes read: 0.0 B local blocks read: 39 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 5.9 MiB (296.0 KiB, 1313.7 KiB, 4.3 MiB (stage 311.0: task 1012)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 2.9 MiB (187.2 KiB, 689.0 KiB, 2.1 MiB (stage 311.0: task 1012))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n5.6 s (47 ms, 1.4 s, 3.4 s (stage 311.0: task 1012))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 5.3 s (2 ms, 1.3 s, 3.3 s (stage 311.0: task 1012)) peak memory total (min, med, max (stageId: taskId)) 193.8 MiB (256.0 KiB, 64.3 MiB, 65.0 MiB (stage 311.0: task 1012)) number of output rows: 35,389 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.3, 1.5 (stage 311.0: task 1012))"]; 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)) 85 ms (2 ms, 8 ms, 71 ms (stage 311.0: task 1012)) 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

TakeOrderedAndProject(limit=500000, orderBy=[COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 ASC NULLS FIRST], output=[COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973,COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974,COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975,COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976,COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977,COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978,COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979,COL_205D0339_FF71_43FE_8220_3F723D133178#27980])

HashAggregate(keys=[COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, 200), true, [id=#5487]

Project [COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736 AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724 AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741 AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734 AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_9978526E_040F_4765_A07A_494530767825#27737 AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723 AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722 AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733 AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736,COL_9978526E_040F_4765_A07A_494530767825#27737,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_D34C5A28_828A_40CE_8921_CE19A666620F:string,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28305 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28352, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28306 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28353, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28307 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28354, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28308 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28355, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28309 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28356, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28310 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28357, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28311 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28358, COL_205D0339_FF71_43FE_8220_3F723D133178#28312 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28359]
      +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28242 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28305, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28243 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28306, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28244 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28307, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28245 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28308, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28246 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28309, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28247 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28310, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28248 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28311, COL_205D0339_FF71_43FE_8220_3F723D133178#28249 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28312]
         +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28055 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28242, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28056 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28243, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28057 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28244, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28058 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28245, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28059 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28246, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28060 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28247, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28061 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28248, COL_205D0339_FF71_43FE_8220_3F723D133178#28062 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28249]
            +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28034 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28055, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28035 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28056, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28036 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28057, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28037 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28058, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28038 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28059, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28039 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28060, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28040 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28061, COL_205D0339_FF71_43FE_8220_3F723D133178#28041 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28062]
               +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28034, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28035, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28036, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28037, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28038, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28039, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28040, COL_205D0339_FF71_43FE_8220_3F723D133178#27980 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28041]
                  +- Sort [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 ASC NULLS FIRST], true
                     +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_205D0339_FF71_43FE_8220_3F723D133178#27980]
                        +- Aggregate [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949 AS COL_205D0339_FF71_43FE_8220_3F723D133178#27980, 1 AS NULL_1#27990]
                           +- Project [COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27913 AS COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27943, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27914 AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_71A2C956_308D_408B_AE28_F489FB949B94#27915 AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27916 AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27917 AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27918 AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27919 AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27920 AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27921 AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951]
                              +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27835 as string) AS COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27913, cast(GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27851 as int) AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27914, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27839 as string) AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27915, cast(GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27856 as string) AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27916, cast(GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27849 as string) AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27917, cast(GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27852 as string) AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27918, cast(GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27838 as string) AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27919, cast(GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27837 as string) AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27920, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27848 as string) AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27921]
                                 +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27720 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27835, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27721 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27836, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27837, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27838, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27839, COL_682B1361_587D_4660_AA5C_CF033B72E213#27725 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#27840, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27726 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27841, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27727 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27842, COL_B6226726_5203_4CE7_928C_112167B1E3F6#27728 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#27843, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27729 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27844, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27730 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27845, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27731 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27846, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27732 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27847, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27848, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27849, COL_5762487D_DE41_41F2_B7B8_34135953C74B#27735 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#27850, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27851, COL_9978526E_040F_4765_A07A_494530767825#27737 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27852, COL_37C9528B_3792_4759_A918_47801365FFEC#27738 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#27853, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27739 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27854, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27740 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27855, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27856, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27742 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27857]
                                    +- SubqueryAlias GOUPEMENTS_DE_C_21721118
                                       +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27720,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27721,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724,COL_682B1361_587D_4660_AA5C_CF033B72E213#27725,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27726,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27727,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27728,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27729,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27730,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27731,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27732,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27735,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736,COL_9978526E_040F_4765_A07A_494530767825#27737,COL_37C9528B_3792_4759_A918_47801365FFEC#27738,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27739,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27740,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27742] parquet

== Analyzed Logical Plan ==
COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F: string, COL_468C478B_D558_4E10_8D82_29479EBDAF3C: string, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3: string, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563: int, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E: string, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09: string, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65: string, COL_205D0339_FF71_43FE_8220_3F723D133178: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28305 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28352, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28306 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28353, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28307 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28354, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28308 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28355, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28309 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28356, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28310 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28357, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28311 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28358, COL_205D0339_FF71_43FE_8220_3F723D133178#28312 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28359]
      +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28242 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28305, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28243 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28306, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28244 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28307, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28245 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28308, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28246 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28309, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28247 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28310, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28248 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28311, COL_205D0339_FF71_43FE_8220_3F723D133178#28249 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28312]
         +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28055 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28242, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28056 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28243, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28057 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28244, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28058 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28245, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28059 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28246, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28060 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28247, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28061 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28248, COL_205D0339_FF71_43FE_8220_3F723D133178#28062 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28249]
            +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28034 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28055, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28035 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28056, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28036 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28057, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28037 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28058, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28038 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28059, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28039 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28060, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28040 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28061, COL_205D0339_FF71_43FE_8220_3F723D133178#28041 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28062]
               +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#28034, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#28035, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#28036, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#28037, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#28038, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#28039, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#28040, COL_205D0339_FF71_43FE_8220_3F723D133178#27980 AS COL_205D0339_FF71_43FE_8220_3F723D133178#28041]
                  +- Sort [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 ASC NULLS FIRST], true
                     +- Project [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_205D0339_FF71_43FE_8220_3F723D133178#27980]
                        +- Aggregate [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949 AS COL_205D0339_FF71_43FE_8220_3F723D133178#27980, 1 AS NULL_1#27990]
                           +- Project [COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27913 AS COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27943, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27914 AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_71A2C956_308D_408B_AE28_F489FB949B94#27915 AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27916 AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27917 AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27918 AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27919 AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27920 AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27921 AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951]
                              +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27835 as string) AS COL_5C3A1705_E97F_4014_81B0_9EF0C67087AC#27913, cast(GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27851 as int) AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27914, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27839 as string) AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27915, cast(GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27856 as string) AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27916, cast(GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27849 as string) AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27917, cast(GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27852 as string) AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27918, cast(GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27838 as string) AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27919, cast(GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27837 as string) AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27920, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27848 as string) AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27921]
                                 +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27720 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27835, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27721 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27836, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27837, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27838, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27839, COL_682B1361_587D_4660_AA5C_CF033B72E213#27725 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#27840, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27726 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27841, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27727 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27842, COL_B6226726_5203_4CE7_928C_112167B1E3F6#27728 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#27843, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27729 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27844, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27730 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27845, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27731 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27846, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27732 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27847, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27848, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27849, COL_5762487D_DE41_41F2_B7B8_34135953C74B#27735 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#27850, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27851, COL_9978526E_040F_4765_A07A_494530767825#27737 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27852, COL_37C9528B_3792_4759_A918_47801365FFEC#27738 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#27853, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27739 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27854, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27740 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27855, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27856, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27742 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27857]
                                    +- SubqueryAlias GOUPEMENTS_DE_C_21721118
                                       +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27720,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27721,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724,COL_682B1361_587D_4660_AA5C_CF033B72E213#27725,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27726,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27727,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27728,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27729,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27730,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27731,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27732,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27735,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736,COL_9978526E_040F_4765_A07A_494530767825#27737,COL_37C9528B_3792_4759_A918_47801365FFEC#27738,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27739,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27740,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27742] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 ASC NULLS FIRST], true
      +- Aggregate [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], [COL_71A2C956_308D_408B_AE28_F489FB949B94#27945 AS COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947 AS COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948 AS COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944 AS COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951 AS COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946 AS COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950 AS COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949 AS COL_205D0339_FF71_43FE_8220_3F723D133178#27980]
         +- Project [COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736 AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724 AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741 AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734 AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_9978526E_040F_4765_A07A_494530767825#27737 AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723 AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722 AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733 AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951]
            +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27720,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27721,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724,COL_682B1361_587D_4660_AA5C_CF033B72E213#27725,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27726,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27727,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27728,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27729,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27730,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27731,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27732,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27735,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736,COL_9978526E_040F_4765_A07A_494530767825#27737,COL_37C9528B_3792_4759_A918_47801365FFEC#27738,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27739,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27740,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27742] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973 ASC NULLS FIRST], output=[COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973,COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974,COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975,COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976,COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977,COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978,COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979,COL_205D0339_FF71_43FE_8220_3F723D133178#27980])
   +- *(2) HashAggregate(keys=[COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], functions=[], output=[COL_AD22F811_8FB7_42BC_91A9_AC1FD646255F#27973, COL_468C478B_D558_4E10_8D82_29479EBDAF3C#27974, COL_BE932145_E59B_4BDF_8687_7505C41B2EC3#27975, COL_187EECF3_A1A3_4B80_9C9E_BF36A1585563#27976, COL_D96ED962_E670_472C_B9E2_9ECCCFA2808E#27977, COL_5BC9BBC8_A5C2_4E74_9563_B8B21B05BB09#27978, COL_9F4C7F0F_E5BD_489C_85E7_70111A52EA65#27979, COL_205D0339_FF71_43FE_8220_3F723D133178#27980])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, 200), true, [id=#5487]
               +- *(1) HashAggregate(keys=[COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949], functions=[], output=[COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951, COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949])
                  +- *(1) Project [COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736 AS COL_69E52D8B_6574_4571_9371_E3AA48E8F2FD#27944, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724 AS COL_71A2C956_308D_408B_AE28_F489FB949B94#27945, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741 AS COL_83B0C07C_4B91_43A9_B141_5AA7DC1697FA#27946, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734 AS COL_7D5B2FF1_5F41_4978_90FD_DB3E5721857D#27947, COL_9978526E_040F_4765_A07A_494530767825#27737 AS COL_039986C5_86D0_47C6_AD4D_0F6F4BC26843#27948, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723 AS COL_3BE47B96_3C2C_496E_AEFF_6BDE38B46506#27949, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722 AS COL_FA55A11C_7967_4F78_BB8C_823971BE4FA4#27950, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733 AS COL_1E072B35_B62E_45AE_82C8_EA71F1F1ECFC#27951]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [COL_D34C5A28_828A_40CE_8921_CE19A666620F#27722,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27723,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27724,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27733,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27734,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27736,COL_9978526E_040F_4765_A07A_494530767825#27737,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27741] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_D34C5A28_828A_40CE_8921_CE19A666620F:string,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427:s...