digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
}
4 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster5 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 63 ms";
6 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
7 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 767.0 B<br>number of coalesced partitions: 1"];
8 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 16<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 16<br>local bytes read: 719.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 1408.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 719.0 B"];
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 25 ms";
10 [labelType="html" label="<br><b>Project</b><br><br>"];
11 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 0 ms<br>peak memory: 16.3 MiB<br>number of output rows: 16<br>number of sort fallback tasks: 0<br>avg hash probes per key: 1"];
}
12 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 1228.0 B<br>number of coalesced partitions: 1"];
13 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 16<br>local merged chunks fetched: 0<br>shuffle write time: 2 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 16<br>local bytes read: 1167.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 1024.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 1167.0 B"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 115 ms";
15 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 42 ms<br>peak memory: 256.0 KiB<br>number of output rows: 16<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
16 [labelType="html" label="<br><b>Project</b><br><br>"];
17 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 5,653<br>number of input batches: 2"];
}
18 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 6 ms<br>metadata time: 0 ms<br>size of files read: 114.9 KiB<br>number of output rows: 5,653"];
2->0;
3->2;
4->3;
6->4;
7->6;
8->7;
10->8;
11->10;
12->11;
13->12;
15->13;
16->15;
17->16;
18->17;
}
19
AdaptiveSparkPlan isFinalPlan=true
Project [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427, str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) AS COL_951CF306_A7AA_42C3_9807_4718EE394957#135471, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
Filter ((str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) <=> O) AND CASE WHEN isnull(StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025)) THEN false ELSE StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025) END)
WholeStageCodegen (4)
Window [max(COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205) windowspecdefinition(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427], [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203], [1 DESC NULLS LAST]
Sort [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (3)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 10), ENSURE_REQUIREMENTS, [plan_id=12930]
Project [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, str_join(array(bigint_to_str(COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L), Erreur(s)), ) AS COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
HashAggregate(keys=[COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979], functions=[sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)])
WholeStageCodegen (2)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, 10), ENSURE_REQUIREMENTS, [plan_id=12757]
HashAggregate(keys=[COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979], functions=[partial_sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)])
Project [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565 AS COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573 AS COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581 AS COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, str_to_integer(str_join(array(str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4), str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, RIGHT, 2)), )) AS COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4) AS COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565,COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573,COL_5D26DFDD_1640_42A4_838E_70549966012C#134581] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/1_Q_1_EG_SYNTHE_307721], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_029B5EA0_1AA9_450A_9A52_E2C917221676:int,COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9:int,...
== Physical Plan ==
AdaptiveSparkPlan (28)
+- == Final Plan ==
* Project (16)
+- * Filter (15)
+- Window (14)
+- * Sort (13)
+- AQEShuffleRead (12)
+- ShuffleQueryStage (11), Statistics(sizeInBytes=1408.0 B, rowCount=16)
+- Exchange (10)
+- * Project (9)
+- * HashAggregate (8)
+- AQEShuffleRead (7)
+- ShuffleQueryStage (6), Statistics(sizeInBytes=1024.0 B, rowCount=16)
+- Exchange (5)
+- * HashAggregate (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
CollectLimit (27)
+- Project (26)
+- Filter (25)
+- Window (24)
+- Sort (23)
+- Exchange (22)
+- Project (21)
+- HashAggregate (20)
+- Exchange (19)
+- HashAggregate (18)
+- Project (17)
+- Scan parquet (1)
(1) Scan parquet
Output [3]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/1_Q_1_EG_SYNTHE_307721]
ReadSchema: struct<COL_029B5EA0_1AA9_450A_9A52_E2C917221676:int,COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9:int,COL_5D26DFDD_1640_42A4_838E_70549966012C:string>
(2) ColumnarToRow [codegen id : 1]
Input [3]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581]
(3) Project [codegen id : 1]
Output [5]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565 AS COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573 AS COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581 AS COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, str_to_integer(str_join(array(str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4), str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, RIGHT, 2)), )) AS COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4) AS COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144]
Input [3]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581]
(4) HashAggregate [codegen id : 1]
Input [5]: [COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144]
Keys [4]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979]
Functions [1]: [partial_sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)]
Aggregate Attributes [1]: [sum#135964L]
Results [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
(5) Exchange
Input [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Arguments: hashpartitioning(COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, 10), ENSURE_REQUIREMENTS, [plan_id=12757]
(6) ShuffleQueryStage
Output [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Arguments: 0
(7) AQEShuffleRead
Input [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Arguments: coalesced
(8) HashAggregate [codegen id : 2]
Input [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Keys [4]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979]
Functions [1]: [sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)]
Aggregate Attributes [1]: [sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)#135236L]
Results [5]: [coalesce(sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)#135236L, 0) AS COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814 AS COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830 AS COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979 AS COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144 AS COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
(9) Project [codegen id : 2]
Output [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, str_join(array(bigint_to_str(COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L), Erreur(s)), ) AS COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Input [5]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
(10) Exchange
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: hashpartitioning(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 10), ENSURE_REQUIREMENTS, [plan_id=12930]
(11) ShuffleQueryStage
Output [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: 1
(12) AQEShuffleRead
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: coalesced
(13) Sort [codegen id : 3]
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(14) Window
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: [max(COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205) windowspecdefinition(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427], [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203], [1 DESC NULLS LAST]
(15) Filter [codegen id : 4]
Input [7]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427]
Condition : ((str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) <=> O) AND CASE WHEN isnull(StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025)) THEN false ELSE StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025) END)
(16) Project [codegen id : 4]
Output [8]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427, str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) AS COL_951CF306_A7AA_42C3_9807_4718EE394957#135471, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
Input [7]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427]
(17) Project
Output [5]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565 AS COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573 AS COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581 AS COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, str_to_integer(str_join(array(str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4), str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, RIGHT, 2)), )) AS COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#134581, LEFT, 4) AS COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144]
Input [3]: [COL_029B5EA0_1AA9_450A_9A52_E2C917221676#134565, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#134573, COL_5D26DFDD_1640_42A4_838E_70549966012C#134581]
(18) HashAggregate
Input [5]: [COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144]
Keys [4]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979]
Functions [1]: [partial_sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)]
Aggregate Attributes [1]: [sum#135964L]
Results [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
(19) Exchange
Input [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Arguments: hashpartitioning(COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, 10), ENSURE_REQUIREMENTS, [plan_id=12725]
(20) HashAggregate
Input [5]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979, sum#135965L]
Keys [4]: [COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979]
Functions [1]: [sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)]
Aggregate Attributes [1]: [sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)#135236L]
Results [5]: [coalesce(sum(COL_808802E0_6BC8_40FC_BAB8_EF4F6A485F10#134822)#135236L, 0) AS COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_1B071B69_CD52_410C_B8BD_82FD9E52ACC1#134814 AS COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C0D490F5_8DFD_47F9_A525_730379B78727#134830 AS COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_90C93FEB_9352_444D_95F1_6985E2D7700C#134979 AS COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_9CED3D62_2D50_4D54_83E8_A2553047F162#135144 AS COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
(21) Project
Output [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, str_join(array(bigint_to_str(COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L), Erreur(s)), ) AS COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Input [5]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
(22) Exchange
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: hashpartitioning(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 10), ENSURE_REQUIREMENTS, [plan_id=12729]
(23) Sort
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(24) Window
Input [6]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370]
Arguments: [max(COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205) windowspecdefinition(COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427], [COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203], [1 DESC NULLS LAST]
(25) Filter
Input [7]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427]
Condition : ((str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) <=> O) AND CASE WHEN isnull(StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025)) THEN false ELSE StartsWith(COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, 2025) END)
(26) Project
Output [8]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427, str_if_with_rule((COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205 <=> COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427), O, N) AS COL_951CF306_A7AA_42C3_9807_4718EE394957#135471, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
Input [7]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427]
(27) CollectLimit
Input [8]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427, COL_951CF306_A7AA_42C3_9807_4718EE394957#135471, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
Arguments: 500000
(28) AdaptiveSparkPlan
Output [8]: [COL_167D2804_D24F_4418_9978_BA71DE01A748#135301L, COL_7003A00C_B213_4260_A136_9B5A1EC22EAA#135370, COL_234287AB_3AA7_44CC_8633_F1D4CEE11186#135203, COL_C515F3BA_DBC2_4279_B4B2_59FEDB821871#135204, COL_7B35A171_E620_4D3B_94A8_81614E52B191#135205, COL_C0D5FBCA_6351_46C6_A9ED_E13F43A092E2#135427, COL_951CF306_A7AA_42C3_9807_4718EE394957#135471, COL_3BCDCA51_91FE_4BD8_8874_3DFE6388080C#135202]
Arguments: isFinalPlan=true