DC2 - Details for Query 22

Details for Query 22

Submitted Time: 2026/03/05 07:13:37
Duration: 0.4 s
Succeeded Jobs: 31 38

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))\n240 ms (6 ms, 10 ms, 32 ms (stage 53.0: task 112))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 8 ms (0 ms, 0 ms, 6 ms (stage 53.0: task 115)) peak memory total (min, med, max (stageId: taskId)) 963.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 53.0: task 116)) number of output rows: 16 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 53.0: task 116))"]; } 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 53.0: task 114)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 53.0: task 116)) 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: 77 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 67 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: 17 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#3890L DESC NULLS LAST], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865,COL_73119149_5FBA_4126_8010_D263C21523FE#3890L])

HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], functions=[count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, 200), true, [id=#597]

HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], functions=[partial_count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799)])

Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674] 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#3909 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3913, COL_73119149_5FBA_4126_8010_D263C21523FE#3910L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3914L]
      +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3905 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3909, COL_73119149_5FBA_4126_8010_D263C21523FE#3906L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3910L]
         +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3901 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3905, COL_73119149_5FBA_4126_8010_D263C21523FE#3902L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3906L]
            +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3897 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3901, COL_73119149_5FBA_4126_8010_D263C21523FE#3898L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3902L]
               +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3897, COL_73119149_5FBA_4126_8010_D263C21523FE#3890L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3898L]
                  +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#3890L DESC NULLS LAST], true
                     +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, COL_73119149_5FBA_4126_8010_D263C21523FE#3890L]
                        +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, 1 AS NULL_1#3891, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799) AS COL_73119149_5FBA_4126_8010_D263C21523FE#3890L]
                           +- Project [COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#3800, COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#3801, COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#3802, COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#3803, COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#3804, COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#3805, COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#3807, COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#3808, COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#3809, COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#3810, COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#3811, COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#3812, COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#3813, COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#3814, COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#3815, COL_AEF96C23_3EED_4806_9079_C883161DCC49#3816, COL_70196070_27AC_49CB_A740_7895B733AC45#3817, COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#3818, COL_26542449_7C5E_4774_A457_4543C358EF73#3819, COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#3820]
                              +- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3733 as string) AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3734 as int) AS COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#3800, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3735 as int) AS COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#3801, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3736 as int) AS COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#3802, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3737 as int) AS COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#3803, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3738 as string) AS COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#3804, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3739 as int) AS COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#3805, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3740 as string) AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3741 as string) AS COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#3807, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3742 as string) AS COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#3808, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3743 as int) AS COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#3809, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3744 as int) AS COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#3810, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3745 as string) AS COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#3811, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3746 as int) AS COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#3812, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3747 as int) AS COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#3813, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3748 as string) AS COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#3814, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#3749 as int) AS COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#3815, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3750 as int) AS COL_AEF96C23_3EED_4806_9079_C883161DCC49#3816, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3751 as string) AS COL_70196070_27AC_49CB_A740_7895B733AC45#3817, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3752 as int) AS COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#3818, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#3753 as int) AS COL_26542449_7C5E_4774_A457_4543C358EF73#3819, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3754 as string) AS COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#3820]
                                 +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3733, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3668 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3734, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3669 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3735, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3670 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3736, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3671 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3737, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3672 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3738, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3673 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3739, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3740, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3675 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3741, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3676 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3742, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3677 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3743, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3678 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3744, COL_D6237111_5F6F_4655_89BD_4363977DD265#3679 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3745, COL_5954D6BD_E743_4173_BE3A_CCD220954079#3680 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3746, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3681 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3747, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3682 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3748, COL_5223D55D_762F_4807_9CED_CCF479B3A227#3683 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#3749, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3684 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3750, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3685 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3751, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3686 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3752, COL_21870150_5C07_42CC_BB77_BCA92051856C#3687 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#3753, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3688 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3754]
                                    +- SubqueryAlias QUALITE_ANOMALI_37460116
                                       +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3668,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3669,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3670,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3671,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3672,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3673,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3675,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3676,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3677,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3678,COL_D6237111_5F6F_4655_89BD_4363977DD265#3679,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3680,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3681,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3682,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3683,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3684,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3685,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3686,COL_21870150_5C07_42CC_BB77_BCA92051856C#3687,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3688] 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#3909 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3913, COL_73119149_5FBA_4126_8010_D263C21523FE#3910L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3914L]
      +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3905 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3909, COL_73119149_5FBA_4126_8010_D263C21523FE#3906L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3910L]
         +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3901 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3905, COL_73119149_5FBA_4126_8010_D263C21523FE#3902L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3906L]
            +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3897 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3901, COL_73119149_5FBA_4126_8010_D263C21523FE#3898L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3902L]
               +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3897, COL_73119149_5FBA_4126_8010_D263C21523FE#3890L AS COL_73119149_5FBA_4126_8010_D263C21523FE#3898L]
                  +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#3890L DESC NULLS LAST], true
                     +- Project [COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, COL_73119149_5FBA_4126_8010_D263C21523FE#3890L]
                        +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, 1 AS NULL_1#3891, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799) AS COL_73119149_5FBA_4126_8010_D263C21523FE#3890L]
                           +- Project [COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#3800, COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#3801, COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#3802, COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#3803, COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#3804, COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#3805, COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#3807, COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#3808, COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#3809, COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#3810, COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#3811, COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#3812, COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#3813, COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#3814, COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#3815, COL_AEF96C23_3EED_4806_9079_C883161DCC49#3816, COL_70196070_27AC_49CB_A740_7895B733AC45#3817, COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#3818, COL_26542449_7C5E_4774_A457_4543C358EF73#3819, COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#3820]
                              +- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3733 as string) AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3734 as int) AS COL_431E2B00_248C_4A37_B700_DC6C5C3F793F#3800, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3735 as int) AS COL_C2C43BD6_2110_44A6_943C_9371A3258FE5#3801, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3736 as int) AS COL_C5484B59_CF63_4C68_93B7_8B5753BBD91D#3802, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3737 as int) AS COL_CB3A9663_4165_4441_AAA0_A78CA7F8EDAE#3803, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3738 as string) AS COL_C5C7C200_DD97_4E98_A03E_C8C6F9A93C61#3804, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3739 as int) AS COL_7858E3F3_77BB_458C_9FAE_213A344A00BB#3805, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3740 as string) AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3741 as string) AS COL_8857E8BA_FFE0_47E9_AB35_E2679DA7A7F1#3807, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3742 as string) AS COL_AACBBA07_D5A3_43CD_A92A_F1CF703C575A#3808, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3743 as int) AS COL_4E2BA6C4_C8A5_439E_9F71_7B1D27F421AA#3809, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3744 as int) AS COL_EF72EE12_0EE7_475F_8B80_AE0786E8330C#3810, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3745 as string) AS COL_B9FD1FEA_7BAE_4B8C_B2AC_1D63BF7D23B3#3811, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3746 as int) AS COL_B2F929D3_D792_4129_9ACB_308D33A7A1C7#3812, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3747 as int) AS COL_217AD789_123F_4CA8_8B7E_6316C4E3112D#3813, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3748 as string) AS COL_9DAC1F59_58DA_4447_BA6B_FF7115EC6952#3814, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#3749 as int) AS COL_F61ED563_8DE4_4802_A773_70962F7B4C7E#3815, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3750 as int) AS COL_AEF96C23_3EED_4806_9079_C883161DCC49#3816, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3751 as string) AS COL_70196070_27AC_49CB_A740_7895B733AC45#3817, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3752 as int) AS COL_2E800B9C_78DA_48A0_B938_AD5ECCAA895C#3818, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#3753 as int) AS COL_26542449_7C5E_4774_A457_4543C358EF73#3819, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3754 as string) AS COL_5439C699_B97C_4CAF_AB0E_EB2628EC130E#3820]
                                 +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3733, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3668 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3734, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3669 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3735, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3670 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3736, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3671 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3737, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3672 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3738, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3673 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3739, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3740, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3675 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3741, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3676 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3742, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3677 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3743, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3678 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3744, COL_D6237111_5F6F_4655_89BD_4363977DD265#3679 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3745, COL_5954D6BD_E743_4173_BE3A_CCD220954079#3680 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3746, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3681 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3747, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3682 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3748, COL_5223D55D_762F_4807_9CED_CCF479B3A227#3683 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#3749, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3684 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3750, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3685 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3751, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3686 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3752, COL_21870150_5C07_42CC_BB77_BCA92051856C#3687 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#3753, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3688 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3754]
                                    +- SubqueryAlias QUALITE_ANOMALI_37460116
                                       +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3668,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3669,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3670,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3671,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3672,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3673,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3675,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3676,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3677,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3678,COL_D6237111_5F6F_4655_89BD_4363977DD265#3679,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3680,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3681,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3682,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3683,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3684,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3685,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3686,COL_21870150_5C07_42CC_BB77_BCA92051856C#3687,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3688] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_73119149_5FBA_4126_8010_D263C21523FE#3890L DESC NULLS LAST], true
      +- Aggregate [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], [COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806 AS COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799) AS COL_73119149_5FBA_4126_8010_D263C21523FE#3890L]
         +- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806]
            +- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3668,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3669,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3670,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3671,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3672,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3673,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3675,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3676,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3677,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3678,COL_D6237111_5F6F_4655_89BD_4363977DD265#3679,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3680,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3681,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3682,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3683,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3684,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3685,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3686,COL_21870150_5C07_42CC_BB77_BCA92051856C#3687,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3688] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_73119149_5FBA_4126_8010_D263C21523FE#3890L DESC NULLS LAST], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865,COL_73119149_5FBA_4126_8010_D263C21523FE#3890L])
   +- *(2) HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], functions=[count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799)], output=[COL_93E0A835_FA78_4EA3_A0B6_7A72C268647D#3865, COL_73119149_5FBA_4126_8010_D263C21523FE#3890L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, 200), true, [id=#597]
               +- *(1) HashAggregate(keys=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806], functions=[partial_count(COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799)], output=[COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806, count#3962L])
                  +- *(1) Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667 AS COL_163DAC09_AFA7_4AF9_8249_AC35EBC2A416#3799, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674 AS COL_62577DC8_6845_4AF2_85D3_2A8203E34836#3806]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3667,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3674] 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...