DC2 - Details for Query 40

Details for Query 40

Submitted Time: 2026/03/05 07:13:44
Duration: 0.9 s
Succeeded Jobs: 69 74

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n433 ms (8 ms, 20 ms, 64 ms (stage 119.0: task 307))"; 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 119.0: task 305)) peak memory total (min, med, max (stageId: taskId)) 963.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 119.0: task 310)) number of output rows: 48 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 119.0: task 310))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 284 shuffle write time total (min, med, max (stageId: taskId)) 780 ms (23 ms, 112 ms, 202 ms (stage 113.0: task 292)) records read: 284 local bytes read total (min, med, max (stageId: taskId)) 28.5 KiB (720.0 B, 2016.0 B, 2.3 KiB (stage 119.0: task 308)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 119.0: task 310)) remote bytes read: 0.0 B local blocks read: 105 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 19.0 KiB (2.1 KiB, 2.8 KiB, 2.9 KiB (stage 113.0: task 293)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 28.5 KiB (3.1 KiB, 4.2 KiB, 4.4 KiB (stage 113.0: task 293))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n440 ms (26 ms, 66 ms, 79 ms (stage 113.0: task 279))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 158 ms (4 ms, 12 ms, 57 ms (stage 113.0: task 280)) peak memory total (min, med, max (stageId: taskId)) 1792.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 113.0: task 279)) number of output rows: 284 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="ColumnarToRow number of output rows: 9,747 number of input batches: 13"]; } 10 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 108 ms (3 ms, 10 ms, 34 ms (stage 113.0: task 293)) 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; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 ASC NULLS FIRST,COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 ASC NULLS FIRST], output=[COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344,COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346,COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L])

HashAggregate(keys=[COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], functions=[count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691, 200), true, [id=#1803]

HashAggregate(keys=[COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], functions=[partial_count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691)])

Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582#6210 AS COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192,COL_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582#6210] 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_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7447 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7512, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7448 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7513, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7449L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7514L]
      +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7440 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7447, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7441 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7448, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7442L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7449L]
         +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7440, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7441, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7442L]
            +- Sort [COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 ASC NULLS FIRST, COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 ASC NULLS FIRST], true
               +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7312 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7313 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7314L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L]
                  +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7312, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7313, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7314L]
                     +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L]
                        +- Aggregate [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993, 1 AS NULL_1#7165, count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691) AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L]
                           +- Project [COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6528 AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6664, COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6529 AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6665, COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6530 AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6666, COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6531 AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6667, COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6532 AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6668, COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6533 AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6669, COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6534 AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6670, COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6535 AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6671, COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6536 AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6672, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6537 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6538 AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6674, COL_F4876C15_7C87_4927_AC76_02B384C54713#6539 AS COL_F4876C15_7C87_4927_AC76_02B384C54713#6675, COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6540 AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6676, COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6541 AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6677, COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6542 AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6678, COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6543 AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6679, COL_F9632241_A124_4479_8DED_F00E3E37547C#6544 AS COL_F9632241_A124_4479_8DED_F00E3E37547C#6680, COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6545 AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6681, COL_FCC801DC_915B_4852_BDB7_954E47438C84#6546 AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#6682, COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6547 AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6683, COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6548 AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6684, COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6549 AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6685, COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6550 AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6686, COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6551 AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6687, ... 4 more fields]
                              +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#6321 as string) AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6528, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6322 as string) AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6529, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6323 as string) AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6530, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#6324 as string) AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6531, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6325 as string) AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6532, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6326 as string) AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6533, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#6327 as string) AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6534, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6328 as string) AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6535, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6329 as string) AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6536, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6330 as string) AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6537, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6331 as string) AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6538, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#6332 as string) AS COL_F4876C15_7C87_4927_AC76_02B384C54713#6539, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6333 as int) AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6540, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6334 as string) AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6541, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6335 as string) AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6542, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6336 as string) AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6543, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6337 as string) AS COL_F9632241_A124_4479_8DED_F00E3E37547C#6544, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6338 as string) AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6545, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6339 as string) AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#6546, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6340 as string) AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6547, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6341 as string) AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6548, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6342 as string) AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6549, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6343 as string) AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6550, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6344 as string) AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6551, ... 4 more fields]
                                 +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#6183 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#6321, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6184 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6322, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6185 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6323, COL_413BE7B8_1BFE_4393_A802_209E3937124C#6186 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#6324, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6187 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6325, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6188 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6326, COL_F472560C_DB99_41F2_9279_7069140A9D65#6189 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#6327, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6190 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6328, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6191 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6329, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6330, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6193 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6331, COL_135AAA37_5078_4633_9560_24643D2CFC87#6194 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#6332, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6195 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6333, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6196 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6334, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6197 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6335, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6198 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6336, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6199 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6337, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6200 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6338, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6201 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6339, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6202 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6340, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6203 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6341, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6204 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6342, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6205 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6343, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6206 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6344, ... 15 more fields]
                                    +- SubqueryAlias UNION_CONSOLIDA_32798118
                                       +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6183,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6184,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6185,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6186,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6187,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6188,COL_F472560C_DB99_41F2_9279_7069140A9D65#6189,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6190,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6191,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6193,COL_135AAA37_5078_4633_9560_24643D2CFC87#6194,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6195,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6196,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6197,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6198,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6199,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6200,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6201,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6202,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6203,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6204,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6205,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6206,... 15 more fields] parquet

== Analyzed Logical Plan ==
COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5: string, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164: string, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7447 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7512, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7448 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7513, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7449L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7514L]
      +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7440 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7447, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7441 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7448, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7442L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7449L]
         +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7440, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7441, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7442L]
            +- Sort [COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 ASC NULLS FIRST, COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 ASC NULLS FIRST], true
               +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7312 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7313 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7314L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L]
                  +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7312, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7313, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7314L]
                     +- Project [COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L]
                        +- Aggregate [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#6990, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#6993, 1 AS NULL_1#7165, count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691) AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7164L]
                           +- Project [COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6528 AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6664, COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6529 AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6665, COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6530 AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6666, COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6531 AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6667, COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6532 AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6668, COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6533 AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6669, COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6534 AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6670, COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6535 AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6671, COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6536 AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6672, COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6537 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6538 AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6674, COL_F4876C15_7C87_4927_AC76_02B384C54713#6539 AS COL_F4876C15_7C87_4927_AC76_02B384C54713#6675, COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6540 AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6676, COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6541 AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6677, COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6542 AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6678, COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6543 AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6679, COL_F9632241_A124_4479_8DED_F00E3E37547C#6544 AS COL_F9632241_A124_4479_8DED_F00E3E37547C#6680, COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6545 AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6681, COL_FCC801DC_915B_4852_BDB7_954E47438C84#6546 AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#6682, COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6547 AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6683, COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6548 AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6684, COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6549 AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6685, COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6550 AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6686, COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6551 AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6687, ... 4 more fields]
                              +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#6321 as string) AS COL_7B8D28EB_6183_46BE_9EA1_851CC69493FD#6528, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6322 as string) AS COL_2AAB0781_79AE_4A96_96A0_B2A99FD6A3A2#6529, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6323 as string) AS COL_A3758583_A774_4CFA_AAD5_02138CFFC8C6#6530, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#6324 as string) AS COL_FFFE1737_9272_4B47_94FC_CEF17E9C687B#6531, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6325 as string) AS COL_D3A7CB7C_0BF1_4FA1_83B6_3E582018888D#6532, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6326 as string) AS COL_37DE9D0C_8941_45B6_AC3C_258E3EA3BA42#6533, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#6327 as string) AS COL_BA1F8AD7_DE08_4263_9A0E_B3CCFCCCE87F#6534, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6328 as string) AS COL_54C9F04C_9626_472E_8CF2_A5C6DF124BB4#6535, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6329 as string) AS COL_8122C67A_EA0D_4B39_907A_1489ADA3CB96#6536, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6330 as string) AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6537, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6331 as string) AS COL_F6429FB1_C98D_4F00_B797_717B96A608DD#6538, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#6332 as string) AS COL_F4876C15_7C87_4927_AC76_02B384C54713#6539, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6333 as int) AS COL_D930FD95_038F_4CCF_99BE_250D827B81F2#6540, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6334 as string) AS COL_6E8DCD0C_60DE_4E79_8C02_E9D7252CE3ED#6541, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6335 as string) AS COL_40502655_EDB0_4E9F_9788_BD982F1D0ABC#6542, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6336 as string) AS COL_5D9A0E54_10EA_4232_B862_9BA6C6FA045D#6543, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6337 as string) AS COL_F9632241_A124_4479_8DED_F00E3E37547C#6544, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6338 as string) AS COL_23C66F56_E3E0_4ED5_ADBC_50A7FD43B4E9#6545, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6339 as string) AS COL_FCC801DC_915B_4852_BDB7_954E47438C84#6546, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6340 as string) AS COL_29A9A1F1_AB8F_496F_8B8F_72C560CA8B7B#6547, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6341 as string) AS COL_8B2FDBE1_DB92_4383_B9F1_C84058C4B2BE#6548, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6342 as string) AS COL_93AEDC59_C9A2_441C_BFF7_34080C8EAC44#6549, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6343 as string) AS COL_3AD1D41D_F1F1_4B4F_8DCF_98C6B375D7A3#6550, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6344 as string) AS COL_B6B895F5_09D8_4898_A2DA_71A41BE703C0#6551, ... 4 more fields]
                                 +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#6183 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#6321, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6184 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6322, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6185 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6323, COL_413BE7B8_1BFE_4393_A802_209E3937124C#6186 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#6324, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6187 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6325, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6188 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6326, COL_F472560C_DB99_41F2_9279_7069140A9D65#6189 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#6327, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6190 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6328, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6191 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6329, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6330, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6193 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6331, COL_135AAA37_5078_4633_9560_24643D2CFC87#6194 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#6332, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6195 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6333, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6196 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6334, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6197 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6335, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6198 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6336, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6199 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6337, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6200 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6338, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6201 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6339, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6202 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6340, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6203 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6341, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6204 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6342, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6205 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6343, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6206 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6344, ... 15 more fields]
                                    +- SubqueryAlias UNION_CONSOLIDA_32798118
                                       +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6183,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6184,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6185,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6186,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6187,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6188,COL_F472560C_DB99_41F2_9279_7069140A9D65#6189,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6190,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6191,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6193,COL_135AAA37_5078_4633_9560_24643D2CFC87#6194,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6195,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6196,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6197,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6198,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6199,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6200,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6201,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6202,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6203,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6204,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6205,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6206,... 15 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 ASC NULLS FIRST, COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 ASC NULLS FIRST], true
      +- Aggregate [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], [COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673 AS COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691 AS COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346, count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691) AS COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L]
         +- Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582#6210 AS COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691]
            +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#6183,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#6184,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#6185,COL_413BE7B8_1BFE_4393_A802_209E3937124C#6186,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#6187,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#6188,COL_F472560C_DB99_41F2_9279_7069140A9D65#6189,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#6190,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#6191,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#6193,COL_135AAA37_5078_4633_9560_24643D2CFC87#6194,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#6195,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#6196,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#6197,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#6198,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#6199,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#6200,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#6201,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#6202,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#6203,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#6204,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#6205,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#6206,... 15 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346 ASC NULLS FIRST,COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344 ASC NULLS FIRST], output=[COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344,COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346,COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L])
   +- *(2) HashAggregate(keys=[COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], functions=[count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691)], output=[COL_4B62BC2E_57AF_469D_BC03_E290CDDD7BA5#7344, COL_C14ADCCC_15B6_4B48_9DC9_844762E22164#7346, COL_BFC2E1E4_B323_4E38_BD1E_291C40624AAC#7347L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691, 200), true, [id=#1803]
               +- *(1) HashAggregate(keys=[COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691], functions=[partial_count(COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691)], output=[COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691, count#7887L])
                  +- *(1) Project [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192 AS COL_1B74B4AF_5707_4508_A5E6_64857ABC3C99#6673, COL_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582#6210 AS COL_46399D43_5B80_4A7E_BBD8_0CCDF3B7B70F#6691]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [COL_38D9CA2C_BD87_4605_94E4_86B424A96909#6192,COL_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582#6210] 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_A9D0C9C0_A0DF_4FF9_957E_5616E6D3F582:s...