DC2 - Details for Query 18

Details for Query 18

Submitted Time: 2026/03/05 07:13:36
Duration: 0.3 s
Succeeded Jobs: 26 30

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 4 ms"; 3 [labelType="html" label="HashAggregate time in aggregation build: 4 ms number of output rows: 1"]; } 4 [labelType="html" label="Exchange shuffle records written: 1 shuffle write time: 0 ms records read: 1 local bytes read: 69.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 1 remote blocks read: 0 data size: 32.0 B remote bytes read to disk: 0.0 B shuffle bytes written: 69.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 33 ms"; 6 [labelType="html" label="HashAggregate time in aggregation build: 33 ms number of output rows: 1"]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="ColumnarToRow number of output rows: 45,556 number of input batches: 12"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 20 ms metadata time: 0 ms size of files read: 3.7 MiB number of output rows: 45,556"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

HashAggregate(keys=[], functions=[sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)), sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)), sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint))])

WholeStageCodegen (2)

Exchange SinglePartition, true, [id=#441]

HashAggregate(keys=[], functions=[partial_sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)), partial_sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)), partial_sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint))])

Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2793 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2796 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2799 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2793,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2796,COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2799] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EXTRAIT_ERP_DAT_36180], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C:int,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57:int,...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3271L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3327L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3272L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3328L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3273L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3330L]
      +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3243L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3271L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3244L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3272L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3245L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3273L]
         +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3193L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3243L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3194L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3244L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3195L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3245L]
            +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3165L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3193L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3166L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3194L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3167L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3195L]
               +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3165L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3166L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3167L]
                  +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L]
                     +- Aggregate [1 AS NULL_1#3091, sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L]
                        +- Project [COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3065 AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3073, COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3066 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074, COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3067 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075, COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3068 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076]
                           +- Project [cast(EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2938 as string) AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3065, cast(EXTRAIT_ERP_DAT_36180_COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2965 as int) AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3066, cast(EXTRAIT_ERP_DAT_36180_COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2968 as int) AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3067, cast(EXTRAIT_ERP_DAT_36180_COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2971 as int) AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3068]
                              +- Project [COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2766 AS EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2938, COL_86221558_69F5_4748_8EB4_C35F86C605A0#2767 AS EXTRAIT_ERP_DAT_36180_COL_86221558_69F5_4748_8EB4_C35F86C605A0#2939, COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2768 AS EXTRAIT_ERP_DAT_36180_COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2940, COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2769 AS EXTRAIT_ERP_DAT_36180_COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2941, COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2770 AS EXTRAIT_ERP_DAT_36180_COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2942, COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2771 AS EXTRAIT_ERP_DAT_36180_COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2943, COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2772 AS EXTRAIT_ERP_DAT_36180_COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2944, COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2773 AS EXTRAIT_ERP_DAT_36180_COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2945, COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2774 AS EXTRAIT_ERP_DAT_36180_COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2946, COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2775 AS EXTRAIT_ERP_DAT_36180_COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2947, COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2776 AS EXTRAIT_ERP_DAT_36180_COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2948, COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2777 AS EXTRAIT_ERP_DAT_36180_COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2949, COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2778 AS EXTRAIT_ERP_DAT_36180_COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2950, COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2779 AS EXTRAIT_ERP_DAT_36180_COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2951, COL_DB763C09_C92F_456C_A656_597AE55D5F09#2780 AS EXTRAIT_ERP_DAT_36180_COL_DB763C09_C92F_456C_A656_597AE55D5F09#2952, COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2781 AS EXTRAIT_ERP_DAT_36180_COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2953, COL_CE783D85_C844_46DA_9965_282AD479ECC2#2782 AS EXTRAIT_ERP_DAT_36180_COL_CE783D85_C844_46DA_9965_282AD479ECC2#2954, COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2783 AS EXTRAIT_ERP_DAT_36180_COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2955, COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2784 AS EXTRAIT_ERP_DAT_36180_COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2956, COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2785 AS EXTRAIT_ERP_DAT_36180_COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2957, COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2786 AS EXTRAIT_ERP_DAT_36180_COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2958, COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2787 AS EXTRAIT_ERP_DAT_36180_COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2959, COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2788 AS EXTRAIT_ERP_DAT_36180_COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2960, COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2789 AS EXTRAIT_ERP_DAT_36180_COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2961, ... 33 more fields]
                                 +- SubqueryAlias EXTRAIT_ERP_DAT_36180115
                                    +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2766,COL_86221558_69F5_4748_8EB4_C35F86C605A0#2767,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2768,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2769,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2770,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2771,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2772,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2773,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2774,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2775,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2776,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2777,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2778,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2779,COL_DB763C09_C92F_456C_A656_597AE55D5F09#2780,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2781,COL_CE783D85_C844_46DA_9965_282AD479ECC2#2782,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2783,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2784,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2785,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2786,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2787,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2788,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2789,... 33 more fields] parquet

== Analyzed Logical Plan ==
COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395: bigint, COL_69F46426_57A5_49BD_964B_C7852CB3A63D: bigint, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3271L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3327L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3272L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3328L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3273L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3330L]
      +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3243L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3271L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3244L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3272L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3245L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3273L]
         +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3193L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3243L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3194L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3244L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3195L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3245L]
            +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3165L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3193L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3166L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3194L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3167L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3195L]
               +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3165L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3166L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3167L]
                  +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L]
                     +- Aggregate [1 AS NULL_1#3091, sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3086L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3088L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3090L]
                        +- Project [COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3065 AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3073, COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3066 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074, COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3067 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075, COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3068 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076]
                           +- Project [cast(EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2938 as string) AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#3065, cast(EXTRAIT_ERP_DAT_36180_COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2965 as int) AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3066, cast(EXTRAIT_ERP_DAT_36180_COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2968 as int) AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3067, cast(EXTRAIT_ERP_DAT_36180_COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2971 as int) AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3068]
                              +- Project [COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2766 AS EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2938, COL_86221558_69F5_4748_8EB4_C35F86C605A0#2767 AS EXTRAIT_ERP_DAT_36180_COL_86221558_69F5_4748_8EB4_C35F86C605A0#2939, COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2768 AS EXTRAIT_ERP_DAT_36180_COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2940, COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2769 AS EXTRAIT_ERP_DAT_36180_COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2941, COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2770 AS EXTRAIT_ERP_DAT_36180_COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2942, COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2771 AS EXTRAIT_ERP_DAT_36180_COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2943, COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2772 AS EXTRAIT_ERP_DAT_36180_COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2944, COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2773 AS EXTRAIT_ERP_DAT_36180_COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2945, COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2774 AS EXTRAIT_ERP_DAT_36180_COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2946, COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2775 AS EXTRAIT_ERP_DAT_36180_COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2947, COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2776 AS EXTRAIT_ERP_DAT_36180_COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2948, COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2777 AS EXTRAIT_ERP_DAT_36180_COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2949, COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2778 AS EXTRAIT_ERP_DAT_36180_COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2950, COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2779 AS EXTRAIT_ERP_DAT_36180_COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2951, COL_DB763C09_C92F_456C_A656_597AE55D5F09#2780 AS EXTRAIT_ERP_DAT_36180_COL_DB763C09_C92F_456C_A656_597AE55D5F09#2952, COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2781 AS EXTRAIT_ERP_DAT_36180_COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2953, COL_CE783D85_C844_46DA_9965_282AD479ECC2#2782 AS EXTRAIT_ERP_DAT_36180_COL_CE783D85_C844_46DA_9965_282AD479ECC2#2954, COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2783 AS EXTRAIT_ERP_DAT_36180_COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2955, COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2784 AS EXTRAIT_ERP_DAT_36180_COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2956, COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2785 AS EXTRAIT_ERP_DAT_36180_COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2957, COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2786 AS EXTRAIT_ERP_DAT_36180_COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2958, COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2787 AS EXTRAIT_ERP_DAT_36180_COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2959, COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2788 AS EXTRAIT_ERP_DAT_36180_COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2960, COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2789 AS EXTRAIT_ERP_DAT_36180_COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2961, ... 33 more fields]
                                 +- SubqueryAlias EXTRAIT_ERP_DAT_36180115
                                    +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2766,COL_86221558_69F5_4748_8EB4_C35F86C605A0#2767,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2768,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2769,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2770,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2771,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2772,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2773,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2774,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2775,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2776,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2777,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2778,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2779,COL_DB763C09_C92F_456C_A656_597AE55D5F09#2780,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2781,COL_CE783D85_C844_46DA_9965_282AD479ECC2#2782,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2783,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2784,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2785,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2786,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2787,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2788,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2789,... 33 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3327L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3328L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3330L]
      +- Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2793 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2796 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2799 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076]
         +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#2766,COL_86221558_69F5_4748_8EB4_C35F86C605A0#2767,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#2768,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#2769,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#2770,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#2771,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#2772,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#2773,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#2774,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#2775,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#2776,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#2777,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#2778,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#2779,COL_DB763C09_C92F_456C_A656_597AE55D5F09#2780,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#2781,COL_CE783D85_C844_46DA_9965_282AD479ECC2#2782,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#2783,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#2784,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#2785,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#2786,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#2787,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#2788,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#2789,... 33 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(2) HashAggregate(keys=[], functions=[sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)), sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)), sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint))], output=[COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#3327L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#3328L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#3330L])
      +- ShuffleQueryStage 0
         +- Exchange SinglePartition, true, [id=#441]
            +- *(1) HashAggregate(keys=[], functions=[partial_sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074 as bigint)), partial_sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075 as bigint)), partial_sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076 as bigint))], output=[sum#3634L, sum#3635L, sum#3636L])
               +- *(1) Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2793 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#3074, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2796 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#3075, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2799 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#3076]
                  +- *(1) ColumnarToRow
                     +- FileScan parquet [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#2793,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#2796,COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#2799] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EXTRAIT_ERP_DAT_36180], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C:int,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57:int,...