SP1 - Details for Query 567

Submitted Time: 2026/08/28 12:16:03
Duration: 19 s
Succeeded Jobs: 660 661 662 663 664 665

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 (11)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 138 ms peak memory: 672.0 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 129.8 MiB (4.3 MiB, 125.4 MiB, 125.4 MiB (driver)) number of coalesced partitions: 2"]; 8 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 271 ms (3 ms, 268 ms, 268 ms (stage 1039.0: task 1344)) 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: 583,016 local bytes read: 114.2 MiB 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)) 664.6 MiB (5.6 MiB, 659.0 MiB, 659.0 MiB (stage 1039.0: task 1344)) 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)) 118.3 MiB (1237.5 KiB, 117.1 MiB, 117.1 MiB (stage 1039.0: task 1344))"]; 9 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1039.0: task 1345))"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n4.7 s (105 ms, 4.6 s, 4.6 s (stage 1039.0: task 1344))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 128 ms (2 ms, 126 ms, 126 ms (stage 1039.0: task 1344)) peak memory total (min, med, max (stageId: taskId)) 432.3 MiB (16.3 MiB, 416.0 MiB, 416.0 MiB (stage 1039.0: task 1344)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1039.0: task 1345))"]; } 12 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 108.2 MiB (1331.1 KiB, 106.9 MiB, 106.9 MiB (driver)) number of coalesced partitions: 2"]; 13 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 341 ms (32 ms, 33 ms, 38 ms (stage 1034.0: task 1334)) 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: 602,754 local bytes read total (min, med, max (stageId: taskId)) 104.6 MiB (1265.8 KiB, 103.4 MiB, 103.4 MiB (stage 1039.0: task 1344)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1039.0: task 1345)) 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)) 396.2 MiB (39.4 MiB, 39.6 MiB, 39.9 MiB (stage 1034.0: task 1340)) 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)) 104.6 MiB (10.4 MiB, 10.5 MiB, 10.5 MiB (stage 1034.0: task 1340))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n13.3 s (1.3 s, 1.3 s, 1.4 s (stage 1034.0: task 1336))"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="SortMergeJoin number of output rows: 602,754 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1034.0: task 1335))"]; } subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n13.9 s (1.3 s, 1.4 s, 1.5 s (stage 1034.0: task 1336))"; 19 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 115 ms (11 ms, 12 ms, 12 ms (stage 1034.0: task 1339)) peak memory total (min, med, max (stageId: taskId)) 500.0 MiB (50.0 MiB, 50.0 MiB, 50.0 MiB (stage 1034.0: task 1335)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1034.0: task 1335))"]; } 20 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 390 ms (31 ms, 35 ms, 60 ms (stage 1030.0: task 1331)) 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: 602,754 local bytes read total (min, med, max (stageId: taskId)) 106.1 MiB (10.5 MiB, 10.6 MiB, 10.7 MiB (stage 1034.0: task 1340)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1034.0: task 1335)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 100 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 350.1 MiB (34.7 MiB, 35.0 MiB, 35.2 MiB (stage 1030.0: task 1333)) 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)) 106.1 MiB (10.5 MiB, 10.6 MiB, 10.7 MiB (stage 1030.0: task 1333))"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n9.2 s (876 ms, 916 ms, 1.0 s (stage 1030.0: task 1324))"; 22 [labelType="html" label="Filter number of output rows: 602,754"]; } 23 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1030.0: task 1329))"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n14.1 s (1.3 s, 1.4 s, 1.5 s (stage 1030.0: task 1333))"; 25 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 364 ms (33 ms, 37 ms, 41 ms (stage 1030.0: task 1333)) peak memory total (min, med, max (stageId: taskId)) 1376.0 MiB (136.0 MiB, 136.0 MiB, 152.0 MiB (stage 1030.0: task 1326)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1030.0: task 1329))"]; } 26 [labelType="html" label="Exchange shuffle records written: 2,996,009 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 586 ms (95 ms, 490 ms, 490 ms (stage 1027.0: task 1316)) 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)) 225.5 MiB (22.3 MiB, 22.6 MiB, 22.7 MiB (stage 1030.0: task 1326)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1030.0: task 1329)) 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)) 1251.1 MiB (186.4 MiB, 1064.8 MiB, 1064.8 MiB (stage 1027.0: task 1316)) 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)) 225.5 MiB (33.7 MiB, 191.8 MiB, 191.8 MiB (stage 1027.0: task 1316))"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n11.4 s (23 ms, 29 ms, 9.1 s (stage 1027.0: task 1316))"; 28 [labelType="html" label=" Project "]; 29 [labelType="html" label="ColumnarToRow number of output rows: 2,996,009 number of input batches: 732"]; } 30 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 1.4 s (3 ms, 7 ms, 1.1 s (stage 1027.0: task 1316)) metadata time: 0 ms size of files read: 150.9 MiB number of output rows: 2,996,009"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label="Filter number of output rows: 88,203"]; } 34 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 36 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1034.0: task 1335)) peak memory total (min, med, max (stageId: taskId)) 162.5 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 1034.0: task 1335)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1034.0: task 1335))"]; } 37 [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 (3 ms, 3 ms, 3 ms (stage 1028.0: task 1322)) 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: 93,005 local bytes read total (min, med, max (stageId: taskId)) 1057.6 KiB (103.1 KiB, 106.2 KiB, 107.8 KiB (stage 1034.0: task 1340)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1034.0: task 1335)) 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)) 6.3 MiB (2.6 MiB, 3.7 MiB, 3.7 MiB (stage 1028.0: task 1322)) 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 1028.0: task 1322))"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n224 ms (93 ms, 131 ms, 131 ms (stage 1028.0: task 1322))"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="Filter number of output rows: 93,005"]; } 41 [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; 9->8; 11->9; 12->11; 13->12; 15->13; 16->15; 17->16; 19->17; 20->19; 22->20; 23->22; 25->23; 26->25; 28->26; 29->28; 30->29; 32->17; 33->32; 34->33; 36->34; 37->36; 39->37; 40->39; 41->40; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, ... 2 more fields]

WholeStageCodegen (11)

Window [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925], [1 DESC NULLS LAST]

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

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 10), ENSURE_REQUIREMENTS, [plan_id=25944]

Window [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#97974], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923], [1 DESC NULLS LAST]

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

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 10), ENSURE_REQUIREMENTS, [plan_id=25874]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773]

SortMergeJoin [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388], [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597], LeftOuter

WholeStageCodegen (8)

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

WholeStageCodegen (5)

Exchange hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, 10), ENSURE_REQUIREMENTS, [plan_id=25763]

Filter (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385 <=> A)

WholeStageCodegen (4)

Window [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386], [1 DESC NULLS LAST]

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

WholeStageCodegen (3)

Exchange hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 10), ENSURE_REQUIREMENTS, [plan_id=25557]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286,COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288,COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289,COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290] 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#97222 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238 <=> 1)

WholeStageCodegen (7)

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

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

WholeStageCodegen (6)

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, 10), ENSURE_REQUIREMENTS, [plan_id=25575]

Project [Numéro Séjour#97101 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, UF#97102 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]

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

WholeStageCodegen (2)

FileScan csv [Numéro Séjour#97101,UF#97102] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#97101, #)) THEN false ELSE StartsWith(Numéro Séjou..., 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 (61)
+- == Final Plan ==
   CollectLimit (35)
   +- * Project (34)
      +- Window (33)
         +- * Sort (32)
            +- AQEShuffleRead (31)
               +- ShuffleQueryStage (30), Statistics(sizeInBytes=664.6 MiB, rowCount=6.03E+5)
                  +- Exchange (29)
                     +- Window (28)
                        +- * Sort (27)
                           +- AQEShuffleRead (26)
                              +- ShuffleQueryStage (25), Statistics(sizeInBytes=396.2 MiB, rowCount=6.03E+5)
                                 +- Exchange (24)
                                    +- * Project (23)
                                       +- * Project (22)
                                          +- * SortMergeJoin LeftOuter (21)
                                             :- * Sort (11)
                                             :  +- ShuffleQueryStage (10), Statistics(sizeInBytes=350.1 MiB, rowCount=6.03E+5)
                                             :     +- Exchange (9)
                                             :        +- * Filter (8)
                                             :           +- Window (7)
                                             :              +- * Sort (6)
                                             :                 +- ShuffleQueryStage (5), Statistics(sizeInBytes=1251.1 MiB, rowCount=3.00E+6)
                                             :                    +- Exchange (4)
                                             :                       +- * Project (3)
                                             :                          +- * ColumnarToRow (2)
                                             :                             +- Scan parquet  (1)
                                             +- * Project (20)
                                                +- * Filter (19)
                                                   +- Window (18)
                                                      +- * Sort (17)
                                                         +- ShuffleQueryStage (16), Statistics(sizeInBytes=6.3 MiB, rowCount=9.30E+4)
                                                            +- Exchange (15)
                                                               +- * Project (14)
                                                                  +- * Filter (13)
                                                                     +- Scan csv  (12)
+- == Initial Plan ==
   CollectLimit (60)
   +- Project (59)
      +- Window (58)
         +- Sort (57)
            +- Exchange (56)
               +- Window (55)
                  +- Sort (54)
                     +- Exchange (53)
                        +- Project (52)
                           +- Project (51)
                              +- SortMergeJoin LeftOuter (50)
                                 :- Sort (42)
                                 :  +- Exchange (41)
                                 :     +- Filter (40)
                                 :        +- Window (39)
                                 :           +- Sort (38)
                                 :              +- Exchange (37)
                                 :                 +- Project (36)
                                 :                    +- Scan parquet  (1)
                                 +- Project (49)
                                    +- Filter (48)
                                       +- Window (47)
                                          +- Sort (46)
                                             +- Exchange (45)
                                                +- Project (44)
                                                   +- Filter (43)
                                                      +- Scan csv  (12)


(1) Scan parquet 
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290]
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#97278, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290]

(3) Project [codegen id : 1]
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290]

(4) Exchange
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 10), ENSURE_REQUIREMENTS, [plan_id=25557]

(5) ShuffleQueryStage
Output [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: 0

(6) Sort [codegen id : 3]
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(7) Window
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386], [1 DESC NULLS LAST]

(8) Filter [codegen id : 4]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Condition : (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385 <=> A)

(9) Exchange
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, 10), ENSURE_REQUIREMENTS, [plan_id=25763]

(10) ShuffleQueryStage
Output [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Arguments: 2

(11) Sort [codegen id : 5]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388 ASC NULLS FIRST], false, 0

(12) Scan csv 
Output [2]: [Numéro Séjour#97101, UF#97102]
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>

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

(14) Project [codegen id : 2]
Output [2]: [Numéro Séjour#97101 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, UF#97102 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Input [2]: [Numéro Séjour#97101, UF#97102]

(15) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, 10), ENSURE_REQUIREMENTS, [plan_id=25575]

(16) ShuffleQueryStage
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: 1

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

(18) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222], [1 DESC NULLS LAST]

(19) Filter [codegen id : 7]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238 <=> 1)

(20) Project [codegen id : 7]
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238]

(21) SortMergeJoin [codegen id : 8]
Left keys [1]: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388]
Right keys [1]: [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597]
Join type: LeftOuter
Join condition: None

(22) Project [codegen id : 8]
Output [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598]

(23) Project [codegen id : 8]
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773]

(24) Exchange
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 10), ENSURE_REQUIREMENTS, [plan_id=25874]

(25) ShuffleQueryStage
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: 3

(26) AQEShuffleRead
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: coalesced

(27) Sort [codegen id : 9]
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(28) Window
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#97974], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923], [1 DESC NULLS LAST]

(29) Exchange
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 10), ENSURE_REQUIREMENTS, [plan_id=25944]

(30) ShuffleQueryStage
Output [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: 4

(31) AQEShuffleRead
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: coalesced

(32) Sort [codegen id : 10]
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(33) Window
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925], [1 DESC NULLS LAST]

(34) Project [codegen id : 11]
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#97974) AS COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#98272, str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049) AS COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#98273]
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049]

(35) CollectLimit
Input [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#98272, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#98273]
Arguments: 1500

(36) Project
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#97278, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#97279, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#97280, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#97281, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#97282, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#97283, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#97284, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#97285, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#97286, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#97287, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#97288, COL_C7343A35_76C1_46A3_B74D_C7263B786745#97289, COL_52134AAB_9340_42E7_9290_A298AF6C9438#97290]

(37) Exchange
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 10), ENSURE_REQUIREMENTS, [plan_id=25480]

(38) Sort
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386], [1 DESC NULLS LAST]

(40) Filter
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Condition : (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385 <=> A)

(41) Exchange
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, 10), ENSURE_REQUIREMENTS, [plan_id=25491]

(42) Sort
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388 ASC NULLS FIRST], false, 0

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

(44) Project
Output [2]: [Numéro Séjour#97101 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, UF#97102 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Input [2]: [Numéro Séjour#97101, UF#97102]

(45) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, 10), ENSURE_REQUIREMENTS, [plan_id=25484]

(46) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(47) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222], [1 DESC NULLS LAST]

(48) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238 <=> 1)

(49) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97223, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#97238]

(50) SortMergeJoin
Left keys [1]: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388]
Right keys [1]: [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597]
Join type: LeftOuter
Join condition: None

(51) Project
Output [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#97597, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#97598]

(52) Project
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773]

(53) Exchange
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 10), ENSURE_REQUIREMENTS, [plan_id=25497]

(54) Sort
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(55) Window
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#97974], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923], [1 DESC NULLS LAST]

(56) Exchange
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 10), ENSURE_REQUIREMENTS, [plan_id=25501]

(57) Sort
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(58) Window
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925], [1 DESC NULLS LAST]

(59) Project
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#97974) AS COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#98272, str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049) AS COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#98273]
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049]

(60) CollectLimit
Input [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#98272, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#98273]
Arguments: 1500

(61) AdaptiveSparkPlan
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#97382, COL_A86D3251_6564_4706_815A_936FA28EC2B7#97383, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#97384, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#97385, COL_86264515_64DE_4F5A_B65C_1F224369C11E#97386, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#97387, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#97388, COL_A90C305E_35FC_4943_AAB5_5689729329D0#97389, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#97390, COL_A125700F_63CC_436A_9370_99E22C285ACF#97391, COL_8678C313_B7BE_49C0_A54D_231C14C94790#97392, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#97393, COL_8C91B482_E1DB_447D_99E8_C109117EA414#97394, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#97730, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#97731, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#97408, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#97441, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#97753, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#97773, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#97923, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#97734, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#97925, COL_87E64838_3BAB_4526_BF3E_008427D11600#97974, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#98049, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#98272, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#98273]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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