DC2 - Details for Query 43

Details for Query 43

Submitted Time: 2026/03/05 07:13:44
Duration: 1 s
Succeeded Jobs: 70 77 78

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 (3)\n \nduration: total (min, med, max (stageId: taskId))\n218 ms (6 ms, 10 ms, 34 ms (stage 129.0: task 356))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 1 ms (stage 129.0: task 362)) peak memory total (min, med, max (stageId: taskId)) 963.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 129.0: task 361)) number of output rows: 41 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 129.0: task 361))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 369 shuffle write time total (min, med, max (stageId: taskId)) 627 ms (7 ms, 31 ms, 111 ms (stage 126.0: task 344)) records read: 369 local bytes read total (min, med, max (stageId: taskId)) 40.8 KiB (1241.0 B, 2.9 KiB, 3.3 KiB (stage 129.0: task 351)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 129.0: task 361)) remote bytes read: 0.0 B local blocks read: 192 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 26.8 KiB (1672.0 B, 2.1 KiB, 2.2 KiB (stage 126.0: task 341)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 40.8 KiB (2.5 KiB, 3.2 KiB, 3.4 KiB (stage 126.0: task 341))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (9 ms, 94 ms, 117 ms (stage 126.0: task 341))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 512 ms (2 ms, 16 ms, 94 ms (stage 126.0: task 340)) peak memory total (min, med, max (stageId: taskId)) 3.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 126.0: task 342)) number of output rows: 369 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)) 127 ms (0 ms, 1 ms, 89 ms (stage 126.0: task 341)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 126.0: task 342)) number of output rows: 3,381 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 126.0: task 342))"]; } 9 [labelType="html" label=" CustomShuffleReader "]; 10 [labelType="html" label="Exchange shuffle records written: 3,381 shuffle write time total (min, med, max (stageId: taskId)) 2.3 s (200 ms, 318 ms, 534 ms (stage 114.0: task 281)) records read: 3,381 local bytes read total (min, med, max (stageId: taskId)) 297.5 KiB (7.4 KiB, 24.0 KiB, 24.8 KiB (stage 126.0: task 339)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 126.0: task 342)) remote bytes read: 0.0 B local blocks read: 91 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 360.7 KiB (11.5 KiB, 57.8 KiB, 61.2 KiB (stage 114.0: task 281)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 297.5 KiB (13.8 KiB, 46.7 KiB, 49.1 KiB (stage 114.0: task 281))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n819 ms (35 ms, 114 ms, 205 ms (stage 114.0: task 281))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 208 ms (6 ms, 12 ms, 62 ms (stage 114.0: task 289)) peak memory total (min, med, max (stageId: taskId)) 449.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 114.0: task 289)) number of output rows: 3,381 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 114.0: task 289))"]; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="ColumnarToRow number of output rows: 9,747 number of input batches: 13"]; } 15 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 189 ms (3 ms, 8 ms, 61 ms (stage 114.0: task 289)) metadata time: 0 ms size of files read: 1661.7 KiB number of output rows: 9,747"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 ASC NULLS FIRST,COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 ASC NULLS FIRST], output=[COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944,COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945,COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L])

HashAggregate(keys=[COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], functions=[count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939)])

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, 200), true, [id=#2069]

HashAggregate(keys=[COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], functions=[partial_count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939)])

HashAggregate(keys=[COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, 200), true, [id=#1952]

HashAggregate(keys=[COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], functions=[])

Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3#6867 AS COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_012B029C_9EF7_48A0_9121_FBF2AE91141E#6872 AS COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844,COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3#6867,COL_012B029C_9EF7_48A0_9121_FBF2AE91141E#6872] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_38D9CA2C_BD87_4605_94E4_86B424A96909:string,COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7968 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7975, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7969 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7976, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7970L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7977L]
      +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7962 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7968, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7963 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7969, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7964L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7970L]
         +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7962, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7963, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7964L]
            +- Sort [COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 ASC NULLS FIRST, COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 ASC NULLS FIRST], true
               +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L]
                  +- Aggregate [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, 1 AS NULL_1#7952, count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939) AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L]
                     +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7930 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7938, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7931 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7932 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940]
                        +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7930, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7931, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7932]
                           +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794]
                              +- Aggregate [COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], [COL_712158CA_655D_4664_8573_8D21282F35D7#7685 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794, 1 AS NULL_1#7888]
                                 +- Project [COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7515 AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7657, COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7516 AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7658, COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7517 AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7659, COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7518 AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7660, COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7519 AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7661, COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7520 AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7662, COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7521 AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7663, COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7522 AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7664, COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7523 AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7665, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7524 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7525 AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7667, COL_F4876C15_7C87_4927_AC76_02B384C54713#7526 AS COL_F4876C15_7C87_4927_AC76_02B384C54713#7668, COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7527 AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7669, COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7528 AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7670, COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7529 AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7671, COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7530 AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7672, COL_F9632241_A124_4479_8DED_F00E3E37547C#7531 AS COL_F9632241_A124_4479_8DED_F00E3E37547C#7673, COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7532 AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7674, COL_FCC801DC_915B_4852_BDB7_954E47438C84#7533 AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#7675, COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7534 AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7676, COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7535 AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7677, COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7536 AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7678, COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7537 AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7679, COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7538 AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7680, ... 9 more fields]
                                    +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#7124 as string) AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7515, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#7125 as string) AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7516, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#7126 as string) AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7517, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#7127 as string) AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7518, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#7128 as string) AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7519, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#7129 as string) AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7520, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#7130 as string) AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7521, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#7131 as string) AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7522, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#7132 as string) AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7523, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#7133 as string) AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7524, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#7134 as string) AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7525, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#7135 as string) AS COL_F4876C15_7C87_4927_AC76_02B384C54713#7526, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#7136 as int) AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7527, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#7137 as string) AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7528, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#7138 as string) AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7529, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#7139 as string) AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7530, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#7140 as string) AS COL_F9632241_A124_4479_8DED_F00E3E37547C#7531, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#7141 as string) AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7532, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#7142 as string) AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#7533, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#7143 as string) AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7534, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#7144 as string) AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7535, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#7145 as string) AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7536, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#7146 as string) AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7537, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#7147 as string) AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7538, ... 9 more fields]
                                       +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#6835 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#7124, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6836 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#7125, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6837 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#7126, COL_413BE7B8_1BFE_4393_A802_209E3937124C#6838 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#7127, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6839 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#7128, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6840 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#7129, COL_F472560C_DB99_41F2_9279_7069140A9D65#6841 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#7130, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6842 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#7131, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6843 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#7132, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#7133, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6845 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#7134, COL_135AAA37_5078_4633_9560_24643D2CFC87#6846 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#7135, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6847 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#7136, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6848 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#7137, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6849 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#7138, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6850 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#7139, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6851 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#7140, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6852 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#7141, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6853 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#7142, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6854 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#7143, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6855 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#7144, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6856 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#7145, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6857 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#7146, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6858 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#7147, ... 15 more fields]
                                          +- SubqueryAlias UNION_CONSOLIDA_32798115
                                             +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6835,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6836,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6837,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6838,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6839,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6840,COL_F472560C_DB99_41F2_9279_7069140A9D65#6841,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6842,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6843,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6845,COL_135AAA37_5078_4633_9560_24643D2CFC87#6846,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6847,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6848,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6849,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6850,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6851,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6852,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6853,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6854,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6855,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6856,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6857,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6858,... 15 more fields] parquet

== Analyzed Logical Plan ==
COL_28064021_5EFF_45FA_9FF6_3628A901AFF1: string, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6: string, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7968 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7975, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7969 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7976, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7970L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7977L]
      +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7962 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7968, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7963 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7969, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7964L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7970L]
         +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7962, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7963, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7964L]
            +- Sort [COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 ASC NULLS FIRST, COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 ASC NULLS FIRST], true
               +- Project [COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L]
                  +- Aggregate [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, 1 AS NULL_1#7952, count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939) AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L]
                     +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7930 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7938, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7931 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7932 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940]
                        +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7930, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7931, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7932]
                           +- Project [COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794]
                              +- Aggregate [COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], [COL_712158CA_655D_4664_8573_8D21282F35D7#7685 AS COL_8A7C6506_C54B_4082_8534_FBBDDD687DB5#7792, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7793, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7794, 1 AS NULL_1#7888]
                                 +- Project [COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7515 AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7657, COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7516 AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7658, COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7517 AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7659, COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7518 AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7660, COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7519 AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7661, COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7520 AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7662, COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7521 AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7663, COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7522 AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7664, COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7523 AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7665, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7524 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7525 AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7667, COL_F4876C15_7C87_4927_AC76_02B384C54713#7526 AS COL_F4876C15_7C87_4927_AC76_02B384C54713#7668, COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7527 AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7669, COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7528 AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7670, COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7529 AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7671, COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7530 AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7672, COL_F9632241_A124_4479_8DED_F00E3E37547C#7531 AS COL_F9632241_A124_4479_8DED_F00E3E37547C#7673, COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7532 AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7674, COL_FCC801DC_915B_4852_BDB7_954E47438C84#7533 AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#7675, COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7534 AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7676, COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7535 AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7677, COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7536 AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7678, COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7537 AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7679, COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7538 AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7680, ... 9 more fields]
                                    +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#7124 as string) AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#7515, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#7125 as string) AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#7516, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#7126 as string) AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#7517, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#7127 as string) AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#7518, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#7128 as string) AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#7519, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#7129 as string) AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#7520, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#7130 as string) AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#7521, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#7131 as string) AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#7522, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#7132 as string) AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#7523, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#7133 as string) AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7524, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#7134 as string) AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#7525, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#7135 as string) AS COL_F4876C15_7C87_4927_AC76_02B384C54713#7526, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#7136 as int) AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#7527, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#7137 as string) AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#7528, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#7138 as string) AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#7529, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#7139 as string) AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#7530, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#7140 as string) AS COL_F9632241_A124_4479_8DED_F00E3E37547C#7531, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#7141 as string) AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#7532, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#7142 as string) AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#7533, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#7143 as string) AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#7534, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#7144 as string) AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#7535, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#7145 as string) AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#7536, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#7146 as string) AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#7537, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#7147 as string) AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#7538, ... 9 more fields]
                                       +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#6835 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#7124, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6836 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#7125, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6837 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#7126, COL_413BE7B8_1BFE_4393_A802_209E3937124C#6838 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#7127, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6839 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#7128, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6840 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#7129, COL_F472560C_DB99_41F2_9279_7069140A9D65#6841 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#7130, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6842 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#7131, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6843 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#7132, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#7133, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6845 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#7134, COL_135AAA37_5078_4633_9560_24643D2CFC87#6846 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#7135, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6847 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#7136, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6848 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#7137, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6849 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#7138, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6850 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#7139, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6851 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#7140, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6852 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#7141, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6853 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#7142, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6854 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#7143, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6855 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#7144, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6856 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#7145, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6857 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#7146, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6858 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#7147, ... 15 more fields]
                                          +- SubqueryAlias UNION_CONSOLIDA_32798115
                                             +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6835,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6836,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6837,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6838,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6839,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6840,COL_F472560C_DB99_41F2_9279_7069140A9D65#6841,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6842,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6843,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6845,COL_135AAA37_5078_4633_9560_24643D2CFC87#6846,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6847,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6848,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6849,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6850,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6851,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6852,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6853,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6854,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6855,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6856,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6857,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6858,... 15 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 ASC NULLS FIRST, COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 ASC NULLS FIRST], true
      +- Aggregate [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], [COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940 AS COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939 AS COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939) AS COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L]
         +- Aggregate [COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], [COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689 AS COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666 AS COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940]
            +- Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3#6867 AS COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_012B029C_9EF7_48A0_9121_FBF2AE91141E#6872 AS COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689]
               +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6835,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6836,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6837,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6838,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6839,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6840,COL_F472560C_DB99_41F2_9279_7069140A9D65#6841,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6842,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6843,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6845,COL_135AAA37_5078_4633_9560_24643D2CFC87#6846,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6847,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6848,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6849,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6850,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6851,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6852,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6853,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6854,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6855,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6856,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6857,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6858,... 15 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945 ASC NULLS FIRST,COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944 ASC NULLS FIRST], output=[COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944,COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945,COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L])
   +- *(3) HashAggregate(keys=[COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], functions=[count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939)], output=[COL_28064021_5EFF_45FA_9FF6_3628A901AFF1#7944, COL_DF1D2697_5BE7_4791_8287_425182B1E3F6#7945, COL_B0E7EE45_148A_4D8D_B230_6A5727C5417A#7951L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 1
            +- Exchange hashpartitioning(COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, 200), true, [id=#2069]
               +- *(2) HashAggregate(keys=[COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939], functions=[partial_count(COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939)], output=[COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940, COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, count#8013L])
                  +- *(2) HashAggregate(keys=[COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], functions=[], output=[COL_3D9F413A_F76E_41D2_8380_54CF31807E02#7939, COL_9ADBEDDC_25B0_4B3F_98DB_EA717575900E#7940])
                     +- CustomShuffleReader coalesced
                        +- ShuffleQueryStage 0
                           +- Exchange hashpartitioning(COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, 200), true, [id=#1952]
                              +- *(1) HashAggregate(keys=[COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666], functions=[], output=[COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666])
                                 +- *(1) Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#7666, COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3#6867 AS COL_712158CA_655D_4664_8573_8D21282F35D7#7685, COL_012B029C_9EF7_48A0_9121_FBF2AE91141E#6872 AS COL_9C8B8E91_A372_425B_9FD6_B9E2A9071C43#7689]
                                    +- *(1) ColumnarToRow
                                       +- FileScan parquet [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6844,COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3#6867,COL_012B029C_9EF7_48A0_9121_FBF2AE91141E#6872] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_38D9CA2C_BD87_4605_94E4_86B424A96909:string,COL_419C9CA6_59DC_404A_A8A5_FB9FE42322C3:s...