DC2 - Details for Query 106

Details for Query 106

Submitted Time: 2026/04/29 06:33:18
Duration: 1 s
Succeeded Jobs: 181 190

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))\n362 ms (16 ms, 26 ms, 56 ms (stage 299.0: task 983))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 98 ms (2 ms, 4 ms, 23 ms (stage 299.0: task 986)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 299.0: task 981)) number of output rows: 4,367 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 299.0: task 981))"]; } 4 [labelType="html" label=" CustomShuffleReader "]; 5 [labelType="html" label="Exchange shuffle records written: 8,583 shuffle write time total (min, med, max (stageId: taskId)) 3.2 s (200 ms, 290 ms, 361 ms (stage 283.0: task 938)) records read: 8,583 local bytes read total (min, med, max (stageId: taskId)) 443.9 KiB (11.3 KiB, 36.1 KiB, 37.0 KiB (stage 299.0: task 982)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 299.0: task 981)) remote bytes read: 0.0 B local blocks read: 143 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 670.5 KiB (9.9 KiB, 63.8 KiB, 75.4 KiB (stage 283.0: task 936)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 443.9 KiB (11.6 KiB, 42.4 KiB, 47.0 KiB (stage 283.0: task 936))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.7 s (84 ms, 264 ms, 334 ms (stage 283.0: task 945))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 710 ms (31 ms, 61 ms, 148 ms (stage 283.0: task 947)) peak memory total (min, med, max (stageId: taskId)) 706.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 283.0: task 935)) number of output rows: 8,583 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 283.0: task 935))"]; 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)) 145 ms (4 ms, 8 ms, 34 ms (stage 283.0: task 946)) 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_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 ASC NULLS FIRST], output=[COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926,COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927,COL_8673266B_223F_4D4F_90D7_231707BB3824#25946,COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948])

HashAggregate(keys=[COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], functions=[avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868), avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, 200), true, [id=#5158]

HashAggregate(keys=[COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], functions=[partial_avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868), partial_avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867)])

Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25664 AS COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671 AS COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672 AS COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, str_create(Non Conformité (%)) AS COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908]

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

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_8886263B_787F_402D_99DF_85269A2625C7#25664,COL_87B73D01_19C3_4258_8107_533C60810F9B#25669,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 <=> 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_8886263B_787F_402D_99DF_85269A2625C7:timestamp,COL_87B73D01_19C3_4258_8107_533C60810F9...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25983 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25991, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25984 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25992, COL_8673266B_223F_4D4F_90D7_231707BB3824#25985 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25993, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25986 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25994]
         +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25975 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25983, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25976 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25984, COL_8673266B_223F_4D4F_90D7_231707BB3824#25977 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25985, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25978 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25986]
            +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25967 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25975, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25968 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25976, COL_8673266B_223F_4D4F_90D7_231707BB3824#25969 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25977, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25970 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25978]
               +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25959 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25967, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25960 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25968, COL_8673266B_223F_4D4F_90D7_231707BB3824#25961 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25969, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25962 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25970]
                  +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25959, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25960, COL_8673266B_223F_4D4F_90D7_231707BB3824#25946 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25961, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25962]
                     +- Sort [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 ASC NULLS FIRST], true
                        +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948]
                           +- Aggregate [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, 1 AS NULL_1#25949, avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868) AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867) AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948]
                              +- Project [COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, COL_33978511_E1D8_4736_9575_50560B51B58E#25874, COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875, str_create(cast(Non Conformité (%) as string)) AS COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908]
                                 +- Project [COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, COL_33978511_E1D8_4736_9575_50560B51B58E#25874, COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875]
                                    +- Filter (COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25772 as timestamp) AS COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25773 as string) AS COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25774 as string) AS COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25775 as string) AS COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25776 as string) AS COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25777 as string) AS COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25778 as string) AS COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25779 as double) AS COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25780 as double) AS COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25781 as int) AS COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25782 as int) AS COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25783 as string) AS COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25784 as string) AS COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25785 as string) AS COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25786 as double) AS COL_33978511_E1D8_4736_9575_50560B51B58E#25874, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25787 as double) AS COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25664 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25772, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25665 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25773, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25666 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25774, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25667 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25775, COL_B2A3110A_EA93_484C_99C3_654566F36027#25668 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25776, COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25777, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25670 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25778, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25779, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25780, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25673 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25781, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25674 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25782, COL_CA314331_595A_479E_B554_2CF73BF8E065#25675 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25783, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25676 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25784, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25677 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25785, COL_96EC1D60_6665_46D3_9518_324889EF63CF#25678 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25786, COL_8E10419E_226F_4098_A129_7AFAAA38B493#25679 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25787, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25680 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25788, COL_38186F06_5370_460A_8844_41809A1AAA16#25681 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25789, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25682 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25790, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25683 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25791, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25684 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25792, COL_57F110A8_C27A_4968_805A_624B0B61FC56#25685 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25793, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25686 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25794, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25687L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25795L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832116
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25664,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25665,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25666,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25667,COL_B2A3110A_EA93_484C_99C3_654566F36027#25668,COL_87B73D01_19C3_4258_8107_533C60810F9B#25669,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25670,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25673,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25674,COL_CA314331_595A_479E_B554_2CF73BF8E065#25675,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25676,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25677,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25678,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25679,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25680,COL_38186F06_5370_460A_8844_41809A1AAA16#25681,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25682,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25683,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25684,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25685,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25686,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25687L,... 12 more fields] parquet

== Analyzed Logical Plan ==
COL_2A2BCADA_C08D_490E_973C_9B07606DD274: string, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854: timestamp, COL_8673266B_223F_4D4F_90D7_231707BB3824: double, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25983 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25991, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25984 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25992, COL_8673266B_223F_4D4F_90D7_231707BB3824#25985 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25993, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25986 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25994]
         +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25975 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25983, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25976 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25984, COL_8673266B_223F_4D4F_90D7_231707BB3824#25977 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25985, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25978 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25986]
            +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25967 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25975, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25968 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25976, COL_8673266B_223F_4D4F_90D7_231707BB3824#25969 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25977, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25970 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25978]
               +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25959 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25967, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25960 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25968, COL_8673266B_223F_4D4F_90D7_231707BB3824#25961 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25969, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25962 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25970]
                  +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25959, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25960, COL_8673266B_223F_4D4F_90D7_231707BB3824#25946 AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25961, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948 AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25962]
                     +- Sort [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 ASC NULLS FIRST], true
                        +- Project [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948]
                           +- Aggregate [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, 1 AS NULL_1#25949, avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868) AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867) AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948]
                              +- Project [COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, COL_33978511_E1D8_4736_9575_50560B51B58E#25874, COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875, str_create(cast(Non Conformité (%) as string)) AS COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908]
                                 +- Project [COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, COL_33978511_E1D8_4736_9575_50560B51B58E#25874, COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875]
                                    +- Filter (COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25772 as timestamp) AS COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25773 as string) AS COL_973FA80D_4B1F_42A5_9828_A56B9848780F#25861, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25774 as string) AS COL_4D986B00_022F_4974_A0B4_7B4D6A5FB8AD#25862, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25775 as string) AS COL_5BFBA440_E926_4923_8836_CE98565A87ED#25863, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25776 as string) AS COL_0233817B_7329_4D71_B049_9FAFD398ADF1#25864, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25777 as string) AS COL_9A9A5D3E_245C_4F4C_A9C2_84FA7F863DE2#25865, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25778 as string) AS COL_BDA60DAB_9763_4B63_92E8_B31DED7AB034#25866, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25779 as double) AS COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25780 as double) AS COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25781 as int) AS COL_49465999_4141_4C03_A21E_B0B20037C8EB#25869, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25782 as int) AS COL_03DE759A_E973_4DB3_AA14_9F8EC1300D31#25870, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25783 as string) AS COL_43A3B58F_83E8_4420_9686_218E5A0908B6#25871, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25784 as string) AS COL_22BAB2E5_9DD0_4A57_927B_F1013F107173#25872, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25785 as string) AS COL_FAF1D11B_E943_40F2_B531_C2569DE051D1#25873, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25786 as double) AS COL_33978511_E1D8_4736_9575_50560B51B58E#25874, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25787 as double) AS COL_BAFC712E_A21C_4E6E_AE91_6623F1ADB56D#25875]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25664 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25772, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25665 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25773, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25666 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25774, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25667 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25775, COL_B2A3110A_EA93_484C_99C3_654566F36027#25668 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25776, COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25777, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25670 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25778, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25779, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25780, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25673 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25781, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25674 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25782, COL_CA314331_595A_479E_B554_2CF73BF8E065#25675 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25783, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25676 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25784, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25677 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25785, COL_96EC1D60_6665_46D3_9518_324889EF63CF#25678 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25786, COL_8E10419E_226F_4098_A129_7AFAAA38B493#25679 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25787, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25680 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25788, COL_38186F06_5370_460A_8844_41809A1AAA16#25681 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25789, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25682 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25790, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25683 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25791, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25684 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25792, COL_57F110A8_C27A_4968_805A_624B0B61FC56#25685 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25793, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25686 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25794, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25687L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25795L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832116
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25664,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25665,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25666,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25667,COL_B2A3110A_EA93_484C_99C3_654566F36027#25668,COL_87B73D01_19C3_4258_8107_533C60810F9B#25669,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25670,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25673,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25674,COL_CA314331_595A_479E_B554_2CF73BF8E065#25675,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25676,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25677,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25678,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25679,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25680,COL_38186F06_5370_460A_8844_41809A1AAA16#25681,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25682,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25683,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25684,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25685,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25686,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25687L,... 12 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Sort [COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 ASC NULLS FIRST], true
      +- Aggregate [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], [COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908 AS COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860 AS COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868) AS COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867) AS COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948]
         +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25664 AS COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671 AS COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672 AS COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, str_create(Non Conformité (%)) AS COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908]
            +- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 <=> Usine de ponte)
               +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25664,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25665,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25666,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25667,COL_B2A3110A_EA93_484C_99C3_654566F36027#25668,COL_87B73D01_19C3_4258_8107_533C60810F9B#25669,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25670,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25673,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25674,COL_CA314331_595A_479E_B554_2CF73BF8E065#25675,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25676,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25677,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25678,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25679,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25680,COL_38186F06_5370_460A_8844_41809A1AAA16#25681,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25682,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25683,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25684,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25685,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25686,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25687L,... 12 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926 ASC NULLS FIRST], output=[COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926,COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927,COL_8673266B_223F_4D4F_90D7_231707BB3824#25946,COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948])
   +- *(2) HashAggregate(keys=[COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], functions=[avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868), avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867)], output=[COL_2A2BCADA_C08D_490E_973C_9B07606DD274#25926, COL_CAB81BC0_F6AF_4211_BAFF_0249CCA50854#25927, COL_8673266B_223F_4D4F_90D7_231707BB3824#25946, COL_E111B86C_D292_4AA0_AF3A_10517B7C4CFA#25948])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 0
            +- Exchange hashpartitioning(COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, 200), true, [id=#5158]
               +- *(1) HashAggregate(keys=[COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860], functions=[partial_avg(COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868), partial_avg(COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867)], output=[COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908, COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, sum#26003, count#26004L, sum#26005, count#26006L])
                  +- *(1) Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25664 AS COL_460C8EA9_3D43_4B83_AC36_BCC1D858DBAD#25860, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671 AS COL_D64D990D_C1DE_475E_97DB_1B4605E72C06#25867, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672 AS COL_C15C1CF2_E970_4720_ACDC_43D7BAE1D8B9#25868, str_create(Non Conformité (%)) AS COL_B5659158_DFB9_4BFD_A590_F48BC3FC29D1#25908]
                     +- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 <=> Usine de ponte)
                        +- *(1) ColumnarToRow
                           +- FileScan parquet [COL_8886263B_787F_402D_99DF_85269A2625C7#25664,COL_87B73D01_19C3_4258_8107_533C60810F9B#25669,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25671,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25672] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#25669 <=> 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_8886263B_787F_402D_99DF_85269A2625C7:timestamp,COL_87B73D01_19C3_4258_8107_533C60810F9...