DC2 - Details for Query 104

Details for Query 104

Submitted Time: 2026/04/29 06:33:17
Duration: 0.9 s
Succeeded Jobs: 171 175 180

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 (3)\n \nduration: total (min, med, max (stageId: taskId))\n15 ms (1 ms, 2 ms, 12 ms (stage 282.0: task 931))"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 2 ms (stage 282.0: task 931)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 282.0: task 931)) 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: 15 shuffle write time total (min, med, max (stageId: taskId)) 132 ms (3 ms, 5 ms, 26 ms (stage 269.0: task 872)) records read: 15 local bytes read: 1152.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)) 600.0 B (40.0 B, 40.0 B, 40.0 B (stage 269.0: task 876)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1152.0 B (75.0 B, 77.0 B, 80.0 B (stage 269.0: task 905))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n242 ms (7 ms, 15 ms, 28 ms (stage 269.0: task 872))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 76 ms (1 ms, 3 ms, 16 ms (stage 269.0: task 910)) peak memory total (min, med, max (stageId: taskId)) 3.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 269.0: task 876)) number of output rows: 15 avg hash probe bucket list iters: 0"]; 8 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 10 ms (0 ms, 0 ms, 5 ms (stage 269.0: task 905)) peak memory total (min, med, max (stageId: taskId)) 3.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 269.0: task 876)) number of output rows: 33 avg hash probe bucket list iters: 0"]; } 9 [labelType="html" label=" CustomShuffleReader "]; 10 [labelType="html" label="Exchange shuffle records written: 314 shuffle write time total (min, med, max (stageId: taskId)) 721 ms (21 ms, 64 ms, 117 ms (stage 262.0: task 831)) records read: 314 local bytes read total (min, med, max (stageId: taskId)) 28.9 KiB (1077.0 B, 2.1 KiB, 2.2 KiB (stage 269.0: task 872)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 269.0: task 876)) remote bytes read: 0.0 B local blocks read: 165 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 17.2 KiB (1456.0 B, 1624.0 B, 1736.0 B (stage 262.0: task 836)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 28.9 KiB (2.4 KiB, 2.7 KiB, 2.9 KiB (stage 262.0: task 836))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n461 ms (17 ms, 40 ms, 71 ms (stage 262.0: task 836))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 232 ms (9 ms, 19 ms, 50 ms (stage 262.0: task 836)) peak memory total (min, med, max (stageId: taskId)) 2.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 262.0: task 819)) number of output rows: 314 avg hash probe bucket list iters: 0"]; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 47,831"]; 15 [labelType="html" label="ColumnarToRow number of output rows: 124,947 number of input batches: 34"]; } 16 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 100 ms (3 ms, 4 ms, 25 ms (stage 262.0: task 842)) 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; 12->10; 13->12; 14->13; 15->14; 16->15; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540,COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25596,COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25597])

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], functions=[count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476), count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)])

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, 200), true, [id=#5075]

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476), partial_count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)])

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, 200), true, [id=#4954]

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476], functions=[partial_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)])

Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522]

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

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280,COL_87B73D01_19C3_4258_8107_533C60810F9B#25283] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 <=> 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_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25589 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25595, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25590 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25596, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25591 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25597]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25583 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25589, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25584 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25590, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25585 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25591]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25577 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25583, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25578 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25584, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25579 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25585]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25571 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25577, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25572 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25578, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25573 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25579]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25571, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25572, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25573]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, 1 AS NULL_1#25562, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25386 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25387 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25388 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25389 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25390 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25391 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25392 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25393 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25394 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25395 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25396 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25397 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25398 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25399 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25400 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25401 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25278 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25386, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25279 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25387, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25388, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25281 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25389, COL_B2A3110A_EA93_484C_99C3_654566F36027#25282 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25390, COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25391, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25284 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25392, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25285 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25393, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25286 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25394, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25287 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25395, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25288 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25396, COL_CA314331_595A_479E_B554_2CF73BF8E065#25289 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25397, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25290 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25398, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25291 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25399, COL_96EC1D60_6665_46D3_9518_324889EF63CF#25292 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25400, COL_8E10419E_226F_4098_A129_7AFAAA38B493#25293 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25401, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25294 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25402, COL_38186F06_5370_460A_8844_41809A1AAA16#25295 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25403, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25296 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25404, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25297 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25405, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25298 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25406, COL_57F110A8_C27A_4968_805A_624B0B61FC56#25299 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25407, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25300 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25408, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25301L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25409L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832118
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25278,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25279,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25281,COL_B2A3110A_EA93_484C_99C3_654566F36027#25282,COL_87B73D01_19C3_4258_8107_533C60810F9B#25283,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25284,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25285,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25286,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25287,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25288,COL_CA314331_595A_479E_B554_2CF73BF8E065#25289,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25290,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25291,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25292,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25293,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25294,COL_38186F06_5370_460A_8844_41809A1AAA16#25295,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25296,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25297,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25298,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25299,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25300,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25301L,... 12 more fields] parquet

== Analyzed Logical Plan ==
COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51: string, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A: string, COL_1B8C7045_C301_45CE_A15C_5D12712EB969: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25589 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25595, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25590 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25596, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25591 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25597]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25583 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25589, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25584 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25590, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25585 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25591]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25577 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25583, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25578 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25584, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25579 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25585]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25571 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25577, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25572 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25578, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25573 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25579]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25571, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25572, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25573]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, 1 AS NULL_1#25562, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25386 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25474, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25387 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25475, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25388 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25389 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#25477, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25390 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25478, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25391 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25479, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25392 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25480, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25393 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25481, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25394 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25482, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25395 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25483, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25396 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25484, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25397 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25485, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25398 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25486, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25399 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25487, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25400 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25488, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25401 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25489]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#25278 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#25386, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25279 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25387, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25388, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25281 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25389, COL_B2A3110A_EA93_484C_99C3_654566F36027#25282 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#25390, COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#25391, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25284 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25392, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25285 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25393, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25286 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25394, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25287 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25395, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25288 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25396, COL_CA314331_595A_479E_B554_2CF73BF8E065#25289 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#25397, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25290 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25398, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25291 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25399, COL_96EC1D60_6665_46D3_9518_324889EF63CF#25292 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25400, COL_8E10419E_226F_4098_A129_7AFAAA38B493#25293 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25401, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25294 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25402, COL_38186F06_5370_460A_8844_41809A1AAA16#25295 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25403, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25296 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25404, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25297 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25405, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25298 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25406, COL_57F110A8_C27A_4968_805A_624B0B61FC56#25299 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25407, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25300 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25408, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25301L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25409L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832118
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25278,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25279,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25281,COL_B2A3110A_EA93_484C_99C3_654566F36027#25282,COL_87B73D01_19C3_4258_8107_533C60810F9B#25283,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25284,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25285,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25286,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25287,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25288,COL_CA314331_595A_479E_B554_2CF73BF8E065#25289,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25290,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25291,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25292,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25293,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25294,COL_38186F06_5370_460A_8844_41809A1AAA16#25295,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25296,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25297,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25298,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25299,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25300,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25301L,... 12 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25596, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25597]
      +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 ASC NULLS FIRST], true
         +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L]
            +- Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522]
               +- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 <=> Usine de ponte)
                  +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#25278,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#25279,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#25281,COL_B2A3110A_EA93_484C_99C3_654566F36027#25282,COL_87B73D01_19C3_4258_8107_533C60810F9B#25283,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#25284,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#25285,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#25286,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#25287,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#25288,COL_CA314331_595A_479E_B554_2CF73BF8E065#25289,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#25290,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25291,COL_96EC1D60_6665_46D3_9518_324889EF63CF#25292,COL_8E10419E_226F_4098_A129_7AFAAA38B493#25293,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25294,COL_38186F06_5370_460A_8844_41809A1AAA16#25295,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25296,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25297,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25298,COL_57F110A8_C27A_4968_805A_624B0B61FC56#25299,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25300,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25301L,... 12 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540,COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25596,COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25597])
   +- *(3) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], functions=[count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476), count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25540, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25558L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25561L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 1
            +- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, 200), true, [id=#5075]
               +- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476), partial_count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, count#25602L, count#25605L])
                  +- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, count#25602L])
                     +- CustomShuffleReader coalesced
                        +- ShuffleQueryStage 0
                           +- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, 200), true, [id=#4954]
                              +- *(1) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476], functions=[partial_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, count#25602L])
                                 +- *(1) Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25476, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25522]
                                    +- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 <=> Usine de ponte)
                                       +- *(1) ColumnarToRow
                                          +- FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#25280,COL_87B73D01_19C3_4258_8107_533C60810F9B#25283] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#25283 <=> 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...