EVAL1_SPC1 - Details for Query 54

Submitted Time: 2026/07/27 12:12:50
Duration: 1 s
Succeeded Jobs: 50 51 54

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 36 ms"; 5 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 304.0 B number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 9 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 9 local bytes read: 299.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 504.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 299.0 B"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 34 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 9"]; } 11 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 138 ms"; 13 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; 14 [labelType="html" label=" Project "]; } 15 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 134 ms"; 17 [labelType="html" label=" Project "]; } 18 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 381 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 762.0 B number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 17 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 17 local bytes read: 748.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1224.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 748.0 B"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 60 ms"; 24 [labelType="html" label=" Project "]; } 25 [labelType="html" label="Scan csv number of output rows: 17 number of files read: 1 metadata time: 0 ms size of files read: 613.0 B"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 11->10; 13->11; 14->13; 15->14; 17->15; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]

WholeStageCodegen (7)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725], [1], [1 DESC NULLS LAST]

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=1331]

Project [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, date_if_with_rule(CASE WHEN isnull(((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999))) THEN false ELSE ((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999)) END, null, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436) AS COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]

Filter (COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530 <=> 1)

WholeStageCodegen (5)

Window [min(COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, max(COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, row_number() windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [1 DESC NULLS LAST]

Sort [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Project [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]

WholeStageCodegen (4)

Window [last(COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, true) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

Project [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_if_with_rule((NOT (COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948 <=> COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866) OR NOT (date_diff(DAY, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007) <=> 1)), COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, null) AS COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, date_if_with_rule(isnull(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881), str_to_datez(01/01/2100, dd/MM/yyyy, Europe/Paris, fr_FR), COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881) AS COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]

WholeStageCodegen (3)

Window [lag(COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948, lag(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

Sort [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, 10), ENSURE_REQUIREMENTS, [plan_id=1118]

Project [No ligne#4788 AS COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, MMAT#4789 AS COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, ETP#4790 AS COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, str_to_datez(DDEB#4791, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_to_datez(DFIN#4792, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]

WholeStageCodegen (1)

FileScan csv [No ligne#4788,MMAT#4789,ETP#4790,DDEB#4791,DFIN#4792] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/IFPEN_23381/current/AVW_DB_TEMPS_..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<No ligne:string,MMAT:string,ETP:string,DDEB:string,DFIN:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (37)
+- == Final Plan ==
   * Project (20)
   +- Window (19)
      +- * Sort (18)
         +- AQEShuffleRead (17)
            +- ShuffleQueryStage (16), Statistics(sizeInBytes=504.0 B, rowCount=9)
               +- Exchange (15)
                  +- * Project (14)
                     +- * Filter (13)
                        +- Window (12)
                           +- * Sort (11)
                              +- * Project (10)
                                 +- Window (9)
                                    +- * Project (8)
                                       +- Window (7)
                                          +- * Sort (6)
                                             +- AQEShuffleRead (5)
                                                +- ShuffleQueryStage (4), Statistics(sizeInBytes=1224.0 B, rowCount=17)
                                                   +- Exchange (3)
                                                      +- * Project (2)
                                                         +- Scan csv  (1)
+- == Initial Plan ==
   CollectLimit (36)
   +- Project (35)
      +- Window (34)
         +- Sort (33)
            +- Exchange (32)
               +- Project (31)
                  +- Filter (30)
                     +- Window (29)
                        +- Sort (28)
                           +- Project (27)
                              +- Window (26)
                                 +- Project (25)
                                    +- Window (24)
                                       +- Sort (23)
                                          +- Exchange (22)
                                             +- Project (21)
                                                +- Scan csv  (1)


(1) Scan csv 
Output [5]: [No ligne#4788, MMAT#4789, ETP#4790, DDEB#4791, DFIN#4792]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/IFPEN_23381/current/AVW_DB_TEMPS_TRAVAIL.csv]
ReadSchema: struct<No ligne:string,MMAT:string,ETP:string,DDEB:string,DFIN:string>

(2) Project [codegen id : 1]
Output [5]: [No ligne#4788 AS COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, MMAT#4789 AS COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, ETP#4790 AS COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, str_to_datez(DDEB#4791, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_to_datez(DFIN#4792, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Input [5]: [No ligne#4788, MMAT#4789, ETP#4790, DDEB#4791, DFIN#4792]

(3) Exchange
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: hashpartitioning(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, 10), ENSURE_REQUIREMENTS, [plan_id=1118]

(4) ShuffleQueryStage
Output [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: 0

(5) AQEShuffleRead
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: coalesced

(6) Sort [codegen id : 2]
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST], false, 0

(7) Window
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: [lag(COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948, lag(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

(8) Project [codegen id : 3]
Output [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_if_with_rule((NOT (COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948 <=> COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866) OR NOT (date_diff(DAY, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007) <=> 1)), COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, null) AS COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, date_if_with_rule(isnull(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881), str_to_datez(01/01/2100, dd/MM/yyyy, Europe/Paris, fr_FR), COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881) AS COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Input [7]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881, COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948, COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007]

(9) Window
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [last(COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, true) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

(10) Project [codegen id : 4]
Output [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Input [6]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209]

(11) Sort [codegen id : 4]
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(12) Window
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [min(COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, max(COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, row_number() windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [1 DESC NULLS LAST]

(13) Filter [codegen id : 5]
Input [8]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530]
Condition : (COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530 <=> 1)

(14) Project [codegen id : 5]
Output [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, date_if_with_rule(CASE WHEN isnull(((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999))) THEN false ELSE ((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999)) END, null, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436) AS COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Input [8]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530]

(15) Exchange
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=1331]

(16) ShuffleQueryStage
Output [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: 1

(17) AQEShuffleRead
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: coalesced

(18) Sort [codegen id : 6]
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725], [1], [1 DESC NULLS LAST]

(20) Project [codegen id : 7]
Output [5]: [COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703, COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725]

(21) Project
Output [5]: [No ligne#4788 AS COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, MMAT#4789 AS COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, ETP#4790 AS COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, str_to_datez(DDEB#4791, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_to_datez(DFIN#4792, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Input [5]: [No ligne#4788, MMAT#4789, ETP#4790, DDEB#4791, DFIN#4792]

(22) Exchange
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: hashpartitioning(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, 10), ENSURE_REQUIREMENTS, [plan_id=1026]

(23) Sort
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST], false, 0

(24) Window
Input [5]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881]
Arguments: [lag(COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948, lag(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881, -1, null) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

(25) Project
Output [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, str_if_with_rule((NOT (COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948 <=> COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866) OR NOT (date_diff(DAY, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007) <=> 1)), COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, null) AS COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, date_if_with_rule(isnull(COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881), str_to_datez(01/01/2100, dd/MM/yyyy, Europe/Paris, fr_FR), COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881) AS COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Input [7]: [COL_21421409_025C_4C9D_808E_1BBDEE4BEB7A#4864, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_E98066C8_DC97_4A1F_8313_F49AB9504593#4881, COL_BD2B8E9B_E291_4122_9583_89B55048E0F6#4948, COL_BFB362C1_6BA9_4A52_8F3F_E9A1CD765546#5007]

(26) Window
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [last(COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, true) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865], [COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874 ASC NULLS LAST]

(27) Project
Output [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Input [6]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_5E6DC374_E37E_4131_8AE6_4BA6BDE04FEB#5176, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209]

(28) Sort
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865 ASC NULLS FIRST, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178]
Arguments: [min(COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, max(COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178) windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, row_number() windowspecdefinition(COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530], [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209], [1 DESC NULLS LAST]

(30) Filter
Input [8]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530]
Condition : (COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530 <=> 1)

(31) Project
Output [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, date_if_with_rule(CASE WHEN isnull(((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999))) THEN false ELSE ((COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 >= 2099-12-31 23:00:00) AND (COL_7392ACCE_4558_452B_8D54_F6402C780323#5436 <= 2099-12-31 23:00:00.999999)) END, null, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436) AS COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Input [8]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_6C94855E_C159_4F6C_84D9_BDE0A104240F#4874, COL_7268252A_B026_4498_AA4C_F471A4DA150D#5209, COL_E03084D9_2C2F_49CC_9C75_BE8C0662503E#5178, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_7392ACCE_4558_452B_8D54_F6402C780323#5436, COL_194CC6F8_DE65_4416_9E61_6B057D1D15C7#5530]

(32) Exchange
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=1038]

(33) Sort
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(34) Window
Input [4]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725], [1], [1 DESC NULLS LAST]

(35) Project
Output [5]: [COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Input [5]: [COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703, COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725]

(36) CollectLimit
Input [5]: [COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: 1500

(37) AdaptiveSparkPlan
Output [5]: [COL_CAC5FBE3_6E07_4599_AE9E_7108C9CE34FA#5725, COL_8200F68A_19E7_411E_8D8B_739E2C5CE4A1#4865, COL_584464CD_E9B5_43FD_9EFF_A6F25F111E1E#4866, COL_FB71DC41_B2C4_420D_B368_E14B3C156811#5350, COL_BB89E6FA_93EF_4A3D_8EA3_6F17919B534A#5703]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet