DC2 - Details for Query 101

Details for Query 101

Submitted Time: 2026/04/29 06:33:16
Duration: 2 s
Succeeded Jobs: 167 173 176 179 185 186

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 (5)\n \nduration: total (min, med, max (stageId: taskId))\n1 ms (0 ms, 0 ms, 1 ms (stage 294.0: task 954))"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label=" Window "]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n89 ms (1 ms, 5 ms, 83 ms (stage 290.0: task 952))"; 6 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 290.0: task 952)) peak memory total (min, med, max (stageId: taskId)) 64.2 MiB (64.0 KiB, 64.0 KiB, 64.1 MiB (stage 294.0: task 954)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 290.0: task 952))"]; } 7 [labelType="html" label=" CustomShuffleReader "]; 8 [labelType="html" label="Exchange shuffle records written: 33 shuffle write time total (min, med, max (stageId: taskId)) 278 ms (3 ms, 14 ms, 50 ms (stage 279.0: task 934)) records read: 33 local bytes read: 1501.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 15 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1320.0 B (40.0 B, 80.0 B, 200.0 B (stage 279.0: task 923)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1501.0 B (83.0 B, 103.0 B, 113.0 B (stage 279.0: task 923))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (3 ms, 179 ms, 193 ms (stage 279.0: task 922))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 518 ms (0 ms, 55 ms, 58 ms (stage 279.0: task 921)) peak memory total (min, med, max (stageId: taskId)) 960.9 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 279.0: task 926)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 279.0: task 926))"]; } 11 [labelType="html" label=" CustomShuffleReader "]; 12 [labelType="html" label="Exchange shuffle records written: 33 shuffle write time total (min, med, max (stageId: taskId)) 49 ms (0 ms, 1 ms, 13 ms (stage 271.0: task 879)) records read: 33 local bytes read total (min, med, max (stageId: taskId)) 2.7 KiB (83.0 B, 167.0 B, 400.0 B (stage 279.0: task 923)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 279.0: task 926)) remote bytes read: 0.0 B local blocks read: 32 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1320.0 B (80.0 B, 80.0 B, 160.0 B (stage 271.0: task 885)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 2.7 KiB (160.0 B, 167.0 B, 334.0 B (stage 271.0: task 885))"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n504 ms (2 ms, 12 ms, 45 ms (stage 265.0: task 851))"; 14 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 32 ms (0 ms, 0 ms, 11 ms (stage 265.0: task 851)) peak memory total (min, med, max (stageId: taskId)) 1799.0 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 265.0: task 850)) number of output rows: 66 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 265.0: task 850))"]; } 15 [labelType="html" label=" CustomShuffleReader "]; 16 [labelType="html" label="Exchange shuffle records written: 314 shuffle write time total (min, med, max (stageId: taskId)) 781 ms (8 ms, 70 ms, 107 ms (stage 257.0: task 793)) records read: 628 local bytes read total (min, med, max (stageId: taskId)) 48.2 KiB (1328.0 B, 1816.0 B, 1985.0 B (stage 265.0: task 857)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 265.0: task 850)) remote bytes read: 0.0 B local blocks read: 308 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 12.3 KiB (1040.0 B, 1160.0 B, 1240.0 B (stage 257.0: task 804)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 24.1 KiB (2.0 KiB, 2.2 KiB, 2.4 KiB (stage 257.0: task 804))"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n715 ms (29 ms, 42 ms, 136 ms (stage 257.0: task 793))"; 18 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 466 ms (7 ms, 26 ms, 101 ms (stage 257.0: task 795)) peak memory total (min, med, max (stageId: taskId)) 2.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 257.0: task 795)) number of output rows: 314 avg hash probe bucket list iters: 0"]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 47,831"]; 21 [labelType="html" label="ColumnarToRow number of output rows: 124,947 number of input batches: 34"]; } 22 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 234 ms (5 ms, 10 ms, 90 ms (stage 257.0: task 797)) metadata time: 0 ms size of files read: 12.2 MiB number of output rows: 124,947"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 16->15; 18->16; 19->18; 20->19; 21->20; 22->21; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034, dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034)), col2, 100.0)) AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25163]

WholeStageCodegen (5)

Window [sum(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25034], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (4)

CustomShuffleReader coalesced

Exchange hashpartitioning(1, 200), true, [id=#5201]

Sort [COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST], true, 0

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange rangepartitioning(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST, 200), true, [id=#5007]

HashAggregate(keys=[COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], functions=[max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, 200), true, [id=#4785]

HashAggregate(keys=[COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], functions=[partial_max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643)])

Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315 AS COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328 AS COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]

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

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315,COL_87B73D01_19C3_4258_8107_533C60810F9B#24318,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 <=> 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_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6:string,COL_87B73D01_19C3_4258_8107_533C60810F9B:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25160, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25161, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25162, COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25138 AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25163]
         +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134, dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134)), col2, cast(100 as double))) AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25138]
            +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25110 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25111 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90#25112 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25134]
               +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25110, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25111, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25112]
                  +- Sort true
                     +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                        +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                           +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                              +- Window [sum(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026) windowspecdefinition(1, CONST#25029 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25034], [1], [CONST#25029 DESC NULLS LAST]
                                 +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029]
                                    +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, 1 AS CONST#25029]
                                       +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24945 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24946 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026]
                                          +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24945, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24946]
                                             +- Sort [COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST], true
                                                +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885]
                                                   +- Aggregate [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, 1 AS NULL_1#24886, max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643) AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885]
                                                      +- Project [COL_AC7BF0AD_419C_490B_85A0_E2316674825B#24628, COL_5E892752_2DFC_4FBE_8DB9_F5AAFFFF4ED8#24629, COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, COL_E37447B7_1248_48EE_AD19_80F84EA8B873#24631, COL_398D84DC_8020_4D23_94E9_7650D8D22AD8#24632, COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633, COL_85F41357_1BE6_4A02_822F_45C818CFFCE6#24634, COL_CFC8E5CE_E6E3_4C71_BB7D_BCA6FDB732F2#24635, COL_1590D879_FADB_44CF_9FD6_E2CE9EA245C6#24636, COL_2B54F860_F9AA_4FE0_BA65_30A10FC1430C#24637, COL_025A9441_6525_48B5_8457_E843E3BD8BA2#24638, COL_DABBD1DF_B489_43B0_AD36_CC363B5384CE#24639, COL_3E76E5E2_46AF_4067_A133_7CF4F9BBC188#24640, COL_8ABBD717_093E_456A_8E63_E4EF8C0D66E3#24641, COL_28129425_2ABE_48E4_AB4E_E5C4AB5507A0#24642, COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                                                         +- Filter (COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633 <=> cast(Usine de ponte as string))
                                                            +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24505 as timestamp) AS COL_AC7BF0AD_419C_490B_85A0_E2316674825B#24628, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24506 as string) AS COL_5E892752_2DFC_4FBE_8DB9_F5AAFFFF4ED8#24629, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24507 as string) AS COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24508 as string) AS COL_E37447B7_1248_48EE_AD19_80F84EA8B873#24631, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24509 as string) AS COL_398D84DC_8020_4D23_94E9_7650D8D22AD8#24632, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24510 as string) AS COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24511 as string) AS COL_85F41357_1BE6_4A02_822F_45C818CFFCE6#24634, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24512 as double) AS COL_CFC8E5CE_E6E3_4C71_BB7D_BCA6FDB732F2#24635, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24513 as double) AS COL_1590D879_FADB_44CF_9FD6_E2CE9EA245C6#24636, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24514 as int) AS COL_2B54F860_F9AA_4FE0_BA65_30A10FC1430C#24637, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24515 as int) AS COL_025A9441_6525_48B5_8457_E843E3BD8BA2#24638, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24516 as string) AS COL_DABBD1DF_B489_43B0_AD36_CC363B5384CE#24639, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24517 as string) AS COL_3E76E5E2_46AF_4067_A133_7CF4F9BBC188#24640, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24518 as string) AS COL_8ABBD717_093E_456A_8E63_E4EF8C0D66E3#24641, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24519 as double) AS COL_28129425_2ABE_48E4_AB4E_E5C4AB5507A0#24642, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24520 as double) AS COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                                                               +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#24313 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24505, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24314 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24506, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24507, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24316 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24508, COL_B2A3110A_EA93_484C_99C3_654566F36027#24317 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24509, COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24510, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24319 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24511, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24320 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24512, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24321 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24513, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24322 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24514, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24323 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24515, COL_CA314331_595A_479E_B554_2CF73BF8E065#24324 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24516, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24325 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24517, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24326 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24518, COL_96EC1D60_6665_46D3_9518_324889EF63CF#24327 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24519, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24520, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24329 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24521, COL_38186F06_5370_460A_8844_41809A1AAA16#24330 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#24522, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24331 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24523, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24332 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24524, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24333 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24525, COL_57F110A8_C27A_4968_805A_624B0B61FC56#24334 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#24526, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24335 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24527, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24336L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24528L, ... 12 more fields]
                                                                  +- SubqueryAlias CONSOLIDATED_DA_37832115
                                                                     +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24313,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24314,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24316,COL_B2A3110A_EA93_484C_99C3_654566F36027#24317,COL_87B73D01_19C3_4258_8107_533C60810F9B#24318,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24319,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24320,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24321,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24322,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24323,COL_CA314331_595A_479E_B554_2CF73BF8E065#24324,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24325,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24326,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24327,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24329,COL_38186F06_5370_460A_8844_41809A1AAA16#24330,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24331,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24332,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24333,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24334,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24335,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24336L,... 12 more fields] parquet

== Analyzed Logical Plan ==
COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1: string, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6: double, COL_73A89B78_9500_4404_82D0_4E4117958B90: double, COL_1AD52244_A891_4CDF_B779_F620AA2526F1: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25160, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25161, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25162, COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25138 AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25163]
         +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134, dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90, COL_73A89B78_9500_4404_82D0_4E4117958B90#25134)), col2, cast(100 as double))) AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25138]
            +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25110 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25132, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25111 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25133, COL_73A89B78_9500_4404_82D0_4E4117958B90#25112 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25134]
               +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25110, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25111, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034 AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25112]
                  +- Sort true
                     +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                        +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                           +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034]
                              +- Window [sum(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026) windowspecdefinition(1, CONST#25029 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25034], [1], [CONST#25029 DESC NULLS LAST]
                                 +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, CONST#25029]
                                    +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026, 1 AS CONST#25029]
                                       +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24945 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#25025, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24946 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#25026]
                                          +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24945, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24946]
                                             +- Sort [COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST], true
                                                +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885]
                                                   +- Aggregate [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, 1 AS NULL_1#24886, max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643) AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885]
                                                      +- Project [COL_AC7BF0AD_419C_490B_85A0_E2316674825B#24628, COL_5E892752_2DFC_4FBE_8DB9_F5AAFFFF4ED8#24629, COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, COL_E37447B7_1248_48EE_AD19_80F84EA8B873#24631, COL_398D84DC_8020_4D23_94E9_7650D8D22AD8#24632, COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633, COL_85F41357_1BE6_4A02_822F_45C818CFFCE6#24634, COL_CFC8E5CE_E6E3_4C71_BB7D_BCA6FDB732F2#24635, COL_1590D879_FADB_44CF_9FD6_E2CE9EA245C6#24636, COL_2B54F860_F9AA_4FE0_BA65_30A10FC1430C#24637, COL_025A9441_6525_48B5_8457_E843E3BD8BA2#24638, COL_DABBD1DF_B489_43B0_AD36_CC363B5384CE#24639, COL_3E76E5E2_46AF_4067_A133_7CF4F9BBC188#24640, COL_8ABBD717_093E_456A_8E63_E4EF8C0D66E3#24641, COL_28129425_2ABE_48E4_AB4E_E5C4AB5507A0#24642, COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                                                         +- Filter (COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633 <=> cast(Usine de ponte as string))
                                                            +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24505 as timestamp) AS COL_AC7BF0AD_419C_490B_85A0_E2316674825B#24628, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24506 as string) AS COL_5E892752_2DFC_4FBE_8DB9_F5AAFFFF4ED8#24629, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24507 as string) AS COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24508 as string) AS COL_E37447B7_1248_48EE_AD19_80F84EA8B873#24631, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24509 as string) AS COL_398D84DC_8020_4D23_94E9_7650D8D22AD8#24632, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24510 as string) AS COL_4243DB71_4ED8_4729_BA9A_E5DB3DBE5029#24633, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24511 as string) AS COL_85F41357_1BE6_4A02_822F_45C818CFFCE6#24634, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24512 as double) AS COL_CFC8E5CE_E6E3_4C71_BB7D_BCA6FDB732F2#24635, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24513 as double) AS COL_1590D879_FADB_44CF_9FD6_E2CE9EA245C6#24636, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24514 as int) AS COL_2B54F860_F9AA_4FE0_BA65_30A10FC1430C#24637, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24515 as int) AS COL_025A9441_6525_48B5_8457_E843E3BD8BA2#24638, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24516 as string) AS COL_DABBD1DF_B489_43B0_AD36_CC363B5384CE#24639, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24517 as string) AS COL_3E76E5E2_46AF_4067_A133_7CF4F9BBC188#24640, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24518 as string) AS COL_8ABBD717_093E_456A_8E63_E4EF8C0D66E3#24641, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24519 as double) AS COL_28129425_2ABE_48E4_AB4E_E5C4AB5507A0#24642, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24520 as double) AS COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                                                               +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#24313 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24505, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24314 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24506, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24507, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24316 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24508, COL_B2A3110A_EA93_484C_99C3_654566F36027#24317 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24509, COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24510, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24319 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24511, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24320 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24512, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24321 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24513, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24322 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24514, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24323 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24515, COL_CA314331_595A_479E_B554_2CF73BF8E065#24324 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24516, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24325 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24517, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24326 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24518, COL_96EC1D60_6665_46D3_9518_324889EF63CF#24327 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24519, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24520, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24329 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24521, COL_38186F06_5370_460A_8844_41809A1AAA16#24330 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#24522, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24331 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24523, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24332 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24524, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24333 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24525, COL_57F110A8_C27A_4968_805A_624B0B61FC56#24334 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#24526, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24335 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24527, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24336L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24528L, ... 12 more fields]
                                                                  +- SubqueryAlias CONSOLIDATED_DA_37832115
                                                                     +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24313,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24314,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24316,COL_B2A3110A_EA93_484C_99C3_654566F36027#24317,COL_87B73D01_19C3_4258_8107_533C60810F9B#24318,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24319,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24320,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24321,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24322,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24323,COL_CA314331_595A_479E_B554_2CF73BF8E065#24324,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24325,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24326,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24327,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24329,COL_38186F06_5370_460A_8844_41809A1AAA16#24330,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24331,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24332,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24333,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24334,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24335,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24336L,... 12 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034, dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034)), col2, 100.0)) AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25163]
      +- Window [sum(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25034], [1], [1 DESC NULLS LAST]
         +- Sort [COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST], true
            +- Aggregate [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], [COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630 AS COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643) AS COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885]
               +- Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315 AS COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328 AS COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                  +- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 <=> Usine de ponte)
                     +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24313,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24314,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24316,COL_B2A3110A_EA93_484C_99C3_654566F36027#24317,COL_87B73D01_19C3_4258_8107_533C60810F9B#24318,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24319,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24320,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24321,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24322,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24323,COL_CA314331_595A_479E_B554_2CF73BF8E065#24324,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24325,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24326,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24327,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24329,COL_38186F06_5370_460A_8844_41809A1AAA16#24330,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24331,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24332,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24333,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24334,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24335,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24336L,... 12 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(5) Project [COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034, dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885, COL_73A89B78_9500_4404_82D0_4E4117958B90, COL_73A89B78_9500_4404_82D0_4E4117958B90#25034)), col2, 100.0)) AS COL_1AD52244_A891_4CDF_B779_F620AA2526F1#25163]
      +- Window [sum(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), unboundedfollowing$())) AS COL_73A89B78_9500_4404_82D0_4E4117958B90#25034], [1], [1 DESC NULLS LAST]
         +- *(4) Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
            +- CustomShuffleReader coalesced
               +- ShuffleQueryStage 2
                  +- Exchange hashpartitioning(1, 200), true, [id=#5201]
                     +- *(3) Sort [COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST], true, 0
                        +- CustomShuffleReader coalesced
                           +- ShuffleQueryStage 1
                              +- Exchange rangepartitioning(COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885 DESC NULLS LAST, 200), true, [id=#5007]
                                 +- *(2) HashAggregate(keys=[COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], functions=[max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643)], output=[COL_73233E44_AF2B_4C8C_90F0_1A78CAC1ABA1#24823, COL_FD4758A2_ECB1_4617_B7BD_0FC18F0ABEB6#24885])
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 0
                                          +- Exchange hashpartitioning(COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, 200), true, [id=#4785]
                                             +- *(1) HashAggregate(keys=[COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630], functions=[partial_max(COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643)], output=[COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, max#25229])
                                                +- *(1) Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315 AS COL_C19FA3DA_C9EC_464D_9B29_7E4617C0F763#24630, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328 AS COL_500F0D75_093B_4715_8D96_376B3AE65B2D#24643]
                                                   +- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 <=> Usine de ponte)
                                                      +- *(1) ColumnarToRow
                                                         +- FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24315,COL_87B73D01_19C3_4258_8107_533C60810F9B#24318,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24328] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#24318 <=> 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_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6:string,COL_87B73D01_19C3_4258_8107_533C60810F9B:s...