DC2 - Details for Query 122

Details for Query 122

Submitted Time: 2026/04/29 06:52:24
Duration: 4 s
Succeeded Jobs: 204 215 218 220

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))\n652 ms (12 ms, 24 ms, 86 ms (stage 347.0: task 1154))"; 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, 2 ms (stage 347.0: task 1150)) peak memory total (min, med, max (stageId: taskId)) 1092.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 347.0: task 1129)) number of output rows: 32 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 347.0: task 1129))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 332 shuffle write time total (min, med, max (stageId: taskId)) 736 ms (40 ms, 58 ms, 68 ms (stage 341.0: task 1106)) records read: 332 local bytes read total (min, med, max (stageId: taskId)) 33.2 KiB (1391.0 B, 2000.0 B, 2.7 KiB (stage 347.0: task 1139)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 347.0: task 1129)) remote bytes read: 0.0 B local blocks read: 220 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 22.8 KiB (1544.0 B, 1816.0 B, 1968.0 B (stage 341.0: task 1107)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 33.2 KiB (2.2 KiB, 2.6 KiB, 2.8 KiB (stage 341.0: task 1107))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n359 ms (14 ms, 18 ms, 77 ms (stage 341.0: task 1105))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 117 ms (4 ms, 7 ms, 18 ms (stage 341.0: task 1106)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 341.0: task 1105)) number of output rows: 332 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)) 62 ms (3 ms, 5 ms, 7 ms (stage 341.0: task 1107)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 341.0: task 1105)) number of output rows: 34,951 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1.1 (stage 341.0: task 1106))"]; } 9 [labelType="html" label=" CustomShuffleReader "]; 10 [labelType="html" label="Exchange shuffle records written: 34,951 shuffle write time total (min, med, max (stageId: taskId)) 2.3 s (55 ms, 185 ms, 305 ms (stage 336.0: task 1089)) records read: 34,951 local bytes read total (min, med, max (stageId: taskId)) 926.8 KiB (36.3 KiB, 73.9 KiB, 75.4 KiB (stage 341.0: task 1109)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 341.0: task 1105)) remote bytes read: 0.0 B local blocks read: 169 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 2.7 MiB (93.4 KiB, 225.5 KiB, 232.0 KiB (stage 336.0: task 1086)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 926.8 KiB (45.5 KiB, 73.4 KiB, 75.0 KiB (stage 336.0: task 1086))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (26 ms, 96 ms, 211 ms (stage 336.0: task 1087))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 494 ms (4 ms, 27 ms, 136 ms (stage 336.0: task 1087)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 336.0: task 1086)) number of output rows: 34,951 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1.1 (stage 336.0: task 1086))"]; 13 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 184 ms (1 ms, 10 ms, 34 ms (stage 336.0: task 1084)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 336.0: task 1086)) number of output rows: 34,951 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.1, 1.1 (stage 336.0: task 1085))"]; } 14 [labelType="html" label=" CustomShuffleReader "]; 15 [labelType="html" label="Exchange shuffle records written: 34,951 shuffle write time total (min, med, max (stageId: taskId)) 100 ms (27 ms, 29 ms, 43 ms (stage 315.0: task 1027)) records read: 34,951 local bytes read total (min, med, max (stageId: taskId)) 768.6 KiB (25.8 KiB, 61.9 KiB, 63.4 KiB (stage 336.0: task 1086)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 336.0: task 1086)) remote bytes read: 0.0 B local blocks read: 39 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 3.0 MiB (149.2 KiB, 674.1 KiB, 2.2 MiB (stage 315.0: task 1027)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 768.6 KiB (75.7 KiB, 198.0 KiB, 494.9 KiB (stage 315.0: task 1027))"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.8 s (3 ms, 540 ms, 2.0 s (stage 315.0: task 1027))"; 17 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 2.5 s (1 ms, 508 ms, 1.8 s (stage 315.0: task 1027)) peak memory total (min, med, max (stageId: taskId)) 193.8 MiB (256.0 KiB, 64.3 MiB, 65.0 MiB (stage 315.0: task 1027)) number of output rows: 34,951 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1.3, 1.5 (stage 315.0: task 1027))"]; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="ColumnarToRow number of output rows: 4,081,140 number of input batches: 999"]; } 20 [labelType="html" label="Scan parquet number of files read: 4 scan time total (min, med, max (stageId: taskId)) 22 ms (1 ms, 4 ms, 14 ms (stage 315.0: task 1027)) 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; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 ASC NULLS FIRST,COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 ASC NULLS FIRST], output=[COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799,COL_85994BA3_F6F9_4122_871D_767339369884#28800,COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801,COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L])

HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716], functions=[count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712)])

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, 200), true, [id=#6218]

HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716], functions=[partial_count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712)])

HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712], functions=[])

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, 200), true, [id=#6111]

HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712], functions=[])

HashAggregate(keys=[COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689, 200), true, [id=#5799]

Project [COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452 AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443 AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455 AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460 AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459 AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_12F7A423_7020_42EE_AA20_1968D13CA12B:string,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28833 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28841, COL_85994BA3_F6F9_4122_871D_767339369884#28834 AS COL_85994BA3_F6F9_4122_871D_767339369884#28842, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28835 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28843, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28836L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28844L]
      +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28825 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28833, COL_85994BA3_F6F9_4122_871D_767339369884#28826 AS COL_85994BA3_F6F9_4122_871D_767339369884#28834, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28827 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28835, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28828L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28836L]
         +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28825, COL_85994BA3_F6F9_4122_871D_767339369884#28800 AS COL_85994BA3_F6F9_4122_871D_767339369884#28826, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28827, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28828L]
            +- Sort [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 ASC NULLS FIRST, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 ASC NULLS FIRST], true
               +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L]
                  +- Aggregate [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793], [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792 AS COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, 1 AS NULL_1#28808, count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28789) AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L]
                     +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28767 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28789, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28768 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28790, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28769 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28770 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28771 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793]
                        +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28767, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28768, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28769, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28770, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28771]
                           +- Sort [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712 ASC NULLS FIRST, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713 ASC NULLS FIRST, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714 ASC NULLS FIRST, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715 ASC NULLS FIRST, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716 ASC NULLS FIRST], true
                              +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716]
                                 +- Aggregate [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, 1 AS NULL_1#28729]
                                    +- Project [COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28653 AS COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28683, COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28654 AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28655 AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28656 AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_88E846BB_633B_4C51_94FD_68873BC5851C#28657 AS COL_88E846BB_633B_4C51_94FD_68873BC5851C#28687, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28658 AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28659 AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689, COL_A6813382_D706_41D4_80E2_64A32E5443A7#28660 AS COL_A6813382_D706_41D4_80E2_64A32E5443A7#28690, COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28661 AS COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28691]
                                       +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28584 as string) AS COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28653, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28597 as string) AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28654, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28588 as string) AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28655, cast(GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28600 as int) AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28656, cast(GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28603 as string) AS COL_88E846BB_633B_4C51_94FD_68873BC5851C#28657, cast(GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28605 as string) AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28658, cast(GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28604 as string) AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28659, cast(GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28587 as string) AS COL_A6813382_D706_41D4_80E2_64A32E5443A7#28660, cast(GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28598 as string) AS COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28661]
                                          +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28439 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28584, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28440 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28585, COL_D34C5A28_828A_40CE_8921_CE19A666620F#28441 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#28586, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28442 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28587, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28588, COL_682B1361_587D_4660_AA5C_CF033B72E213#28444 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#28589, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28445 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28590, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28446 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28591, COL_B6226726_5203_4CE7_928C_112167B1E3F6#28447 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#28592, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28448 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28593, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28449 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28594, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28450 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28595, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28451 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28596, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28597, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28453 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28598, COL_5762487D_DE41_41F2_B7B8_34135953C74B#28454 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#28599, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28600, COL_9978526E_040F_4765_A07A_494530767825#28456 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#28601, COL_37C9528B_3792_4759_A918_47801365FFEC#28457 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#28602, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28458 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28603, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28604, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28605, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28461 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28606]
                                             +- SubqueryAlias GOUPEMENTS_DE_C_21721114
                                                +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28439,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28440,COL_D34C5A28_828A_40CE_8921_CE19A666620F#28441,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28442,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443,COL_682B1361_587D_4660_AA5C_CF033B72E213#28444,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28445,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28446,COL_B6226726_5203_4CE7_928C_112167B1E3F6#28447,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28448,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28449,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28450,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28451,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28453,COL_5762487D_DE41_41F2_B7B8_34135953C74B#28454,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455,COL_9978526E_040F_4765_A07A_494530767825#28456,COL_37C9528B_3792_4759_A918_47801365FFEC#28457,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28458,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28461] parquet

== Analyzed Logical Plan ==
COL_D368C7F8_F152_475A_8482_80FFA5201CCB: string, COL_85994BA3_F6F9_4122_871D_767339369884: string, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6: string, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28833 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28841, COL_85994BA3_F6F9_4122_871D_767339369884#28834 AS COL_85994BA3_F6F9_4122_871D_767339369884#28842, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28835 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28843, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28836L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28844L]
      +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28825 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28833, COL_85994BA3_F6F9_4122_871D_767339369884#28826 AS COL_85994BA3_F6F9_4122_871D_767339369884#28834, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28827 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28835, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28828L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28836L]
         +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28825, COL_85994BA3_F6F9_4122_871D_767339369884#28800 AS COL_85994BA3_F6F9_4122_871D_767339369884#28826, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28827, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28828L]
            +- Sort [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 ASC NULLS FIRST, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 ASC NULLS FIRST], true
               +- Project [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L]
                  +- Aggregate [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793], [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792 AS COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, 1 AS NULL_1#28808, count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28789) AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L]
                     +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28767 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28789, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28768 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28790, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28769 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28791, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28770 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28792, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28771 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28793]
                        +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28767, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28768, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28769, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28770, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28771]
                           +- Sort [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712 ASC NULLS FIRST, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713 ASC NULLS FIRST, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714 ASC NULLS FIRST, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715 ASC NULLS FIRST, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716 ASC NULLS FIRST], true
                              +- Project [COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716]
                                 +- Aggregate [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686 AS COL_466BEB0F_6FC1_4FBF_87BA_3907EAB7BF16#28713, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, 1 AS NULL_1#28729]
                                    +- Project [COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28653 AS COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28683, COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28654 AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28655 AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28656 AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_88E846BB_633B_4C51_94FD_68873BC5851C#28657 AS COL_88E846BB_633B_4C51_94FD_68873BC5851C#28687, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28658 AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28659 AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689, COL_A6813382_D706_41D4_80E2_64A32E5443A7#28660 AS COL_A6813382_D706_41D4_80E2_64A32E5443A7#28690, COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28661 AS COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28691]
                                       +- Project [cast(GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28584 as string) AS COL_46A77C8B_A33F_4065_82DE_A293E9608D53#28653, cast(GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28597 as string) AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28654, cast(GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28588 as string) AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28655, cast(GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28600 as int) AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28656, cast(GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28603 as string) AS COL_88E846BB_633B_4C51_94FD_68873BC5851C#28657, cast(GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28605 as string) AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28658, cast(GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28604 as string) AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28659, cast(GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28587 as string) AS COL_A6813382_D706_41D4_80E2_64A32E5443A7#28660, cast(GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28598 as string) AS COL_737967B2_90E0_4D21_B1E2_439719D99CE6#28661]
                                          +- Project [COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28439 AS GOUPEMENTS_DE_C_21721_COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28584, COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28440 AS GOUPEMENTS_DE_C_21721_COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28585, COL_D34C5A28_828A_40CE_8921_CE19A666620F#28441 AS GOUPEMENTS_DE_C_21721_COL_D34C5A28_828A_40CE_8921_CE19A666620F#28586, COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28442 AS GOUPEMENTS_DE_C_21721_COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28587, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443 AS GOUPEMENTS_DE_C_21721_COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28588, COL_682B1361_587D_4660_AA5C_CF033B72E213#28444 AS GOUPEMENTS_DE_C_21721_COL_682B1361_587D_4660_AA5C_CF033B72E213#28589, COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28445 AS GOUPEMENTS_DE_C_21721_COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28590, COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28446 AS GOUPEMENTS_DE_C_21721_COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28591, COL_B6226726_5203_4CE7_928C_112167B1E3F6#28447 AS GOUPEMENTS_DE_C_21721_COL_B6226726_5203_4CE7_928C_112167B1E3F6#28592, COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28448 AS GOUPEMENTS_DE_C_21721_COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28593, COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28449 AS GOUPEMENTS_DE_C_21721_COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28594, COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28450 AS GOUPEMENTS_DE_C_21721_COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28595, COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28451 AS GOUPEMENTS_DE_C_21721_COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28596, COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452 AS GOUPEMENTS_DE_C_21721_COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28597, COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28453 AS GOUPEMENTS_DE_C_21721_COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28598, COL_5762487D_DE41_41F2_B7B8_34135953C74B#28454 AS GOUPEMENTS_DE_C_21721_COL_5762487D_DE41_41F2_B7B8_34135953C74B#28599, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455 AS GOUPEMENTS_DE_C_21721_COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28600, COL_9978526E_040F_4765_A07A_494530767825#28456 AS GOUPEMENTS_DE_C_21721_COL_9978526E_040F_4765_A07A_494530767825#28601, COL_37C9528B_3792_4759_A918_47801365FFEC#28457 AS GOUPEMENTS_DE_C_21721_COL_37C9528B_3792_4759_A918_47801365FFEC#28602, COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28458 AS GOUPEMENTS_DE_C_21721_COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28603, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459 AS GOUPEMENTS_DE_C_21721_COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28604, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460 AS GOUPEMENTS_DE_C_21721_COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28605, COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28461 AS GOUPEMENTS_DE_C_21721_COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28606]
                                             +- SubqueryAlias GOUPEMENTS_DE_C_21721114
                                                +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28439,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28440,COL_D34C5A28_828A_40CE_8921_CE19A666620F#28441,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28442,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443,COL_682B1361_587D_4660_AA5C_CF033B72E213#28444,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28445,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28446,COL_B6226726_5203_4CE7_928C_112167B1E3F6#28447,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28448,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28449,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28450,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28451,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28453,COL_5762487D_DE41_41F2_B7B8_34135953C74B#28454,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455,COL_9978526E_040F_4765_A07A_494530767825#28456,COL_37C9528B_3792_4759_A918_47801365FFEC#28457,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28458,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28461] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 ASC NULLS FIRST, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 ASC NULLS FIRST], true
      +- Aggregate [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716], [COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714 AS COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715 AS COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716 AS COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712) AS COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L]
         +- Aggregate [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], [COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684 AS COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685 AS COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688 AS COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689 AS COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716]
            +- Project [COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452 AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443 AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455 AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460 AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459 AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689]
               +- Relation[COL_4AB1618C_59AE_42CF_B08E_FCFA4B35E4AF#28439,COL_EBF892AA_953F_4919_A719_EBCDEBAC18EE#28440,COL_D34C5A28_828A_40CE_8921_CE19A666620F#28441,COL_BC8C9F56_E9E7_4BC0_9380_114C24B1F427#28442,COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443,COL_682B1361_587D_4660_AA5C_CF033B72E213#28444,COL_278E49B2_CCCC_4A11_A01C_20DC4DB60820#28445,COL_6D4F4315_23D7_4CC3_BA41_CCE3FBC89515#28446,COL_B6226726_5203_4CE7_928C_112167B1E3F6#28447,COL_B5BF002E_7653_498B_9834_DCFE11F3725F#28448,COL_82C0B34C_DEC7_4BF1_853B_67E1863B3D86#28449,COL_5CFEDC3F_D87F_44F3_94D7_1DE12CF48C3C#28450,COL_38F9C02A_A7AA_4B3D_8E32_CC065A2A89D4#28451,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452,COL_B5C09BBE_D794_43C3_9B0A_812F59350A7A#28453,COL_5762487D_DE41_41F2_B7B8_34135953C74B#28454,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455,COL_9978526E_040F_4765_A07A_494530767825#28456,COL_37C9528B_3792_4759_A918_47801365FFEC#28457,COL_899BBF4F_758E_4E48_8A32_A88675ABFA8C#28458,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460,COL_31A0E26B_A85D_4CD9_9043_F6BD9869F163#28461] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799 ASC NULLS FIRST,COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801 ASC NULLS FIRST], output=[COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799,COL_85994BA3_F6F9_4122_871D_767339369884#28800,COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801,COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L])
   +- *(4) HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716], functions=[count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712)], output=[COL_D368C7F8_F152_475A_8482_80FFA5201CCB#28799, COL_85994BA3_F6F9_4122_871D_767339369884#28800, COL_31FD3FEB_3509_45C8_BBD3_237AF47453D6#28801, COL_5CC9D236_894D_4662_BEDC_60F4FE33112B#28807L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 2
            +- Exchange hashpartitioning(COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, 200), true, [id=#6218]
               +- *(3) HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716], functions=[partial_count(distinct COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712)], output=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, count#28851L])
                  +- *(3) HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712], functions=[], output=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712])
                     +- CustomShuffleReader coalesced
                        +- ShuffleQueryStage 1
                           +- Exchange hashpartitioning(COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, 200), true, [id=#6111]
                              +- *(2) HashAggregate(keys=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712], functions=[], output=[COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716, COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712])
                                 +- *(2) HashAggregate(keys=[COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], functions=[], output=[COL_3F990051_0113_4882_ACA2_BAEC6F1408E5#28712, COL_0A87592A_B4CE_444E_8878_67CDE5C3106C#28714, COL_5953F842_7EAB_4204_8FCA_A3A26C17BFFD#28715, COL_6945ADA1_FD51_4CAB_AE17_10A05C3EC6AF#28716])
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 0
                                          +- Exchange hashpartitioning(COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689, 200), true, [id=#5799]
                                             +- *(1) HashAggregate(keys=[COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689], functions=[], output=[COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689])
                                                +- *(1) Project [COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452 AS COL_32FC40ED_151D_4EEC_AF25_477F5CFA2CCD#28684, COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443 AS COL_7769923A_4064_40CE_9DDD_40607A91DD8C#28685, COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455 AS COL_A3B594F0_93A8_4C56_85B4_375A19280702#28686, COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460 AS COL_8E21B882_225A_41F8_A8C9_ECDA0E4565FC#28688, COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459 AS COL_DE1D55B1_7E00_433E_8DB8_A94A9C383FD5#28689]
                                                   +- *(1) ColumnarToRow
                                                      +- FileScan parquet [COL_12F7A423_7020_42EE_AA20_1968D13CA12B#28443,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE#28452,COL_BE938454_F986_49A1_9B5E_621971B1BBE2#28455,COL_3E66EB4B_3130_4C6E_BA7B_4A12B5DA4009#28459,COL_C020B7C2_9C8C_4976_A4BE_7443B7D7C25A#28460] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GOUPEMENTS_DE_C_21721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_12F7A423_7020_42EE_AA20_1968D13CA12B:string,COL_3C2F73EB_DC83_4A86_A2D5_90B0E0DAC7AE:s...