DC2 - Details for Query 110

Details for Query 110

Submitted Time: 2026/04/29 06:33:18
Duration: 0.4 s
Succeeded Jobs: 188 193

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))\n12 ms (1 ms, 1 ms, 10 ms (stage 304.0: task 1000))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 304.0: task 998)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 304.0: task 1000)) number of output rows: 1 avg hash probe bucket list iters: 1"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 11 shuffle write time total (min, med, max (stageId: taskId)) 103 ms (3 ms, 6 ms, 30 ms (stage 296.0: task 968)) records read: 11 local bytes read: 792.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 11 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 352.0 B (32.0 B, 32.0 B, 32.0 B (stage 296.0: task 960)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 792.0 B (72.0 B, 72.0 B, 72.0 B (stage 296.0: task 960))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n362 ms (14 ms, 39 ms, 54 ms (stage 296.0: task 970))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 276 ms (9 ms, 33 ms, 42 ms (stage 296.0: task 970)) peak memory total (min, med, max (stageId: taskId)) 2.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 296.0: task 960)) number of output rows: 11 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 47,831"]; 10 [labelType="html" label="ColumnarToRow number of output rows: 124,947 number of input batches: 34"]; } 11 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 57 ms (2 ms, 4 ms, 12 ms (stage 296.0: task 976)) metadata time: 0 ms size of files read: 12.2 MiB number of output rows: 124,947"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 11->10; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954,COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27139])

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], functions=[sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint))])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936, 200), true, [id=#5363]

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], functions=[partial_sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint))])

Project [COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258 AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936]

Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 <=> Usine de ponte)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_87B73D01_19C3_4258_8107_533C60810F9B#26253,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 <=> Usine de ponte)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/CONSOLIDATED_DA_37832], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_87B73D01_19C3_4258_8107_533C60810F9B,Usine de ponte)], ReadSchema: struct<COL_87B73D01_19C3_4258_8107_533C60810F9B:string,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957:int>

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27134 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27138, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27135 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27139]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27085 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27134, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27086 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27135]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27081 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27085, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27082 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27086]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27077 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27081, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27078 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27082]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27077, bigint_to_str(COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27078]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, 1 AS NULL_1#26974, sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint)) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26500 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26501 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26502 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26503 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26504 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26505 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26506 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26507 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26508 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26509 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26510 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26511 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26512 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26513 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26514 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26515 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#26248 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26500, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26249 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26501, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26250 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26502, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26251 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26503, COL_B2A3110A_EA93_484C_99C3_654566F36027#26252 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26504, COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26505, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26254 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26506, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26255 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26507, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26256 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26508, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26257 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26509, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26510, COL_CA314331_595A_479E_B554_2CF73BF8E065#26259 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26511, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26260 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26512, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26261 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26513, COL_96EC1D60_6665_46D3_9518_324889EF63CF#26262 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26514, COL_8E10419E_226F_4098_A129_7AFAAA38B493#26263 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26515, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26264 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26516, COL_38186F06_5370_460A_8844_41809A1AAA16#26265 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#26517, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26266 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26518, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26267 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26519, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26268 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26520, COL_57F110A8_C27A_4968_805A_624B0B61FC56#26269 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#26521, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26270 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26522, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26271L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26523L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832118
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26248,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26249,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26250,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26251,COL_B2A3110A_EA93_484C_99C3_654566F36027#26252,COL_87B73D01_19C3_4258_8107_533C60810F9B#26253,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26254,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26255,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26256,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26257,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258,COL_CA314331_595A_479E_B554_2CF73BF8E065#26259,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26260,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26261,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26262,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26263,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26264,COL_38186F06_5370_460A_8844_41809A1AAA16#26265,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26266,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26267,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26268,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26269,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26270,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26271L,... 12 more fields] parquet

== Analyzed Logical Plan ==
COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51: string, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27134 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27138, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27135 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27139]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27085 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27134, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27086 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27135]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27081 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27085, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27082 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27086]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27077 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27081, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27078 AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27082]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27077, bigint_to_str(COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27078]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, 1 AS NULL_1#26974, sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint)) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26500 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26780, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26501 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26781, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26502 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26782, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26503 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#26783, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26504 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26784, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26505 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26785, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26506 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26786, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26507 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26787, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26508 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26788, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26509 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26789, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26510 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26511 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26791, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26512 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26792, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26513 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26793, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26514 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26794, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26515 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26795]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#26248 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26500, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26249 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26501, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26250 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26502, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26251 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26503, COL_B2A3110A_EA93_484C_99C3_654566F36027#26252 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26504, COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26505, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26254 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26506, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26255 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26507, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26256 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26508, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26257 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26509, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26510, COL_CA314331_595A_479E_B554_2CF73BF8E065#26259 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26511, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26260 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26512, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26261 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26513, COL_96EC1D60_6665_46D3_9518_324889EF63CF#26262 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26514, COL_8E10419E_226F_4098_A129_7AFAAA38B493#26263 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26515, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26264 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26516, COL_38186F06_5370_460A_8844_41809A1AAA16#26265 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#26517, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26266 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26518, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26267 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26519, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26268 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26520, COL_57F110A8_C27A_4968_805A_624B0B61FC56#26269 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#26521, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26270 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26522, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26271L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26523L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832118
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26248,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26249,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26250,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26251,COL_B2A3110A_EA93_484C_99C3_654566F36027#26252,COL_87B73D01_19C3_4258_8107_533C60810F9B#26253,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26254,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26255,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26256,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26257,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258,COL_CA314331_595A_479E_B554_2CF73BF8E065#26259,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26260,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26261,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26262,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26263,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26264,COL_38186F06_5370_460A_8844_41809A1AAA16#26265,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26266,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26267,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26268,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26269,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26270,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26271L,... 12 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, bigint_to_str(COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27139]
      +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 ASC NULLS FIRST], true
         +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint)) AS COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L]
            +- Project [COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258 AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936]
               +- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 <=> Usine de ponte)
                  +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26248,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26249,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26250,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26251,COL_B2A3110A_EA93_484C_99C3_654566F36027#26252,COL_87B73D01_19C3_4258_8107_533C60810F9B#26253,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26254,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26255,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26256,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26257,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258,COL_CA314331_595A_479E_B554_2CF73BF8E065#26259,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26260,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26261,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26262,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26263,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26264,COL_38186F06_5370_460A_8844_41809A1AAA16#26265,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26266,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26267,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26268,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26269,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26270,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26271L,... 12 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954,COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#27139])
   +- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], functions=[sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint))], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26954, COL_86CA62C4_B6FC_4F25_8591_CF1E4FE86A00#26973L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936, 200), true, [id=#5363]
               +- *(1) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936], functions=[partial_sum(cast(COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790 as bigint))], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936, sum#27298L])
                  +- *(1) Project [COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258 AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26790, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26936]
                     +- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 <=> Usine de ponte)
                        +- *(1) ColumnarToRow
                           +- FileScan parquet [COL_87B73D01_19C3_4258_8107_533C60810F9B#26253,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26258] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#26253 <=> Usine de ponte)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/CONSOLIDATED_DA_37832], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_87B73D01_19C3_4258_8107_533C60810F9B,Usine de ponte)], ReadSchema: struct<COL_87B73D01_19C3_4258_8107_533C60810F9B:string,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957:int>