DC2 - Details for Query 119

Details for Query 119

Submitted Time: 2026/04/29 06:52:24
Duration: 5 s
Succeeded Jobs: 203 219 227 231

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 (4)\n \nduration: total (min, med, max (stageId: taskId))\n157 ms (4 ms, 16 ms, 40 ms (stage 370.0: task 1229))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 3 ms (stage 370.0: task 1225)) peak memory total (min, med, max (stageId: taskId)) 322.3 MiB (256.0 KiB, 64.3 MiB, 64.3 MiB (stage 370.0: task 1226)) number of output rows: 5 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 370.0: task 1226))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 45 shuffle write time total (min, med, max (stageId: taskId)) 214 ms (3 ms, 16 ms, 35 ms (stage 360.0: task 1195)) records read: 45 local bytes read total (min, med, max (stageId: taskId)) 5.3 KiB (117.0 B, 1272.0 B, 1746.0 B (stage 370.0: task 1226)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 370.0: task 1226)) remote bytes read: 0.0 B local blocks read: 45 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 3.7 KiB (184.0 B, 336.0 B, 336.0 B (stage 360.0: task 1205)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 5.3 KiB (260.0 B, 480.0 B, 484.0 B (stage 360.0: task 1198))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n905 ms (16 ms, 80 ms, 108 ms (stage 360.0: task 1198))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 98 ms (3 ms, 5 ms, 19 ms (stage 360.0: task 1198)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 360.0: task 1205)) number of output rows: 45 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 48 ms (1 ms, 3 ms, 10 ms (stage 360.0: task 1197)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 360.0: task 1205)) number of output rows: 1,245 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 360.0: task 1205))"]; } 9 [labelType="html" label=" CustomShuffleReader "]; 10 [labelType="html" label="Exchange shuffle records written: 12,825 shuffle write time total (min, med, max (stageId: taskId)) 4.2 s (229 ms, 313 ms, 428 ms (stage 343.0: task 1127)) records read: 12,825 local bytes read total (min, med, max (stageId: taskId)) 539.3 KiB (16.0 KiB, 43.7 KiB, 45.0 KiB (stage 360.0: task 1199)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 360.0: task 1205)) remote bytes read: 0.0 B local blocks read: 169 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1115.8 KiB (57.8 KiB, 87.7 KiB, 90.5 KiB (stage 343.0: task 1119)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 539.3 KiB (34.2 KiB, 42.1 KiB, 42.4 KiB (stage 343.0: task 1124))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n692 ms (38 ms, 49 ms, 86 ms (stage 343.0: task 1112))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 100 ms (5 ms, 8 ms, 12 ms (stage 343.0: task 1112)) peak memory total (min, med, max (stageId: taskId)) 195.3 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 343.0: task 1122)) number of output rows: 12,825 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 343.0: task 1122))"]; 13 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 47 ms (1 ms, 3 ms, 6 ms (stage 343.0: task 1125)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 343.0: task 1112)) number of output rows: 36,206 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.1, 1.1 (stage 343.0: task 1112))"]; } 14 [labelType="html" label=" CustomShuffleReader "]; 15 [labelType="html" label="Exchange shuffle records written: 36,206 shuffle write time total (min, med, max (stageId: taskId)) 611 ms (35 ms, 250 ms, 325 ms (stage 314.0: task 1024)) records read: 36,206 local bytes read total (min, med, max (stageId: taskId)) 754.0 KiB (22.6 KiB, 60.6 KiB, 63.0 KiB (stage 343.0: task 1119)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 343.0: task 1112)) remote bytes read: 0.0 B local blocks read: 39 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 3.9 MiB (161.7 KiB, 908.6 KiB, 2.9 MiB (stage 314.0: task 1024)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 754.0 KiB (68.7 KiB, 169.4 KiB, 515.9 KiB (stage 314.0: task 1024))"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.5 s (4 ms, 1.1 s, 2.9 s (stage 314.0: task 1024))"; 17 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 4.2 s (1 ms, 1.0 s, 2.7 s (stage 314.0: task 1024)) peak memory total (min, med, max (stageId: taskId)) 193.8 MiB (256.0 KiB, 64.3 MiB, 65.0 MiB (stage 314.0: task 1024)) number of output rows: 36,206 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.4, 1.5 (stage 314.0: task 1024))"]; 18 [labelType="html" label="Expand number of output rows: 8,162,280"]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="ColumnarToRow number of output rows: 4,081,140 number of input batches: 999"]; } 21 [labelType="html" label="Scan parquet number of files read: 4 scan time total (min, med, max (stageId: taskId)) 66 ms (1 ms, 19 ms, 34 ms (stage 314.0: task 1025)) 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; 12->10; 13->12; 14->13; 15->14; 17->15; 18->17; 19->18; 20->19; 21->20; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 ASC NULLS FIRST], output=[COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175,COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176,COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L,COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L,COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L])

HashAggregate(keys=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998], functions=[sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 as bigint)), sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L), sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L)])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, 200), true, [id=#6417]

HashAggregate(keys=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998], functions=[partial_sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 as bigint)), partial_sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L), partial_sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L)])

HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], functions=[count(if ((gid#28647 = 1)) `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648 else null), count(if ((gid#28647 = 2)) `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649 else null)])

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, 200), true, [id=#6274]

HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], functions=[partial_count(if ((gid#28647 = 1)) `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648 else null), partial_count(if ((gid#28647 = 2)) `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649 else null)])

HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647, 200), true, [id=#5643]

HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647], functions=[])

Expand [ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, null, 1), ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, null, COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, 2)], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647]

Project [COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681 AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678 AS COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676 AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687 AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680 AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687] 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_12F7A423_7020_42EE_AA20_1968D13CA12B:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28486 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28523, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28487 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28524, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28488L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28525L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28489L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28526L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28490L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28527L]
      +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28431 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28486, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28432 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28487, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28433L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28488L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28434L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28489L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28435L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28490L]
         +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28431, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28432, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28433L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28434L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28435L]
            +- Sort [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 ASC NULLS FIRST], true
               +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L]
                  +- Aggregate [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166], [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, 1 AS NULL_1#28250, sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28167 as bigint)) AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28168L) AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28169L) AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L]
                     +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28063 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28064 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28065 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28167, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28066L AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28168L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28067L AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28169L]
                        +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28063, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28064, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28065, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28066L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28067L]
                           +- Sort true
                              +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L]
                                 +- Aggregate [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, 1 AS NULL_1#28008, count(distinct COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961) AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, count(distinct COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962) AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L]
                                    +- Project [COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27928 AS COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27958, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27929 AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_759AE067_7FD0_46AA_913E_679093372F23#27930 AS COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27931 AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27932 AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27933 AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963]
                                       +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27789 as string) AS COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27928, cast(GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27796 as string) AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27929, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27793 as string) AS COL_759AE067_7FD0_46AA_913E_679093372F23#27930, cast(GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27791 as string) AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27931, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27802 as string) AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27932, cast(GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27795 as int) AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27933]
                                          +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27674 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27789, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27675 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27790, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27791, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27677 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27792, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27793, COL_682B1361_587D_4660_AA5C_CF033B72E213#27679 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#27794, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27795, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27796, COL_B6226726_5203_4CE7_928C_112167B1E3F6#27682 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#27797, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27683 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27798, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27684 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27799, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27685 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27800, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27686 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27801, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27802, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27688 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27803, COL_5762487D_DE41_41F2_B7B8_34135953C74B#27689 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#27804, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27690 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27805, COL_9978526E_040F_4765_A07A_494530767825#27691 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27806, COL_37C9528B_3792_4759_A918_47801365FFEC#27692 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#27807, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27693 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27808, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27694 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27809, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27695 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27810, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27696 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27811]
                                             +- SubqueryAlias GOUPEMENTS_DE_C_21721115
                                                +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27674,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27675,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27677,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678,COL_682B1361_587D_4660_AA5C_CF033B72E213#27679,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27682,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27683,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27684,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27685,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27686,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27688,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27689,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27690,COL_9978526E_040F_4765_A07A_494530767825#27691,COL_37C9528B_3792_4759_A918_47801365FFEC#27692,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27693,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27694,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27695,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27696] parquet

== Analyzed Logical Plan ==
COL_40DD42CA_4C54_45B4_A977_83EE87083E3F: string, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B: string, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6: bigint, COL_46799400_7ECD_4B11_86E3_D3CE134385C3: bigint, COL_F151F138_B5ED_41D3_9665_3B45654246CB: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28486 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28523, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28487 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28524, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28488L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28525L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28489L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28526L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28490L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28527L]
      +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28431 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28486, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28432 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28487, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28433L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28488L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28434L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28489L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28435L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28490L]
         +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28431, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28432, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28433L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28434L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28435L]
            +- Sort [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 ASC NULLS FIRST], true
               +- Project [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L]
                  +- Aggregate [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166], [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, 1 AS NULL_1#28250, sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28167 as bigint)) AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28168L) AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28169L) AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L]
                     +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28063 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28165, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28064 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28166, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28065 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28167, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28066L AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28168L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28067L AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28169L]
                        +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#28063, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#28064, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#28065, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28066L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28067L]
                           +- Sort true
                              +- Project [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L]
                                 +- Aggregate [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, 1 AS NULL_1#28008, count(distinct COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961) AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, count(distinct COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962) AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L]
                                    +- Project [COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27928 AS COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27958, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27929 AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_759AE067_7FD0_46AA_913E_679093372F23#27930 AS COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27931 AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27932 AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27933 AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963]
                                       +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27789 as string) AS COL_EE167149_D4E6_4A4B_915B_ADB25CFC3D47#27928, cast(GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27796 as string) AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27929, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27793 as string) AS COL_759AE067_7FD0_46AA_913E_679093372F23#27930, cast(GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27791 as string) AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27931, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27802 as string) AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27932, cast(GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27795 as int) AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27933]
                                          +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27674 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27789, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27675 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27790, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#27791, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27677 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27792, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27793, COL_682B1361_587D_4660_AA5C_CF033B72E213#27679 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#27794, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27795, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27796, COL_B6226726_5203_4CE7_928C_112167B1E3F6#27682 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#27797, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27683 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27798, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27684 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27799, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27685 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27800, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27686 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27801, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27802, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27688 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27803, COL_5762487D_DE41_41F2_B7B8_34135953C74B#27689 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#27804, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27690 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27805, COL_9978526E_040F_4765_A07A_494530767825#27691 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#27806, COL_37C9528B_3792_4759_A918_47801365FFEC#27692 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#27807, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27693 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27808, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27694 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27809, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27695 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27810, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27696 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27811]
                                             +- SubqueryAlias GOUPEMENTS_DE_C_21721115
                                                +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27674,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27675,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27677,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678,COL_682B1361_587D_4660_AA5C_CF033B72E213#27679,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27682,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27683,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27684,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27685,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27686,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27688,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27689,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27690,COL_9978526E_040F_4765_A07A_494530767825#27691,COL_37C9528B_3792_4759_A918_47801365FFEC#27692,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27693,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27694,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27695,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27696] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 ASC NULLS FIRST], true
      +- Aggregate [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998], [COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997 AS COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998 AS COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 as bigint)) AS COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L) AS COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L) AS COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L]
         +- Aggregate [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960 AS COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959 AS COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963 AS COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, count(if ((gid#28647 = 1)) `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648 else null) AS COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, count(if ((gid#28647 = 2)) `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649 else null) AS COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L]
            +- Aggregate [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647]
               +- Expand [ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, null, 1), ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, null, COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, 2)], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647]
                  +- Project [COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681 AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678 AS COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676 AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687 AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680 AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963]
                     +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#27674,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#27675,COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#27677,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678,COL_682B1361_587D_4660_AA5C_CF033B72E213#27679,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681,COL_B6226726_5203_4CE7_928C_112167B1E3F6#27682,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#27683,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#27684,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#27685,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#27686,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#27688,COL_5762487D_DE41_41F2_B7B8_34135953C74B#27689,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#27690,COL_9978526E_040F_4765_A07A_494530767825#27691,COL_37C9528B_3792_4759_A918_47801365FFEC#27692,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#27693,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#27694,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#27695,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#27696] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175 ASC NULLS FIRST], output=[COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175,COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176,COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L,COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L,COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L])
   +- *(4) HashAggregate(keys=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998], functions=[sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 as bigint)), sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L), sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L)], output=[COL_40DD42CA_4C54_45B4_A977_83EE87083E3F#28175, COL_1F1FF60B_545C_47B7_8FF7_4BD9DF08900B#28176, COL_87E65882_D1E4_48A0_948D_1C23E88C8EE6#28229L, COL_46799400_7ECD_4B11_86E3_D3CE134385C3#28231L, COL_F151F138_B5ED_41D3_9665_3B45654246CB#28233L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, 200), true, [id=#6417]
               +- *(3) HashAggregate(keys=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998], functions=[partial_sum(cast(COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999 as bigint)), partial_sum(COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L), partial_sum(COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L)], output=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, sum#28747L, sum#28748L, sum#28749L])
                  +- *(3) HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], functions=[count(if ((gid#28647 = 1)) `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648 else null), count(if ((gid#28647 = 2)) `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649 else null)], output=[COL_1794A3D1_EE59_479F_9D25_9FBF697F05F8#27997, COL_D37E8423_2703_4325_BD5D_D951E9E74F40#27998, COL_8E74AF4F_E26E_4B5B_90AA_3948E8F47D77#27999, COL_60A1B0C6_D2AB_4E39_846B_1A01AE08DCAF#28006L, COL_FF371132_D353_4336_9FBB_8ED6F435159A#28007L])
                     +- CustomShuffleReader coalesced
                        +- ShuffleQueryStage 1
                           +- Exchange hashpartitioning(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, 200), true, [id=#6274]
                              +- *(2) HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963], functions=[partial_count(if ((gid#28647 = 1)) `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648 else null), partial_count(if ((gid#28647 = 2)) `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649 else null)], output=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, count#28752L, count#28753L])
                                 +- *(2) HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647], functions=[], output=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647])
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 0
                                          +- Exchange hashpartitioning(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647, 200), true, [id=#5643]
                                             +- *(1) HashAggregate(keys=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647], functions=[], output=[COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647])
                                                +- *(1) Expand [ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, null, 1), ArrayBuffer(COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, null, COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, 2)], [COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963, `COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F`#28648, `COL_4B84E814_69B6_4635_89A0_F1D05103F93E`#28649, gid#28647]
                                                   +- *(1) Project [COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681 AS COL_9491EFDE_4CD6_4907_9970_4E147DB01275#27959, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678 AS COL_759AE067_7FD0_46AA_913E_679093372F23#27960, COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676 AS COL_EC305545_5F2C_4A6E_8E36_1EC8011A3D5F#27961, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687 AS COL_4B84E814_69B6_4635_89A0_F1D05103F93E#27962, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680 AS COL_4C6C393F_7D7E_4B56_982E_52AE17CD0E12#27963]
                                                      +- *(1) ColumnarToRow
                                                         +- FileScan parquet [COL_D34C5A28_828A_40CE_8921_CE19A666620F#27676,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#27678,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#27680,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#27681,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#27687] 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_12F7A423_7020_42EE_AA20_1968D13CA12B:s...