DC2 - Details for Query 66

Details for Query 66

Submitted Time: 2025/11/07 08:58:33
Duration: 0.3 s
Succeeded Jobs: 92 98

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))\n1.1 s (6 ms, 48 ms, 150 ms (stage 116.0: task 244))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 173 ms (0 ms, 0 ms, 70 ms (stage 116.0: task 244)) peak memory total (min, med, max (stageId: taskId)) 963.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 116.0: task 237)) number of output rows: 16 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 116.0: task 237))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 16 shuffle write time: 5 ms records read: 16 local bytes read total (min, med, max (stageId: taskId)) 1224.0 B (62.0 B, 80.0 B, 117.0 B (stage 116.0: task 243)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 116.0: task 237)) remote bytes read: 0.0 B local blocks read: 15 remote blocks read: 0 data size: 624.0 B remote bytes read to disk: 0.0 B shuffle bytes written: 1224.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 28 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 21 ms peak memory: 256.0 KiB number of output rows: 16 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="ColumnarToRow number of output rows: 45,556 number of input batches: 12"]; } 10 [labelType="html" label="Scan parquet number of files read: 1 scan time: 3 ms metadata time: 0 ms size of files read: 1156.1 KiB number of output rows: 45,556"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_73119149_5FBA_4126_8010_D263C21523FE#20292L DESC NULLS LAST], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267,COL_73119149_5FBA_4126_8010_D263C21523FE#20292L])

HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], functions=[count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, 200), true, [id=#2058]

HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], functions=[partial_count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189)])

Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/QUALITE_ANOMALI_37460], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12:string,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20368 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20429, COL_73119149_5FBA_4126_8010_D263C21523FE#20369L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20430L]
      +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20307 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20368, COL_73119149_5FBA_4126_8010_D263C21523FE#20308L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20369L]
         +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20303 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20307, COL_73119149_5FBA_4126_8010_D263C21523FE#20304L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20308L]
            +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20299 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20303, COL_73119149_5FBA_4126_8010_D263C21523FE#20300L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20304L]
               +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20299, COL_73119149_5FBA_4126_8010_D263C21523FE#20292L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20300L]
                  +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#20292L DESC NULLS LAST], true
                     +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, COL_73119149_5FBA_4126_8010_D263C21523FE#20292L]
                        +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, 1 AS NULL_1#20293, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189) AS COL_73119149_5FBA_4126_8010_D263C21523FE#20292L]
                           +- Project [COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#20190, COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#20191, COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#20192, COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#20193, COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#20194, COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#20195, COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#20197, COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#20198, COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#20199, COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#20200, COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#20201, COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#20202, COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#20203, COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#20204, COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#20205, COL_AEF96C23_3EED_4806_9079_C883161DCC49#20206, COL_70196070_27AC_49CB_A740_7895B733AC45#20207, COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#20208, COL_26542449_7C5E_4774_A457_4543C358EF73#20209, COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#20210]
                              +- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20123 as string) AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20124 as int) AS COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#20190, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20125 as int) AS COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#20191, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20126 as int) AS COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#20192, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20127 as int) AS COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#20193, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20128 as string) AS COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#20194, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20129 as int) AS COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#20195, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20130 as string) AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20131 as string) AS COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#20197, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20132 as string) AS COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#20198, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20133 as int) AS COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#20199, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20134 as int) AS COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#20200, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#20135 as string) AS COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#20201, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#20136 as int) AS COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#20202, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20137 as int) AS COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#20203, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20138 as string) AS COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#20204, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#20139 as int) AS COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#20205, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20140 as int) AS COL_AEF96C23_3EED_4806_9079_C883161DCC49#20206, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20141 as string) AS COL_70196070_27AC_49CB_A740_7895B733AC45#20207, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20142 as int) AS COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#20208, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#20143 as int) AS COL_26542449_7C5E_4774_A457_4543C358EF73#20209, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20144 as string) AS COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#20210]
                                 +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20123, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20043 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20124, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20044 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20125, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20045 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20126, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20046 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20127, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20047 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20128, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20048 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20129, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20130, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20050 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20131, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20051 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20132, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20052 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20133, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20053 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20134, COL_D6237111_5F6F_4655_89BD_4363977DD265#20054 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#20135, COL_5954D6BD_E743_4173_BE3A_CCD220954079#20055 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#20136, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20056 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20137, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20057 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20138, COL_5223D55D_762F_4807_9CED_CCF479B3A227#20058 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#20139, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20059 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20140, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20060 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20141, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20061 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20142, COL_21870150_5C07_42CC_BB77_BCA92051856C#20062 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#20143, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20063 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20144]
                                    +- SubqueryAlias QUALITE_ANOMALI_37460118
                                       +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20043,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20044,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20045,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20046,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20047,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20048,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20050,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20051,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20052,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20053,COL_D6237111_5F6F_4655_89BD_4363977DD265#20054,COL_5954D6BD_E743_4173_BE3A_CCD220954079#20055,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20056,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20057,COL_5223D55D_762F_4807_9CED_CCF479B3A227#20058,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20059,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20060,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20061,COL_21870150_5C07_42CC_BB77_BCA92051856C#20062,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20063] parquet

== Analyzed Logical Plan ==
COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D: string, COL_73119149_5FBA_4126_8010_D263C21523FE: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20368 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20429, COL_73119149_5FBA_4126_8010_D263C21523FE#20369L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20430L]
      +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20307 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20368, COL_73119149_5FBA_4126_8010_D263C21523FE#20308L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20369L]
         +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20303 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20307, COL_73119149_5FBA_4126_8010_D263C21523FE#20304L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20308L]
            +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20299 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20303, COL_73119149_5FBA_4126_8010_D263C21523FE#20300L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20304L]
               +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20299, COL_73119149_5FBA_4126_8010_D263C21523FE#20292L AS COL_73119149_5FBA_4126_8010_D263C21523FE#20300L]
                  +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#20292L DESC NULLS LAST], true
                     +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, COL_73119149_5FBA_4126_8010_D263C21523FE#20292L]
                        +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, 1 AS NULL_1#20293, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189) AS COL_73119149_5FBA_4126_8010_D263C21523FE#20292L]
                           +- Project [COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#20190, COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#20191, COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#20192, COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#20193, COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#20194, COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#20195, COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#20197, COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#20198, COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#20199, COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#20200, COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#20201, COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#20202, COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#20203, COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#20204, COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#20205, COL_AEF96C23_3EED_4806_9079_C883161DCC49#20206, COL_70196070_27AC_49CB_A740_7895B733AC45#20207, COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#20208, COL_26542449_7C5E_4774_A457_4543C358EF73#20209, COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#20210]
                              +- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20123 as string) AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20124 as int) AS COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#20190, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20125 as int) AS COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#20191, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20126 as int) AS COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#20192, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20127 as int) AS COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#20193, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20128 as string) AS COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#20194, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20129 as int) AS COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#20195, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20130 as string) AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20131 as string) AS COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#20197, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20132 as string) AS COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#20198, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20133 as int) AS COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#20199, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20134 as int) AS COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#20200, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#20135 as string) AS COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#20201, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#20136 as int) AS COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#20202, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20137 as int) AS COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#20203, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20138 as string) AS COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#20204, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#20139 as int) AS COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#20205, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20140 as int) AS COL_AEF96C23_3EED_4806_9079_C883161DCC49#20206, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20141 as string) AS COL_70196070_27AC_49CB_A740_7895B733AC45#20207, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20142 as int) AS COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#20208, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#20143 as int) AS COL_26542449_7C5E_4774_A457_4543C358EF73#20209, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20144 as string) AS COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#20210]
                                 +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20123, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20043 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20124, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20044 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20125, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20045 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20126, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20046 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20127, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20047 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20128, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20048 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20129, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20130, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20050 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20131, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20051 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20132, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20052 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20133, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20053 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20134, COL_D6237111_5F6F_4655_89BD_4363977DD265#20054 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#20135, COL_5954D6BD_E743_4173_BE3A_CCD220954079#20055 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#20136, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20056 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20137, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20057 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20138, COL_5223D55D_762F_4807_9CED_CCF479B3A227#20058 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#20139, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20059 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20140, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20060 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20141, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20061 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20142, COL_21870150_5C07_42CC_BB77_BCA92051856C#20062 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#20143, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20063 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20144]
                                    +- SubqueryAlias QUALITE_ANOMALI_37460118
                                       +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20043,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20044,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20045,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20046,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20047,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20048,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20050,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20051,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20052,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20053,COL_D6237111_5F6F_4655_89BD_4363977DD265#20054,COL_5954D6BD_E743_4173_BE3A_CCD220954079#20055,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20056,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20057,COL_5223D55D_762F_4807_9CED_CCF479B3A227#20058,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20059,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20060,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20061,COL_21870150_5C07_42CC_BB77_BCA92051856C#20062,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20063] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#20292L DESC NULLS LAST], true
      +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189) AS COL_73119149_5FBA_4126_8010_D263C21523FE#20292L]
         +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196]
            +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#20043,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#20044,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#20045,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#20046,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#20047,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#20048,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#20050,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#20051,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#20052,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#20053,COL_D6237111_5F6F_4655_89BD_4363977DD265#20054,COL_5954D6BD_E743_4173_BE3A_CCD220954079#20055,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#20056,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#20057,COL_5223D55D_762F_4807_9CED_CCF479B3A227#20058,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#20059,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#20060,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#20061,COL_21870150_5C07_42CC_BB77_BCA92051856C#20062,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#20063] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_73119149_5FBA_4126_8010_D263C21523FE#20292L DESC NULLS LAST], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267,COL_73119149_5FBA_4126_8010_D263C21523FE#20292L])
   +- *(2) HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], functions=[count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189)], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#20267, COL_73119149_5FBA_4126_8010_D263C21523FE#20292L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, 200), true, [id=#2058]
               +- *(1) HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196], functions=[partial_count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189)], output=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196, count#20548L])
                  +- *(1) Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#20189, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#20196]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#20042,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#20049] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/QUALITE_ANOMALI_37460], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12:string,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B:s...