DC2 - Details for Query 67

Details for Query 67

Submitted Time: 2025/11/07 08:58:33
Duration: 0.2 s
Succeeded Jobs: 94 101

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: 0 ms"; 3 [labelType="html" label="HashAggregate time in aggregation build: 0 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: 19 ms"; 6 [labelType="html" label="HashAggregate time in aggregation build: 18 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: 4 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#20624 as bigint)), sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)), sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint))])

WholeStageCodegen (2)

Exchange SinglePartition, true, [id=#2105]

HashAggregate(keys=[], functions=[partial_sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)), partial_sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)), partial_sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint))])

Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20336 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20339 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20342 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20336,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20339,COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20342] 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#20667L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20673L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20668L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20674L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20669L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20675L]
      +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20661L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20667L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20662L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20668L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20663L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20669L]
         +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20655L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20661L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20656L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20662L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20657L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20663L]
            +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20649L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20655L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20650L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20656L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20651L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20657L]
               +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20649L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20650L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20651L]
                  +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L]
                     +- Aggregate [1 AS NULL_1#20641, sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L]
                        +- Project [COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20615 AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20623, COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20616 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624, COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20617 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625, COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20618 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626]
                           +- Project [cast(EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20490 as string) AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20615, cast(EXTRAIT_ERP_DAT_36180_COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20517 as int) AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20616, cast(EXTRAIT_ERP_DAT_36180_COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20520 as int) AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20617, cast(EXTRAIT_ERP_DAT_36180_COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20523 as int) AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20618]
                              +- Project [COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20309 AS EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20490, COL_86221558_69F5_4748_8EB4_C35F86C605A0#20310 AS EXTRAIT_ERP_DAT_36180_COL_86221558_69F5_4748_8EB4_C35F86C605A0#20491, COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20311 AS EXTRAIT_ERP_DAT_36180_COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20492, COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20312 AS EXTRAIT_ERP_DAT_36180_COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20493, COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20313 AS EXTRAIT_ERP_DAT_36180_COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20494, COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20314 AS EXTRAIT_ERP_DAT_36180_COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20495, COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20315 AS EXTRAIT_ERP_DAT_36180_COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20496, COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20316 AS EXTRAIT_ERP_DAT_36180_COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20497, COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20317 AS EXTRAIT_ERP_DAT_36180_COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20498, COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20318 AS EXTRAIT_ERP_DAT_36180_COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20499, COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20319 AS EXTRAIT_ERP_DAT_36180_COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20500, COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20320 AS EXTRAIT_ERP_DAT_36180_COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20501, COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20321 AS EXTRAIT_ERP_DAT_36180_COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20502, COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20322 AS EXTRAIT_ERP_DAT_36180_COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20503, COL_DB763C09_C92F_456C_A656_597AE55D5F09#20323 AS EXTRAIT_ERP_DAT_36180_COL_DB763C09_C92F_456C_A656_597AE55D5F09#20504, COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20324 AS EXTRAIT_ERP_DAT_36180_COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20505, COL_CE783D85_C844_46DA_9965_282AD479ECC2#20325 AS EXTRAIT_ERP_DAT_36180_COL_CE783D85_C844_46DA_9965_282AD479ECC2#20506, COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20326 AS EXTRAIT_ERP_DAT_36180_COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20507, COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20327 AS EXTRAIT_ERP_DAT_36180_COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20508, COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20328 AS EXTRAIT_ERP_DAT_36180_COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20509, COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20329 AS EXTRAIT_ERP_DAT_36180_COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20510, COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20330 AS EXTRAIT_ERP_DAT_36180_COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20511, COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20331 AS EXTRAIT_ERP_DAT_36180_COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20512, COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20332 AS EXTRAIT_ERP_DAT_36180_COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20513, ... 33 more fields]
                                 +- SubqueryAlias EXTRAIT_ERP_DAT_36180114
                                    +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20309,COL_86221558_69F5_4748_8EB4_C35F86C605A0#20310,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20311,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20312,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20313,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20314,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20315,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20316,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20317,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20318,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20319,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20320,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20321,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20322,COL_DB763C09_C92F_456C_A656_597AE55D5F09#20323,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20324,COL_CE783D85_C844_46DA_9965_282AD479ECC2#20325,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20326,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20327,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20328,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20329,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20330,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20331,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20332,... 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#20667L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20673L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20668L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20674L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20669L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20675L]
      +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20661L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20667L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20662L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20668L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20663L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20669L]
         +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20655L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20661L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20656L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20662L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20657L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20663L]
            +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20649L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20655L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20650L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20656L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20651L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20657L]
               +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20649L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20650L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20651L]
                  +- Project [COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L]
                     +- Aggregate [1 AS NULL_1#20641, sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20636L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20638L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20640L]
                        +- Project [COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20615 AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20623, COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20616 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624, COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20617 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625, COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20618 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626]
                           +- Project [cast(EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20490 as string) AS COL_D953E8DE_812F_4E0F_BEB0_C26A4844619E#20615, cast(EXTRAIT_ERP_DAT_36180_COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20517 as int) AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20616, cast(EXTRAIT_ERP_DAT_36180_COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20520 as int) AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20617, cast(EXTRAIT_ERP_DAT_36180_COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20523 as int) AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20618]
                              +- Project [COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20309 AS EXTRAIT_ERP_DAT_36180_COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20490, COL_86221558_69F5_4748_8EB4_C35F86C605A0#20310 AS EXTRAIT_ERP_DAT_36180_COL_86221558_69F5_4748_8EB4_C35F86C605A0#20491, COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20311 AS EXTRAIT_ERP_DAT_36180_COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20492, COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20312 AS EXTRAIT_ERP_DAT_36180_COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20493, COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20313 AS EXTRAIT_ERP_DAT_36180_COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20494, COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20314 AS EXTRAIT_ERP_DAT_36180_COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20495, COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20315 AS EXTRAIT_ERP_DAT_36180_COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20496, COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20316 AS EXTRAIT_ERP_DAT_36180_COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20497, COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20317 AS EXTRAIT_ERP_DAT_36180_COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20498, COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20318 AS EXTRAIT_ERP_DAT_36180_COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20499, COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20319 AS EXTRAIT_ERP_DAT_36180_COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20500, COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20320 AS EXTRAIT_ERP_DAT_36180_COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20501, COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20321 AS EXTRAIT_ERP_DAT_36180_COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20502, COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20322 AS EXTRAIT_ERP_DAT_36180_COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20503, COL_DB763C09_C92F_456C_A656_597AE55D5F09#20323 AS EXTRAIT_ERP_DAT_36180_COL_DB763C09_C92F_456C_A656_597AE55D5F09#20504, COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20324 AS EXTRAIT_ERP_DAT_36180_COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20505, COL_CE783D85_C844_46DA_9965_282AD479ECC2#20325 AS EXTRAIT_ERP_DAT_36180_COL_CE783D85_C844_46DA_9965_282AD479ECC2#20506, COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20326 AS EXTRAIT_ERP_DAT_36180_COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20507, COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20327 AS EXTRAIT_ERP_DAT_36180_COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20508, COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20328 AS EXTRAIT_ERP_DAT_36180_COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20509, COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20329 AS EXTRAIT_ERP_DAT_36180_COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20510, COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20330 AS EXTRAIT_ERP_DAT_36180_COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20511, COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20331 AS EXTRAIT_ERP_DAT_36180_COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20512, COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20332 AS EXTRAIT_ERP_DAT_36180_COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20513, ... 33 more fields]
                                 +- SubqueryAlias EXTRAIT_ERP_DAT_36180114
                                    +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20309,COL_86221558_69F5_4748_8EB4_C35F86C605A0#20310,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20311,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20312,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20313,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20314,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20315,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20316,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20317,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20318,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20319,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20320,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20321,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20322,COL_DB763C09_C92F_456C_A656_597AE55D5F09#20323,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20324,COL_CE783D85_C844_46DA_9965_282AD479ECC2#20325,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20326,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20327,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20328,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20329,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20330,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20331,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20332,... 33 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Aggregate [sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)) AS COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20673L, sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)) AS COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20674L, sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint)) AS COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20675L]
      +- Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20336 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20339 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20342 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626]
         +- Relation[COL_DBEC98BB_3941_47F8_B534_555D53C00B99#20309,COL_86221558_69F5_4748_8EB4_C35F86C605A0#20310,COL_6CCFCC56_11CB_4982_A32A_2690B87B2AAD#20311,COL_40099025_0B1A_4B3F_A28C_7FAE47BA29FC#20312,COL_B2FC6D4C_455B_48E5_B668_7E722B775188#20313,COL_5CE522BC_365A_450C_ACE0_5B3D7D2813B6#20314,COL_6EFEB76B_C1C3_451F_BA62_A7F57E191E10#20315,COL_B51BAEFE_D948_4191_A9A0_14D2E838B31F#20316,COL_7CE23E59_EA44_4C64_BE4A_D814BD4341D3#20317,COL_ED1431F0_211B_4F1E_84A8_1641A17A657F#20318,COL_9AC2A8F0_7B46_42BA_8923_70F3A5DF7020#20319,COL_A050591D_9DE8_47BC_AAB0_9634663B3034#20320,COL_3B0B47CC_CC38_4F83_BD21_F798F92FA695#20321,COL_7A07F4EA_F999_4E2C_BA84_2DA1AC0E0760#20322,COL_DB763C09_C92F_456C_A656_597AE55D5F09#20323,COL_18C701AE_E20D_4F36_8906_134FAFCDB4C1#20324,COL_CE783D85_C844_46DA_9965_282AD479ECC2#20325,COL_97645920_EDAA_4EBC_BB2A_00CFF10788AE#20326,COL_ADF30BE9_9BAD_4EE2_A520_3E8CA2450263#20327,COL_2AF13105_349C_468A_A0A1_434B59CD5C7F#20328,COL_202B0AB0_A109_4CE2_972C_88049E3E3147#20329,COL_E34853C9_63E3_4405_8388_C4A6A448B18F#20330,COL_C20E8B11_9365_4FB7_A3E9_59B34F63B089#20331,COL_5BD759F3_3BF2_4787_9ADD_DE2584EA77A1#20332,... 33 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(2) HashAggregate(keys=[], functions=[sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)), sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)), sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint))], output=[COL_6E3D067F_A5C6_4115_BD9B_DC8BD1B64395#20673L, COL_69F46426_57A5_49BD_964B_C7852CB3A63D#20674L, COL_8ECD7C52_56FE_4308_B1DD_52BD49FD0660#20675L])
      +- ShuffleQueryStage 0
         +- Exchange SinglePartition, true, [id=#2105]
            +- *(1) HashAggregate(keys=[], functions=[partial_sum(cast(COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624 as bigint)), partial_sum(cast(COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625 as bigint)), partial_sum(cast(COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626 as bigint))], output=[sum#20682L, sum#20683L, sum#20684L])
               +- *(1) Project [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20336 AS COL_9CB2EE10_9EFA_4454_9DFB_7515A6DD1C54#20624, COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20339 AS COL_34D257AF_163E_4939_98FB_CCC6F7C939E2#20625, COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20342 AS COL_F79DFF6B_3613_4E77_956C_9B1FB2E4C85E#20626]
                  +- *(1) ColumnarToRow
                     +- FileScan parquet [COL_6939B7F8_1CF2_4A02_9169_479B896E2D3C#20336,COL_51E38888_B9F4_47C5_9C0D_4E6B1EC2AD57#20339,COL_C799F5BC_C41C_4D71_9E4F_D0F041EA9799#20342] 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,...