DC2 - Details for Query 102

Details for Query 102

Submitted Time: 2026/04/29 06:33:16
Duration: 1 s
Succeeded Jobs: 169 174 178

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))\n19 ms (2 ms, 3 ms, 14 ms (stage 276.0: task 919))"; 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 276.0: task 919)) peak memory total (min, med, max (stageId: taskId)) 64.8 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 276.0: task 919)) 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)) 246 ms (3 ms, 12 ms, 41 ms (stage 267.0: task 863)) 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 267.0: task 861)) 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 267.0: task 871))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n2.4 s (10 ms, 203 ms, 217 ms (stage 267.0: task 862))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 888 ms (1 ms, 63 ms, 100 ms (stage 267.0: task 866)) peak memory total (min, med, max (stageId: taskId)) 3.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 267.0: task 861)) 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)) 14 ms (0 ms, 0 ms, 11 ms (stage 267.0: task 861)) peak memory total (min, med, max (stageId: taskId)) 3.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 267.0: task 861)) 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)) 674 ms (23 ms, 52 ms, 117 ms (stage 259.0: task 813)) 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 267.0: task 859)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 267.0: task 861)) 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 259.0: task 813)) 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 259.0: task 813))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n791 ms (17 ms, 67 ms, 129 ms (stage 259.0: task 799))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 296 ms (9 ms, 33 ms, 46 ms (stage 259.0: task 826)) peak memory total (min, med, max (stageId: taskId)) 2.8 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 259.0: task 800)) 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)) 133 ms (3 ms, 10 ms, 42 ms (stage 259.0: task 826)) 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#25181 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181,COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25243,COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25244])

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], functions=[count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089), count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)])

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, 200), true, [id=#5042]

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089), partial_count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)])

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, 200), true, [id=#4863]

HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089], functions=[partial_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)])

Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155]

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

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826,COL_87B73D01_19C3_4258_8107_533C60810F9B#24829] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 <=> 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#25236 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25242, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25237 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25243, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25238 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25244]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25230 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25236, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25231 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25237, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25232 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25238]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25222 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25230, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25223 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25231, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25224 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25232]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25216 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25222, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25217 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25223, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25218 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25224]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25216, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25217, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25218]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, 1 AS NULL_1#25207, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24987 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24988 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24989 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24990 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24991 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24992 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24993 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24994 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24995 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24996 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24997 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24998 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24999 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25000 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25001 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25002 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#24824 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24987, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24825 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24988, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24989, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24827 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24990, COL_B2A3110A_EA93_484C_99C3_654566F36027#24828 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24991, COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24992, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24830 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24993, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24831 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24994, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24832 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24995, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24833 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24996, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24834 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24997, COL_CA314331_595A_479E_B554_2CF73BF8E065#24835 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24998, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24836 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24999, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24837 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25000, COL_96EC1D60_6665_46D3_9518_324889EF63CF#24838 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25001, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24839 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25002, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24840 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25003, COL_38186F06_5370_460A_8844_41809A1AAA16#24841 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25004, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24842 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25005, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24843 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25006, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24844 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25007, COL_57F110A8_C27A_4968_805A_624B0B61FC56#24845 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25008, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24846 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25009, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24847L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25010L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832114
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24824,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24825,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24827,COL_B2A3110A_EA93_484C_99C3_654566F36027#24828,COL_87B73D01_19C3_4258_8107_533C60810F9B#24829,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24830,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24831,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24832,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24833,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24834,COL_CA314331_595A_479E_B554_2CF73BF8E065#24835,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24836,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24837,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24838,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24839,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24840,COL_38186F06_5370_460A_8844_41809A1AAA16#24841,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24842,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24843,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24844,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24845,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24846,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24847L,... 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#25236 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25242, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25237 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25243, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25238 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25244]
         +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25230 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25236, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25231 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25237, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25232 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25238]
            +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25222 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25230, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25223 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25231, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25224 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25232]
               +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25216 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25222, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25217 AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25223, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25218 AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25224]
                  +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25216, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25217, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25218]
                     +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 ASC NULLS FIRST], true
                        +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L]
                           +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, 1 AS NULL_1#25207, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L]
                              +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155]
                                 +- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102]
                                    +- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092 <=> cast(Usine de ponte as string))
                                       +- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24987 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#25087, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24988 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#25088, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24989 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24990 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#25090, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24991 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#25091, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24992 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#25092, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24993 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#25093, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24994 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#25094, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24995 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#25095, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24996 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#25096, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24997 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#25097, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24998 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#25098, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24999 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#25099, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25000 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#25100, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25001 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#25101, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25002 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#25102]
                                          +- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#24824 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24987, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24825 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24988, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24989, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24827 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24990, COL_B2A3110A_EA93_484C_99C3_654566F36027#24828 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24991, COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24992, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24830 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24993, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24831 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24994, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24832 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24995, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24833 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24996, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24834 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24997, COL_CA314331_595A_479E_B554_2CF73BF8E065#24835 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24998, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24836 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24999, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24837 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#25000, COL_96EC1D60_6665_46D3_9518_324889EF63CF#24838 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#25001, COL_8E10419E_226F_4098_A129_7AFAAA38B493#24839 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#25002, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24840 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#25003, COL_38186F06_5370_460A_8844_41809A1AAA16#24841 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#25004, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24842 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#25005, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24843 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#25006, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24844 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#25007, COL_57F110A8_C27A_4968_805A_624B0B61FC56#24845 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#25008, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24846 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#25009, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24847L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#25010L, ... 12 more fields]
                                             +- SubqueryAlias CONSOLIDATED_DA_37832114
                                                +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24824,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24825,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24827,COL_B2A3110A_EA93_484C_99C3_654566F36027#24828,COL_87B73D01_19C3_4258_8107_533C60810F9B#24829,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24830,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24831,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24832,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24833,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24834,COL_CA314331_595A_479E_B554_2CF73BF8E065#24835,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24836,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24837,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24838,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24839,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24840,COL_38186F06_5370_460A_8844_41809A1AAA16#24841,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24842,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24843,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24844,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24845,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24846,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24847L,... 12 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, bigint_to_str(COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25243, bigint_to_str(COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25244]
      +- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 ASC NULLS FIRST], true
         +- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089) AS COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L]
            +- Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155]
               +- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 <=> Usine de ponte)
                  +- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#24824,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24825,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24827,COL_B2A3110A_EA93_484C_99C3_654566F36027#24828,COL_87B73D01_19C3_4258_8107_533C60810F9B#24829,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24830,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24831,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24832,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24833,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24834,COL_CA314331_595A_479E_B554_2CF73BF8E065#24835,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24836,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24837,COL_96EC1D60_6665_46D3_9518_324889EF63CF#24838,COL_8E10419E_226F_4098_A129_7AFAAA38B493#24839,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24840,COL_38186F06_5370_460A_8844_41809A1AAA16#24841,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24842,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24843,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24844,COL_57F110A8_C27A_4968_805A_624B0B61FC56#24845,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24846,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24847L,... 12 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181,COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25243,COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25244])
   +- *(3) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], functions=[count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089), count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#25181, COL_C6463DB1_21A8_48FC_932E_6FD5DF27E57A#25199L, COL_1B8C7045_C301_45CE_A15C_5D12712EB969#25206L])
      +- CustomShuffleReader coalesced
         +- ShuffleQueryStage 1
            +- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, 200), true, [id=#5042]
               +- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089), partial_count(distinct COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, count#25257L, count#25260L])
                  +- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089], functions=[merge_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, count#25257L])
                     +- CustomShuffleReader coalesced
                        +- ShuffleQueryStage 0
                           +- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, 200), true, [id=#4863]
                              +- *(1) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089], functions=[partial_count(COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089)], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, count#25257L])
                                 +- *(1) Project [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826 AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#25089, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#25155]
                                    +- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 <=> Usine de ponte)
                                       +- *(1) ColumnarToRow
                                          +- FileScan parquet [COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24826,COL_87B73D01_19C3_4258_8107_533C60810F9B#24829] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#24829 <=> 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...