SP1 - Details for Query 619

Submitted Time: 2026/08/28 12:27:56
Duration: 17 s
Succeeded Jobs: 736 737 740 741

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,500 spill size: 0.0 B"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.1 MiB (861.1 KiB, 1290.9 KiB, 1290.9 KiB (driver)) number of coalesced partitions: 2"]; 8 [labelType="html" label="Exchange shuffle records written: 15,000 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 49 ms (1 ms, 4 ms, 11 ms (stage 1210.0: task 1654)) 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: 5,956 local bytes read: 813.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 8.1 MiB (828.5 KiB, 830.3 KiB, 831.8 KiB (stage 1210.0: task 1651)) 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 total (min, med, max (stageId: taskId)) 2046.2 KiB (202.7 KiB, 205.1 KiB, 206.3 KiB (stage 1210.0: task 1646))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n3.5 s (311 ms, 356 ms, 395 ms (stage 1210.0: task 1648))"; 10 [labelType="html" label=" LocalLimit "]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="Filter number of output rows: 15,000"]; } 13 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; 15 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 441 ms (37 ms, 39 ms, 73 ms (stage 1210.0: task 1654)) peak memory total (min, med, max (stageId: taskId)) 1520.0 MiB (152.0 MiB, 152.0 MiB, 152.0 MiB (stage 1210.0: task 1645)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1210.0: task 1645))"]; } 16 [labelType="html" label="Exchange shuffle records written: 2,996,009 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 686 ms (121 ms, 564 ms, 564 ms (stage 1200.0: task 1635)) 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: 2,996,009 local bytes read total (min, med, max (stageId: taskId)) 247.3 MiB (24.5 MiB, 24.7 MiB, 24.9 MiB (stage 1210.0: task 1647)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1210.0: task 1645)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 20 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1375.6 MiB (204.9 MiB, 1170.7 MiB, 1170.7 MiB (stage 1200.0: task 1635)) 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 total (min, med, max (stageId: taskId)) 247.3 MiB (37.0 MiB, 210.4 MiB, 210.4 MiB (stage 1200.0: task 1635))"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n18.0 s (3 ms, 5 ms, 15.2 s (stage 1200.0: task 1635))"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="ColumnarToRow number of output rows: 2,996,009 number of input batches: 732"]; } 21 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 1.6 s (3 ms, 4 ms, 1.3 s (stage 1200.0: task 1635)) metadata time: 0 ms size of files read: 150.9 MiB number of output rows: 2,996,009"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="Filter number of output rows: 9,080"]; } 25 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 27 [labelType="html" label="Sort sort time: 3 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 28 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1113.9 KiB (445.6 KiB, 668.3 KiB, 668.3 KiB (driver)) number of coalesced partitions: 2"]; 29 [labelType="html" label="Exchange shuffle records written: 93,005 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (2 ms, 3 ms, 3 ms (stage 1201.0: task 1641)) 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: 37,303 local bytes read: 423.6 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 6.3 MiB (2.6 MiB, 3.7 MiB, 3.7 MiB (stage 1201.0: task 1641)) 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 total (min, med, max (stageId: taskId)) 1057.6 KiB (437.9 KiB, 619.8 KiB, 619.8 KiB (stage 1201.0: task 1641))"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n319 ms (143 ms, 176 ms, 176 ms (stage 1201.0: task 1641))"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="Filter number of output rows: 93,005"]; } 33 [labelType="html" label="Scan csv number of output rows: 93,005 number of files read: 1 metadata time: 0 ms size of files read: 6.4 MiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->13; 16->15; 18->16; 19->18; 20->19; 21->20; 23->4; 24->23; 25->24; 27->25; 28->27; 29->28; 31->29; 32->31; 33->32; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]

SortMergeJoin [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034], [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327], LeftOuter

WholeStageCodegen (8)

Sort [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, 10), ENSURE_REQUIREMENTS, [plan_id=30424]

LocalLimit 1500

Filter (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102 <=> 1)

WholeStageCodegen (4)

Window [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032], [1 DESC NULLS LAST]

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

WholeStageCodegen (3)

Exchange hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 10), ENSURE_REQUIREMENTS, [plan_id=30164]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932,COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934,COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935,COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_LIGNES_RSF_345253], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_B706A975_F287_4DC9_B631_A35735FE936F:string,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8:s...

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884 <=> 1)

WholeStageCodegen (7)

Window [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868], [1 DESC NULLS LAST]

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 10), ENSURE_REQUIREMENTS, [plan_id=30193]

Project [Numéro Séjour#108747 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, UF#108748 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]

Filter (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#108747, #)) THEN false ELSE StartsWith(Numéro Séjour#108747, #) END AND isnotnull(Numéro Séjour#108747))

WholeStageCodegen (2)

FileScan csv [Numéro Séjour#108747,UF#108748] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#108747, #)) THEN false ELSE StartsWith(Numéro Séjo..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_344985/passage_pationt_..., PartitionFilters: [], PushedFilters: [IsNotNull(Numéro Séjour)], ReadSchema: struct<Numéro Séjour:string,UF:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (49)
+- == Final Plan ==
   CollectLimit (28)
   +- * Project (27)
      +- * SortMergeJoin LeftOuter (26)
         :- * Sort (15)
         :  +- AQEShuffleRead (14)
         :     +- ShuffleQueryStage (13), Statistics(sizeInBytes=8.1 MiB, rowCount=1.50E+4)
         :        +- Exchange (12)
         :           +- * LocalLimit (11)
         :              +- * Project (10)
         :                 +- * Filter (9)
         :                    +- Window (8)
         :                       +- * Sort (7)
         :                          +- ShuffleQueryStage (6), Statistics(sizeInBytes=1375.6 MiB, rowCount=3.00E+6)
         :                             +- Exchange (5)
         :                                +- * Project (4)
         :                                   +- * Project (3)
         :                                      +- * ColumnarToRow (2)
         :                                         +- Scan parquet  (1)
         +- * Project (25)
            +- * Filter (24)
               +- Window (23)
                  +- * Sort (22)
                     +- AQEShuffleRead (21)
                        +- ShuffleQueryStage (20), Statistics(sizeInBytes=6.3 MiB, rowCount=9.30E+4)
                           +- Exchange (19)
                              +- * Project (18)
                                 +- * Filter (17)
                                    +- Scan csv  (16)
+- == Initial Plan ==
   CollectLimit (48)
   +- Project (47)
      +- SortMergeJoin LeftOuter (46)
         :- Sort (38)
         :  +- Exchange (37)
         :     +- LocalLimit (36)
         :        +- Project (35)
         :           +- Filter (34)
         :              +- Window (33)
         :                 +- Sort (32)
         :                    +- Exchange (31)
         :                       +- Project (30)
         :                          +- Project (29)
         :                             +- Scan parquet  (1)
         +- Project (45)
            +- Filter (44)
               +- Window (43)
                  +- Sort (42)
                     +- Exchange (41)
                        +- Project (40)
                           +- Filter (39)
                              +- Scan csv  (16)


(1) Scan parquet 
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_LIGNES_RSF_345253]
ReadSchema: struct<COL_B706A975_F287_4DC9_B631_A35735FE936F:string,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8:string,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44:int,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38:string,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE:string,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3:string,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D:string,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF:string,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA:string,COL_E53A575D_3952_4C14_AC9F_075847D06BB1:string,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4:string,COL_C7343A35_76C1_46A3_B74D_C7263B786745:string,COL_52134AAB_9340_42E7_9290_A298AF6C9438:string>

(2) ColumnarToRow [codegen id : 1]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936]

(3) Project [codegen id : 1]
Output [15]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936]

(4) Project [codegen id : 1]
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069]

(5) Exchange
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 10), ENSURE_REQUIREMENTS, [plan_id=30164]

(6) ShuffleQueryStage
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 0

(7) Sort [codegen id : 3]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032], [1 DESC NULLS LAST]

(9) Filter [codegen id : 4]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141]
Condition : (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102 <=> 1)

(10) Project [codegen id : 4]
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141]

(11) LocalLimit [codegen id : 4]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 1500

(12) Exchange
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, 10), ENSURE_REQUIREMENTS, [plan_id=30424]

(13) ShuffleQueryStage
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 2

(14) AQEShuffleRead
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034 ASC NULLS FIRST], false, 0

(16) Scan csv 
Output [2]: [Numéro Séjour#108747, UF#108748]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_344985/passage_pationt_09122025.csv]
PushedFilters: [IsNotNull(Numéro Séjour)]
ReadSchema: struct<Numéro Séjour:string,UF:string>

(17) Filter [codegen id : 2]
Input [2]: [Numéro Séjour#108747, UF#108748]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#108747, #)) THEN false ELSE StartsWith(Numéro Séjour#108747, #) END AND isnotnull(Numéro Séjour#108747))

(18) Project [codegen id : 2]
Output [2]: [Numéro Séjour#108747 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, UF#108748 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Input [2]: [Numéro Séjour#108747, UF#108748]

(19) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 10), ENSURE_REQUIREMENTS, [plan_id=30193]

(20) ShuffleQueryStage
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: 1

(21) AQEShuffleRead
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: coalesced

(22) Sort [codegen id : 6]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(23) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868], [1 DESC NULLS LAST]

(24) Filter [codegen id : 7]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884 <=> 1)

(25) Project [codegen id : 7]
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884]

(26) SortMergeJoin [codegen id : 8]
Left keys [1]: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034]
Right keys [1]: [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327]
Join type: LeftOuter
Join condition: None

(27) Project [codegen id : 8]
Output [21]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328]

(28) CollectLimit
Input [21]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 1500

(29) Project
Output [15]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, 68, 2), null), ONLY_ONE) AS COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#108924, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#108925, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#108926, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#108927, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#108928, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#108929, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#108930, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#108931, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#108932, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#108933, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#108934, COL_C7343A35_76C1_46A3_B74D_C7263B786745#108935, COL_52134AAB_9340_42E7_9290_A298AF6C9438#108936]

(30) Project
Output [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, str_join(array(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069), -) AS COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, str_if_with_rule((((COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SAS) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUF)) OR (COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054 <=> SUN)), 1, 0) AS COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069]

(31) Exchange
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 10), ENSURE_REQUIREMENTS, [plan_id=30119]

(32) Sort
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(33) Window
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032], [1 DESC NULLS LAST]

(34) Filter
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141]
Condition : (COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102 <=> 1)

(35) Project
Output [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141]

(36) LocalLimit
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 1500

(37) Exchange
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, 10), ENSURE_REQUIREMENTS, [plan_id=30132]

(38) Sort
Input [18]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034 ASC NULLS FIRST], false, 0

(39) Filter
Input [2]: [Numéro Séjour#108747, UF#108748]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#108747, #)) THEN false ELSE StartsWith(Numéro Séjour#108747, #) END AND isnotnull(Numéro Séjour#108747))

(40) Project
Output [2]: [Numéro Séjour#108747 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, UF#108748 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Input [2]: [Numéro Séjour#108747, UF#108748]

(41) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 10), ENSURE_REQUIREMENTS, [plan_id=30125]

(42) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(43) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868], [1 DESC NULLS LAST]

(44) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884 <=> 1)

(45) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#108868, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#108869, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#108884]

(46) SortMergeJoin
Left keys [1]: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034]
Right keys [1]: [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327]
Join type: LeftOuter
Join condition: None

(47) Project
Output [21]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#109327, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#109328]

(48) CollectLimit
Input [21]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: 1500

(49) AdaptiveSparkPlan
Output [21]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#109028, COL_A86D3251_6564_4706_815A_936FA28EC2B7#109029, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#109030, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#109031, COL_86264515_64DE_4F5A_B65C_1F224369C11E#109032, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#109033, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#109034, COL_A90C305E_35FC_4943_AAB5_5689729329D0#109035, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#109036, COL_A125700F_63CC_436A_9370_99E22C285ACF#109037, COL_8678C313_B7BE_49C0_A54D_231C14C94790#109038, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#109039, COL_8C91B482_E1DB_447D_99E8_C109117EA414#109040, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#109436, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#109437, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#109054, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#109141, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#109440, COL_7162F38A_9C38_4DB5_B1C9_2B4EDA2654DC#109069, COL_E75FD19A_D578_4037_B330_0F4E587CAF25#109085, COL_F62E3011_2289_44BF_BEE2_ECA3E9F70EBF#109102]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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