SP1 - Details for Query 587

Submitted Time: 2026/08/28 12:17:18
Duration: 20 s
Succeeded Jobs: 687 688 694 695 696 697

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="Filter number of output rows: 1,500"]; } 5 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 0 ms"; 7 [labelType="html" label="Sort sort time: 166 ms peak memory: 672.0 MiB spill size: 0.0 B"]; } 8 [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"]; 9 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 259 ms (3 ms, 255 ms, 255 ms (stage 1123.0: task 1489)) 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 1123.0: task 1489)) 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 1123.0: task 1489))"]; 10 [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 1123.0: task 1490))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n4.6 s (89 ms, 4.5 s, 4.5 s (stage 1123.0: task 1489))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 120 ms (1 ms, 119 ms, 119 ms (stage 1123.0: task 1489)) peak memory total (min, med, max (stageId: taskId)) 432.3 MiB (16.3 MiB, 416.0 MiB, 416.0 MiB (stage 1123.0: task 1489)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1123.0: task 1490))"]; } 13 [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"]; 14 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 346 ms (31 ms, 35 ms, 38 ms (stage 1118.0: task 1485)) 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 1123.0: task 1489)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1123.0: task 1490)) 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 1118.0: task 1485)) 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 1118.0: task 1485))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n12.7 s (1.3 s, 1.3 s, 1.3 s (stage 1118.0: task 1488))"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label=" Project "]; 18 [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 1118.0: task 1482))"]; } subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n12.8 s (1.3 s, 1.3 s, 1.3 s (stage 1118.0: task 1488))"; 20 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 122 ms (12 ms, 12 ms, 13 ms (stage 1118.0: task 1486)) peak memory total (min, med, max (stageId: taskId)) 500.0 MiB (50.0 MiB, 50.0 MiB, 50.0 MiB (stage 1118.0: task 1482)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1118.0: task 1482))"]; } 21 [labelType="html" label="Exchange shuffle records written: 602,754 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 575 ms (30 ms, 55 ms, 81 ms (stage 1114.0: task 1476)) 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 1118.0: task 1485)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1118.0: task 1482)) 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 1114.0: task 1478)) 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 1114.0: task 1478))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n9.0 s (856 ms, 901 ms, 953 ms (stage 1114.0: task 1472))"; 23 [labelType="html" label="Filter number of output rows: 602,754"]; } 24 [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 1114.0: task 1477))"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n13.9 s (1.3 s, 1.4 s, 1.4 s (stage 1114.0: task 1471))"; 26 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 384 ms (34 ms, 39 ms, 53 ms (stage 1114.0: task 1471)) peak memory total (min, med, max (stageId: taskId)) 1376.0 MiB (136.0 MiB, 136.0 MiB, 152.0 MiB (stage 1114.0: task 1471)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1114.0: task 1477))"]; } 27 [labelType="html" label="Exchange shuffle records written: 2,996,009 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 569 ms (88 ms, 480 ms, 480 ms (stage 1088.0: task 1438)) 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 1114.0: task 1471)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1114.0: task 1477)) 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 1088.0: task 1438)) 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 1088.0: task 1438))"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n11.8 s (3 ms, 7 ms, 9.8 s (stage 1088.0: task 1438))"; 29 [labelType="html" label=" Project "]; 30 [labelType="html" label="ColumnarToRow number of output rows: 2,996,009 number of input batches: 732"]; } 31 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 1.5 s (2 ms, 6 ms, 1.3 s (stage 1088.0: task 1438)) metadata time: 0 ms size of files read: 150.9 MiB number of output rows: 2,996,009"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 33 [labelType="html" label=" Project "]; 34 [labelType="html" label="Filter number of output rows: 88,203"]; } 35 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 37 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 3 ms (stage 1118.0: task 1480)) peak memory total (min, med, max (stageId: taskId)) 162.5 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 1118.0: task 1482)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1118.0: task 1482))"]; } 38 [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 1089.0: task 1444)) 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 1118.0: task 1485)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1118.0: task 1482)) 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 1089.0: task 1444)) 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 1089.0: task 1444))"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n214 ms (83 ms, 131 ms, 131 ms (stage 1089.0: task 1444))"; 40 [labelType="html" label=" Project "]; 41 [labelType="html" label="Filter number of output rows: 93,005"]; } 42 [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; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 18->17; 20->18; 21->20; 23->21; 24->23; 26->24; 27->26; 29->27; 30->29; 31->30; 33->18; 34->33; 35->34; 37->35; 38->37; 40->38; 41->40; 42->41; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, ... 2 more fields]

Filter (isnotnull(str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#103012)) OR isnotnull(str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087)))

WholeStageCodegen (11)

Window [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963], [1 DESC NULLS LAST]

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

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 10), ENSURE_REQUIREMENTS, [plan_id=28555]

Window [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#103012], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961], [1 DESC NULLS LAST]

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

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 10), ENSURE_REQUIREMENTS, [plan_id=28480]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]

Project [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832]

SortMergeJoin [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447], [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656], LeftOuter

WholeStageCodegen (8)

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

WholeStageCodegen (5)

Exchange hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, 10), ENSURE_REQUIREMENTS, [plan_id=28364]

Filter (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444 <=> A)

WholeStageCodegen (4)

Window [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445], [1 DESC NULLS LAST]

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

WholeStageCodegen (3)

Exchange hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 10), ENSURE_REQUIREMENTS, [plan_id=27726]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337,COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338,COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339,COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340,COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341,COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342,COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343,COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344,COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345,COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346,COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347,COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348,COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349] 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#102281 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297 <=> 1)

WholeStageCodegen (7)

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

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

WholeStageCodegen (6)

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, 10), ENSURE_REQUIREMENTS, [plan_id=27744]

Project [Numéro Séjour#102160 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, UF#102161 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]

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

WholeStageCodegen (2)

FileScan csv [Numéro Séjour#102160,UF#102161] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#102160, #)) 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 (63)
+- == Final Plan ==
   CollectLimit (36)
   +- * Project (35)
      +- * Filter (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 (62)
   +- Project (61)
      +- Filter (60)
         +- Window (59)
            +- Sort (58)
               +- Exchange (57)
                  +- Window (56)
                     +- Sort (55)
                        +- Exchange (54)
                           +- Project (53)
                              +- Project (52)
                                 +- SortMergeJoin LeftOuter (51)
                                    :- Sort (43)
                                    :  +- Exchange (42)
                                    :     +- Filter (41)
                                    :        +- Window (40)
                                    :           +- Sort (39)
                                    :              +- Exchange (38)
                                    :                 +- Project (37)
                                    :                    +- Scan parquet  (1)
                                    +- Project (50)
                                       +- Filter (49)
                                          +- Window (48)
                                             +- Sort (47)
                                                +- Exchange (46)
                                                   +- Project (45)
                                                      +- Filter (44)
                                                         +- Scan csv  (12)


(1) Scan parquet 
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349]
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#102337, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349]

(3) Project [codegen id : 1]
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349]

(4) Exchange
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 10), ENSURE_REQUIREMENTS, [plan_id=27726]

(5) ShuffleQueryStage
Output [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: 0

(6) Sort [codegen id : 3]
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(7) Window
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445], [1 DESC NULLS LAST]

(8) Filter [codegen id : 4]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Condition : (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444 <=> A)

(9) Exchange
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, 10), ENSURE_REQUIREMENTS, [plan_id=28364]

(10) ShuffleQueryStage
Output [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Arguments: 2

(11) Sort [codegen id : 5]
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447 ASC NULLS FIRST], false, 0

(12) Scan csv 
Output [2]: [Numéro Séjour#102160, UF#102161]
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#102160, UF#102161]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#102160, #)) THEN false ELSE StartsWith(Numéro Séjour#102160, #) END AND isnotnull(Numéro Séjour#102160))

(14) Project [codegen id : 2]
Output [2]: [Numéro Séjour#102160 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, UF#102161 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Input [2]: [Numéro Séjour#102160, UF#102161]

(15) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, 10), ENSURE_REQUIREMENTS, [plan_id=27744]

(16) ShuffleQueryStage
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Arguments: 1

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

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

(19) Filter [codegen id : 7]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297 <=> 1)

(20) Project [codegen id : 7]
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297]

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

(22) Project [codegen id : 8]
Output [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657]

(23) Project [codegen id : 8]
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832]

(24) Exchange
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 10), ENSURE_REQUIREMENTS, [plan_id=28480]

(25) ShuffleQueryStage
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: 3

(26) AQEShuffleRead
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: coalesced

(27) Sort [codegen id : 9]
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(28) Window
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#103012], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961], [1 DESC NULLS LAST]

(29) Exchange
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 10), ENSURE_REQUIREMENTS, [plan_id=28555]

(30) ShuffleQueryStage
Output [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: 4

(31) AQEShuffleRead
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: coalesced

(32) Sort [codegen id : 10]
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(33) Window
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963], [1 DESC NULLS LAST]

(34) Filter [codegen id : 11]
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087]
Condition : (isnotnull(str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#103012)) OR isnotnull(str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087)))

(35) Project [codegen id : 11]
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#103012) AS COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#103310, str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087) AS COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#103311]
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087]

(36) CollectLimit
Input [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#103310, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#103311]
Arguments: 1500

(37) Project
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337 AS COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338 AS COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339 AS COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 AS COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341 AS COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342 AS COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343 AS COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344 AS COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345 AS COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346 AS COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347 AS COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348 AS COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349 AS COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, str_remove_space(str_if_with_rule(((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> B) OR (COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340 <=> C)), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, 78, 5), null), ONLY_ONE) AS COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#102337, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#102338, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#102339, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#102340, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#102341, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#102342, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#102343, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#102344, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#102345, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#102346, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#102347, COL_C7343A35_76C1_46A3_B74D_C7263B786745#102348, COL_52134AAB_9340_42E7_9290_A298AF6C9438#102349]

(38) Exchange
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: hashpartitioning(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 10), ENSURE_REQUIREMENTS, [plan_id=27648]

(39) Sort
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: [COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(40) Window
Input [14]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467]
Arguments: [collect_set(COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, 0, 0) windowspecdefinition(COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500], [COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445], [1 DESC NULLS LAST]

(41) Filter
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Condition : (COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444 <=> A)

(42) Exchange
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Arguments: hashpartitioning(COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, 10), ENSURE_REQUIREMENTS, [plan_id=27659]

(43) Sort
Input [15]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500]
Arguments: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447 ASC NULLS FIRST], false, 0

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

(45) Project
Output [2]: [Numéro Séjour#102160 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, UF#102161 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Input [2]: [Numéro Séjour#102160, UF#102161]

(46) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, 10), ENSURE_REQUIREMENTS, [plan_id=27652]

(47) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(48) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281], [1 DESC NULLS LAST]

(49) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297 <=> 1)

(50) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281 AS 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282 AS 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102281, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102282, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#102297]

(51) SortMergeJoin
Left keys [1]: [COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447]
Right keys [1]: [00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656]
Join type: LeftOuter
Join condition: None

(52) Project
Output [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656 AS COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, str_if_with_rule(isnull(00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656), Absent du RSF, Présent dans RSF) AS COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657 AS COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SUN,SUF]), true) AS COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, size(str_list_intersect_fixed(COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, [SAS]), true) AS COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832]
Input [17]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, 00_C_PASSAGE_PA_345648_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#102656, 00_C_PASSAGE_PA_345648_COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#102657]

(53) Project
Output [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, str_if_with_rule((COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, str_if_with_rule((COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812 <=> 1), COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, ) AS COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Input [20]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832]

(54) Exchange
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: hashpartitioning(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 10), ENSURE_REQUIREMENTS, [plan_id=27665]

(55) Sort
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(56) Window
Input [22]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_87E64838_3BAB_4526_BF3E_008427D11600#103012], [COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961], [1 DESC NULLS LAST]

(57) Exchange
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: hashpartitioning(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 10), ENSURE_REQUIREMENTS, [plan_id=27669]

(58) Sort
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(59) Window
Input [23]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012]
Arguments: [collect_set(COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, 0, 0) windowspecdefinition(COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087], [COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963], [1 DESC NULLS LAST]

(60) Filter
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087]
Condition : (isnotnull(str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#103012)) OR isnotnull(str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087)))

(61) Project
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, str_list_as_str(COL_87E64838_3BAB_4526_BF3E_008427D11600#103012) AS COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#103310, str_list_as_str(COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087) AS COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#103311]
Input [24]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087]

(62) CollectLimit
Input [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#103310, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#103311]
Arguments: 1500

(63) AdaptiveSparkPlan
Output [26]: [COL_F31764E5_0309_4AF4_9E38_4F8424ABA387#102441, COL_A86D3251_6564_4706_815A_936FA28EC2B7#102442, COL_29B5B1D1_9EF8_4364_B867_69F95DDA0CB4#102443, COL_D50B88DC_7339_47AA_AF53_7DF1382234F8#102444, COL_86264515_64DE_4F5A_B65C_1F224369C11E#102445, COL_4A29EE24_CEF0_40CA_A250_33F0FC596A56#102446, COL_136DCAA3_2545_47C9_A61E_86ED7914066D#102447, COL_A90C305E_35FC_4943_AAB5_5689729329D0#102448, COL_CFBC4460_61CE_4DB3_99CF_AAAF839C2FDF#102449, COL_A125700F_63CC_436A_9370_99E22C285ACF#102450, COL_8678C313_B7BE_49C0_A54D_231C14C94790#102451, COL_CC6C0292_8064_4828_96F0_08F4D49DED83#102452, COL_8C91B482_E1DB_447D_99E8_C109117EA414#102453, COL_FCC68208_0213_4ED4_ABDA_BD50FA39E80E#102789, COL_B43F5A7D_FF5A_4881_BC76_77723479DBF6#102790, COL_FF2201D9_E9A4_4F4A_9614_694F74FD5D0F#102467, COL_7F6BA768_8054_4161_B9FA_C8767D1D66AD#102500, COL_32645524_1ACD_40CD_A3AE_FBCBD9733F76#102812, COL_CD07D5F2_59C5_46B0_9D35_4FA85B904708#102832, COL_A7B79A69_6514_4DE6_BB59_8CD22992A386#102961, COL_AF978AAB_D361_4C61_94AF_432EBFAA8810#102793, COL_8D906CB5_E958_4E21_BA53_1C757CF7C488#102963, COL_87E64838_3BAB_4526_BF3E_008427D11600#103012, COL_2094C447_FD18_4EDD_AB41_506CB04536E3#103087, COL_5A5CA1D7_78FD_44C9_B61E_BE7E8296E46C#103310, COL_A3A00539_B329_4DF2_A762_2F27B0C604BE#103311]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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