SP1 - Details for Query 400

Submitted Time: 2026/02/23 14:35:28
Duration: 1.0 s
Succeeded Jobs: 537 549

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: 10 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="Filter number of output rows: 37"]; } 7 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 192 ms"; 9 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 10 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 13.6 KiB number of coalesced partitions: 1"]; 11 [labelType="html" label="Exchange shuffle records written: 115 local merged chunks fetched: 0 shuffle write time: 0 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: 115 local bytes read: 13.1 KiB 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: 77.3 KiB 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: 13.1 KiB"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 31 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 115"]; 15 [labelType="html" label="ColumnarToRow number of output rows: 5,653 number of input batches: 2"]; } 16 [labelType="html" label="Scan parquet number of files read: 1 scan time: 6 ms metadata time: 0 ms size of files read: 114.9 KiB number of output rows: 5,653"]; 1->0; 3->1; 4->3; 5->4; 6->5; 7->6; 9->7; 10->9; 11->10; 13->11; 14->13; 15->14; 16->15; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169 ASC NULLS FIRST,COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177 ASC NULLS FIRST], output=[COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167,COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168,COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169,COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170,COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171,COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172,COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475,COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174,COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175,COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176,COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177,COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178,COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481,COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180,COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483,COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182,COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183,COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184,COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185,COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186,COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187,COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188,COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189,COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283,... 4 more fields])

Project [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, ... 4 more fields]

Project [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, coalesce(COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, Non Renseigné) AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, round(COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, 2) AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, round(COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, 2) AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, ... 2 more fields]

Filter CASE WHEN isnull(StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025)) THEN false ELSE StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025) END

WholeStageCodegen (3)

Window [max(COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283) windowspecdefinition(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363], [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169], [1 DESC NULLS LAST]

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

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 10), ENSURE_REQUIREMENTS, [plan_id=11703]

Project [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903 AS COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904 AS COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905 AS COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906 AS COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907 AS COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 AS COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909 AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910 AS COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911 AS COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912 AS COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913 AS COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914 AS COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915 AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916 AS COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_00A9551A_5209_4871_86E4_870013D4059F#129917 AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918 AS COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919 AS COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920 AS COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921 AS COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923 AS COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925 AS COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922 AS COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926 AS COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, str_to_integer(str_remove_extend(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, [-,])) AS COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, LEFT, 4) AS COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]

Filter (COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 <=> 350000055)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903,COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904,COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905,COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906,COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907,COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908,COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909,COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910,COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911,COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912,COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913,COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914,COL_D633617F_A411_4343_ACDE_363567E8DE82#129915,COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916,COL_00A9551A_5209_4871_86E4_870013D4059F#129917,COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918,COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919,COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920,COL_5D26DFDD_1640_42A4_838E_70549966012C#129921,COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922,COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923,COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925,COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926] Batched: true, DataFilters: [(COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 <=> 350000055)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/1_Q_1_EG_SYNTHE_307721], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_D2FA9479_01B0_462A_8710_BB5B07B47285,350000055)], ReadSchema: struct<COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8:string,COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (25)
+- == Final Plan ==
   TakeOrderedAndProject (14)
   +- * Project (13)
      +- * Project (12)
         +- * Project (11)
            +- * Filter (10)
               +- Window (9)
                  +- * Sort (8)
                     +- AQEShuffleRead (7)
                        +- ShuffleQueryStage (6), Statistics(sizeInBytes=77.3 KiB, rowCount=115)
                           +- Exchange (5)
                              +- * Project (4)
                                 +- * Filter (3)
                                    +- * ColumnarToRow (2)
                                       +- Scan parquet  (1)
+- == Initial Plan ==
   TakeOrderedAndProject (24)
   +- Project (23)
      +- Project (22)
         +- Project (21)
            +- Filter (20)
               +- Window (19)
                  +- Sort (18)
                     +- Exchange (17)
                        +- Project (16)
                           +- Filter (15)
                              +- Scan parquet  (1)


(1) Scan parquet 
Output [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/1_Q_1_EG_SYNTHE_307721]
PushedFilters: [EqualNullSafe(COL_D2FA9479_01B0_462A_8710_BB5B07B47285,350000055)]
ReadSchema: struct<COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8:string,COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938:string,COL_029B5EA0_1AA9_450A_9A52_E2C917221676:int,COL_400AB845_98F4_48CB_9020_98DDDFA8DD44:int,COL_F23820F4_F2B5_4379_8BFA_63260594431D:string,COL_D2FA9479_01B0_462A_8710_BB5B07B47285:string,COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03:string,COL_106163BE_ECDA_44FE_B9A9_99AFD129D534:string,COL_35617F1A_EA2A_4241_9850_A632D8D960D1:string,COL_51BDD38C_C887_4526_A34A_D5433B9826E5:int,COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9:int,COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0:string,COL_D633617F_A411_4343_ACDE_363567E8DE82:double,COL_23D87AEF_0186_4907_933B_DC4D0990FA34:int,COL_00A9551A_5209_4871_86E4_870013D4059F:double,COL_5C39DB21_9650_40FA_B782_EC3D3D62790B:string,COL_16AEAB97_2666_4488_AFF6_5610F75E9798:string,COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9:string,COL_5D26DFDD_1640_42A4_838E_70549966012C:string,COL_15A5E13C_ECD3_4583_9032_76A26337A7E3:string,COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED:string,COL_B6DC0140_BE35_4663_A985_E2549973E2CC:string,COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6:string>

(2) ColumnarToRow [codegen id : 1]
Input [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]

(3) Filter [codegen id : 1]
Input [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]
Condition : (COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 <=> 350000055)

(4) Project [codegen id : 1]
Output [25]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903 AS COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904 AS COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905 AS COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906 AS COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907 AS COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 AS COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909 AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910 AS COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911 AS COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912 AS COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913 AS COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914 AS COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915 AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916 AS COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_00A9551A_5209_4871_86E4_870013D4059F#129917 AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918 AS COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919 AS COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920 AS COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921 AS COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923 AS COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925 AS COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922 AS COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926 AS COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, str_to_integer(str_remove_extend(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, [-,])) AS COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, LEFT, 4) AS COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]

(5) Exchange
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: hashpartitioning(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 10), ENSURE_REQUIREMENTS, [plan_id=11703]

(6) ShuffleQueryStage
Output [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: 0

(7) AQEShuffleRead
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: coalesced

(8) Sort [codegen id : 2]
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(9) Window
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: [max(COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283) windowspecdefinition(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363], [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169], [1 DESC NULLS LAST]

(10) Filter [codegen id : 3]
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363]
Condition : CASE WHEN isnull(StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025)) THEN false ELSE StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025) END

(11) Project [codegen id : 3]
Output [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, coalesce(COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, Non Renseigné) AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, round(COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, 2) AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, round(COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, 2) AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, int_to_str(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363) AS COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363]

(12) Project [codegen id : 3]
Output [27]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, str_join(array(str_extract(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, LEFT, 4), str_extract(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, RIGHT, 2)), -) AS COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]

(13) Project [codegen id : 3]
Output [28]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, str_if_with_rule((COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628 <=> COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185), O, N) AS COL_D2979EFC_6211_4ED5_AA64_5B8380AFB367#130657]
Input [27]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]

(14) TakeOrderedAndProject
Input [28]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_D2979EFC_6211_4ED5_AA64_5B8380AFB367#130657]
Arguments: 500000, [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169 ASC NULLS FIRST, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177 ASC NULLS FIRST], [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, ... 4 more fields]

(15) Filter
Input [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]
Condition : (COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 <=> 350000055)

(16) Project
Output [25]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903 AS COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904 AS COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905 AS COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906 AS COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907 AS COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908 AS COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909 AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910 AS COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911 AS COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912 AS COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913 AS COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914 AS COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915 AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916 AS COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_00A9551A_5209_4871_86E4_870013D4059F#129917 AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918 AS COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919 AS COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920 AS COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921 AS COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923 AS COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925 AS COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922 AS COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926 AS COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, str_to_integer(str_remove_extend(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, [-,])) AS COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, str_extract(COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, LEFT, 4) AS COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [23]: [COL_4A3F18F8_5464_4FFD_A43A_152BADE4E7F8#129903, COL_0236C1E8_F018_4DFD_8BB4_A0E5D1F4E938#129904, COL_029B5EA0_1AA9_450A_9A52_E2C917221676#129905, COL_400AB845_98F4_48CB_9020_98DDDFA8DD44#129906, COL_F23820F4_F2B5_4379_8BFA_63260594431D#129907, COL_D2FA9479_01B0_462A_8710_BB5B07B47285#129908, COL_9F1E31CE_6CE2_4F64_949A_373D1688DD03#129909, COL_106163BE_ECDA_44FE_B9A9_99AFD129D534#129910, COL_35617F1A_EA2A_4241_9850_A632D8D960D1#129911, COL_51BDD38C_C887_4526_A34A_D5433B9826E5#129912, COL_235A9C7C_BAEB_41E7_A41F_FD2A0A0717F9#129913, COL_5853B8DD_4A6A_48BB_B375_1C447D038DF0#129914, COL_D633617F_A411_4343_ACDE_363567E8DE82#129915, COL_23D87AEF_0186_4907_933B_DC4D0990FA34#129916, COL_00A9551A_5209_4871_86E4_870013D4059F#129917, COL_5C39DB21_9650_40FA_B782_EC3D3D62790B#129918, COL_16AEAB97_2666_4488_AFF6_5610F75E9798#129919, COL_F75C7A6C_1D31_469B_987F_CCF657FEDFC9#129920, COL_5D26DFDD_1640_42A4_838E_70549966012C#129921, COL_15A5E13C_ECD3_4583_9032_76A26337A7E3#129922, COL_1E4A89DB_0FDE_4F82_8105_B68A428275ED#129923, COL_B6DC0140_BE35_4663_A985_E2549973E2CC#129925, COL_3BB493CB_C728_4BF2_B02A_7715D4D006A6#129926]

(17) Exchange
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: hashpartitioning(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 10), ENSURE_REQUIREMENTS, [plan_id=11679]

(18) Sort
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [25]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: [max(COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283) windowspecdefinition(COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363], [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169], [1 DESC NULLS LAST]

(20) Filter
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363]
Condition : CASE WHEN isnull(StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025)) THEN false ELSE StartsWith(COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, 2025) END

(21) Project
Output [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, coalesce(COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, Non Renseigné) AS COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, round(COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, 2) AS COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, round(COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, 2) AS COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, int_to_str(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363) AS COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130173, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130179, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130181, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130363]

(22) Project
Output [27]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, str_join(array(str_extract(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, LEFT, 4), str_extract(COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, RIGHT, 2)), -) AS COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Input [26]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]

(23) Project
Output [28]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, str_if_with_rule((COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628 <=> COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185), O, N) AS COL_D2979EFC_6211_4ED5_AA64_5B8380AFB367#130657]
Input [27]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]

(24) TakeOrderedAndProject
Input [28]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308, COL_D2979EFC_6211_4ED5_AA64_5B8380AFB367#130657]
Arguments: 500000, [COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169 ASC NULLS FIRST, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177 ASC NULLS FIRST], [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, ... 4 more fields]

(25) AdaptiveSparkPlan
Output [28]: [COL_7C48DD17_A13B_4D05_ABDC_1129C093FAD3#130167, COL_D9B743B3_607E_43C4_925D_1BE9E28787AB#130168, COL_860570C8_55F1_440A_A7AF_E8B0A8886BB5#130169, COL_1415BD90_E9ED_46AA_A47C_ADE17C88C3CF#130170, COL_9A37E0B4_19CB_465C_B4EF_68816AB82A99#130171, COL_5AD97914_9559_4E06_8D24_B1592F2E10A5#130172, COL_25B72D6E_9577_4EF4_83C7_ECFF2A185874#130475, COL_D6D93F00_E3C1_48A8_BB54_0F5AE4B592EB#130174, COL_6DDA734B_4480_402E_A177_8BA369324F8E#130175, COL_07D6AA50_D4DA_4ED9_A982_3E3D7B27F614#130176, COL_305FC5F2_280A_4FB0_829F_2827B089C3CF#130177, COL_9242CD77_014E_4035_AB8E_83314AD8182A#130178, COL_BB45DEC5_E178_4F91_AAE6_A6923A671F1F#130481, COL_985E1CD4_642D_4127_91C5_DB3DB2E83E7E#130180, COL_5E845DD8_4DF9_4090_9731_E1D354CF7D83#130483, COL_0A7FFC23_DB3F_4A46_81CA_D2C61A219DB1#130182, COL_76BCF9A9_B1F8_478A_8DF1_524FB8E937DF#130183, COL_9B42856F_C82E_4165_971A_95A412DB3B26#130184, COL_B69F539B_A27F_4620_BBDA_E7F2B6F2E008#130185, COL_DE2D08CF_2008_47ED_8D58_AEADB5069205#130186, COL_ADF17746_745D_4C86_8523_7500C561BCF0#130187, COL_A71E90AC_CAFF_4E88_A1D6_BEA1F905C41C#130188, COL_9C78BB41_1BBE_4EA9_9D7E_439D18097F48#130189, COL_5C243F78_A8C7_4D73_832C_3ADA9066176A#130283, COL_C5E4B8CF_2186_45D6_9F31_C450DED7C42B#130493, COL_C0B7063E_6B78_455C_AB96_66B7F26F839B#130628, COL_D2979EFC_6211_4ED5_AA64_5B8380AFB367#130657, COL_1FF06D0F_9AE1_4EDB_B555_DA5ACCB03931#130308]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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