SP1 - Details for Query 12001

Submitted Time: 2026/01/24 21:02:55
Duration: 27 s
Succeeded Jobs: 17804 17805 17807 17821 17822

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 4 ms (0 ms, 0 ms, 1 ms (stage 32154.0: task 39024)) number of written files: 10 job commit time: 9 ms number of output rows: 1,500,475 number of dynamic part: 0 written output: 64.8 MiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n49.9 s (4.7 s, 4.9 s, 5.4 s (stage 32154.0: task 39020))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; } 8 [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 32154.0: task 39019))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n52.5 s (4.9 s, 5.2 s, 5.7 s (stage 32154.0: task 39020))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 311 ms (27 ms, 30 ms, 38 ms (stage 32154.0: task 39017)) peak memory total (min, med, max (stageId: taskId)) 1000.0 MiB (100.0 MiB, 100.0 MiB, 100.0 MiB (stage 32154.0: task 39019)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32154.0: task 39019))"]; } 11 [labelType="html" label="Exchange shuffle records written: 1,500,475 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 397 ms (28 ms, 43 ms, 53 ms (stage 32149.0: task 39010)) 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: 1,500,475 local bytes read total (min, med, max (stageId: taskId)) 104.4 MiB (10.3 MiB, 10.5 MiB, 10.5 MiB (stage 32154.0: task 39023)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 32154.0: task 39019)) 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)) 819.3 MiB (80.4 MiB, 82.2 MiB, 83.5 MiB (stage 32149.0: task 39007)) 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.4 MiB (10.3 MiB, 10.5 MiB, 10.6 MiB (stage 32149.0: task 39014))"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n10.5 s (1.0 s, 1.0 s, 1.2 s (stage 32149.0: task 39008))"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="SortMergeJoin number of output rows: 1,500,475 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32149.0: task 39010))"]; } subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n10.7 s (1.0 s, 1.1 s, 1.2 s (stage 32149.0: task 39008))"; 16 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 188 ms (17 ms, 19 ms, 21 ms (stage 32149.0: task 39011)) peak memory total (min, med, max (stageId: taskId)) 856.0 MiB (84.0 MiB, 84.0 MiB, 100.0 MiB (stage 32149.0: task 39007)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32149.0: task 39010))"]; } 17 [labelType="html" label="Exchange shuffle records written: 1,500,475 local merged chunks fetched: 0 shuffle write time: 239 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,500,475 local bytes read total (min, med, max (stageId: taskId)) 90.7 MiB (8.9 MiB, 9.1 MiB, 9.2 MiB (stage 32149.0: task 39014)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 32149.0: task 39010)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 783.3 MiB 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: 90.7 MiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 6.5 s"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label=" Project "]; } 21 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 8.2 s"; 23 [labelType="html" label="Sort sort time: 130 ms peak memory: 720.0 MiB spill size: 0.0 B"]; 24 [labelType="html" label=" Project "]; } 25 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 2.1 s"; 27 [labelType="html" label="Sort sort time: 135 ms peak memory: 608.0 MiB spill size: 0.0 B"]; } 28 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 64.8 MiB number of coalesced partitions: 1"]; 29 [labelType="html" label="Exchange shuffle records written: 1,500,475 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 213 ms (16 ms, 19 ms, 38 ms (stage 32124.0: task 38969)) 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: 1,500,475 local bytes read: 62.3 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 523.3 MiB (45.2 MiB, 53.1 MiB, 53.3 MiB (stage 32124.0: task 38961)) 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)) 62.3 MiB (4.7 MiB, 6.4 MiB, 6.6 MiB (stage 32124.0: task 38970))"]; 30 [labelType="html" label=" Project "]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n18.6 s (1.7 s, 1.8 s, 2.0 s (stage 32124.0: task 38961))"; 32 [labelType="html" label="Filter number of output rows: 1,500,475"]; 33 [labelType="html" label=" Project "]; } 34 [labelType="html" label="Scan csv number of output rows: 1,500,475 number of files read: 1 metadata time: 0 ms size of files read: 262.5 MiB"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label="Filter number of output rows: 86,518"]; } 38 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 40 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 25 ms (1 ms, 2 ms, 4 ms (stage 32149.0: task 39012)) peak memory total (min, med, max (stageId: taskId)) 162.5 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 32149.0: task 39010)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32149.0: task 39010))"]; } 41 [labelType="html" label="Exchange shuffle records written: 87,452 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 4 ms (2 ms, 2 ms, 2 ms (stage 32125.0: task 38962)) 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: 87,452 local bytes read total (min, med, max (stageId: taskId)) 657.1 KiB (64.6 KiB, 66.0 KiB, 66.9 KiB (stage 32149.0: task 39007)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 32149.0: task 39010)) 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)) 2.7 MiB (1162.9 KiB, 1569.9 KiB, 1569.9 KiB (stage 32125.0: task 38962)) 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)) 657.1 KiB (279.8 KiB, 377.2 KiB, 377.2 KiB (stage 32125.0: task 38962))"]; subgraph cluster42 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n194 ms (84 ms, 110 ms, 110 ms (stage 32125.0: task 38962))"; 43 [labelType="html" label=" Project "]; 44 [labelType="html" label="Filter number of output rows: 87,452"]; } 45 [labelType="html" label="Scan csv number of output rows: 87,452 number of files read: 1 metadata time: 0 ms size of files read: 7.0 MiB"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 16->14; 17->16; 19->17; 20->19; 21->20; 23->21; 24->23; 25->24; 27->25; 28->27; 29->28; 30->29; 32->30; 33->32; 34->33; 36->14; 37->36; 38->37; 40->38; 41->40; 43->41; 44->43; 45->44; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_161843, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_161843], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, COL_DE173389_FC77_42AB_B565_A267156FF638, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1, COL_57A29A37_9A17_4B66_8075_897F4B240E81, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09, COL_7283FB96_45C4_411A_901D_417BCF15E684, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854]

WriteFiles

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#2431016, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, size(str_list_intersect_fixed(str_split(XXX;CFU;FPL;FPX;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUN;CFU;FPL;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUNfPX;, ;), COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766]

WholeStageCodegen (11)

Window [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146], [1 DESC NULLS LAST]

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

WholeStageCodegen (10)

Exchange hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 10), ENSURE_REQUIREMENTS, [plan_id=1201128]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]

SortMergeJoin [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150], [00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285], LeftOuter

WholeStageCodegen (9)

Sort [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150 ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

Exchange hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, 10), ENSURE_REQUIREMENTS, [plan_id=1197845]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187 AS COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

WholeStageCodegen (5)

Window [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834, last(COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST]

Sort [1 ASC NULLS FIRST, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST], false, 0

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]

WholeStageCodegen (4)

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

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

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

Project [COLL0#2429152 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, get_json_object(COLL1#2429154, $.file) AS COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, str_if_with_rule(CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END, str_complete(str_remove_space(str_extract_middle(COLL0#2429152, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, str_extract(COLL0#2429152, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]

Filter isnotnull(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null))

Project [_c0#2429147 AS COLL0#2429152, CREATE_DEPOT_METADATA({"reader_type":"CSV","current_version_mask":"{*rsf*.*,*RSF*.*}","sep":";","quote":"","header":false,"charset":"DEFAULT"}, {"type":"connector.mapping.sftp","user_configured_path":"","local":false,"host":"sftp.adobiscloud.ovh","port":22,"username":"App_780110078","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#2429154]

WholeStageCodegen (1)

FileScan csv [_c0#2429147] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSF_SERVEUR_161409/rsf_7750887_MCO_0120..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343 AS 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360 <=> 1)

WholeStageCodegen (8)

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

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

WholeStageCodegen (7)

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, 10), ENSURE_REQUIREMENTS, [plan_id=1197516]

Project [Numéro Séjour#2428127 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]

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

WholeStageCodegen (2)

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

Details

== Physical Plan ==
AdaptiveSparkPlan (70)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (38)
   +- WriteFiles (37)
      +- * Project (36)
         +- * Project (35)
            +- * Project (34)
               +- * Project (33)
                  +- Window (32)
                     +- * Sort (31)
                        +- ShuffleQueryStage (30), Statistics(sizeInBytes=819.3 MiB, rowCount=1.50E+6)
                           +- Exchange (29)
                              +- * Project (28)
                                 +- * SortMergeJoin LeftOuter (27)
                                    :- * Sort (17)
                                    :  +- ShuffleQueryStage (16), Statistics(sizeInBytes=783.3 MiB, rowCount=1.50E+6)
                                    :     +- Exchange (15)
                                    :        +- * Project (14)
                                    :           +- * Project (13)
                                    :              +- Window (12)
                                    :                 +- * Sort (11)
                                    :                    +- * Project (10)
                                    :                       +- Window (9)
                                    :                          +- * Sort (8)
                                    :                             +- AQEShuffleRead (7)
                                    :                                +- ShuffleQueryStage (6), Statistics(sizeInBytes=523.3 MiB, rowCount=1.50E+6)
                                    :                                   +- Exchange (5)
                                    :                                      +- Project (4)
                                    :                                         +- * Filter (3)
                                    :                                            +- * Project (2)
                                    :                                               +- Scan csv  (1)
                                    +- * Project (26)
                                       +- * Filter (25)
                                          +- Window (24)
                                             +- * Sort (23)
                                                +- ShuffleQueryStage (22), Statistics(sizeInBytes=2.7 MiB, rowCount=8.75E+4)
                                                   +- Exchange (21)
                                                      +- * Project (20)
                                                         +- * Filter (19)
                                                            +- Scan csv  (18)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (69)
   +- WriteFiles (68)
      +- Project (67)
         +- Project (66)
            +- Project (65)
               +- Project (64)
                  +- Window (63)
                     +- Sort (62)
                        +- Exchange (61)
                           +- Project (60)
                              +- SortMergeJoin LeftOuter (59)
                                 :- Sort (51)
                                 :  +- Exchange (50)
                                 :     +- Project (49)
                                 :        +- Project (48)
                                 :           +- Window (47)
                                 :              +- Sort (46)
                                 :                 +- Project (45)
                                 :                    +- Window (44)
                                 :                       +- Sort (43)
                                 :                          +- Exchange (42)
                                 :                             +- Project (41)
                                 :                                +- Filter (40)
                                 :                                   +- Project (39)
                                 :                                      +- Scan csv  (1)
                                 +- Project (58)
                                    +- Filter (57)
                                       +- Window (56)
                                          +- Sort (55)
                                             +- Exchange (54)
                                                +- Project (53)
                                                   +- Filter (52)
                                                      +- Scan csv  (18)


(1) Scan csv 
Output [1]: [_c0#2429147]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSF_SERVEUR_161409/rsf_7750887_MCO_012025_112025 VERSAILLES.txt]
ReadSchema: struct<_c0:string>

(2) Project [codegen id : 1]
Output [2]: [_c0#2429147 AS COLL0#2429152, CREATE_DEPOT_METADATA({"reader_type":"CSV","current_version_mask":"{*rsf*.*,*RSF*.*}","sep":";","quote":"","header":false,"charset":"DEFAULT"}, {"type":"connector.mapping.sftp","user_configured_path":"","local":false,"host":"sftp.adobiscloud.ovh","port":22,"username":"App_780110078","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#2429154]
Input [1]: [_c0#2429147]

(3) Filter [codegen id : 1]
Input [2]: [COLL0#2429152, COLL1#2429154]
Condition : isnotnull(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null))

(4) Project
Output [5]: [COLL0#2429152 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, get_json_object(COLL1#2429154, $.file) AS COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, str_if_with_rule(CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END, str_complete(str_remove_space(str_extract_middle(COLL0#2429152, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, str_extract(COLL0#2429152, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Input [2]: [COLL0#2429152, COLL1#2429154]

(5) Exchange
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=1197492]

(6) ShuffleQueryStage
Output [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: 0

(7) AQEShuffleRead
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: coalesced

(8) Sort [codegen id : 3]
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(9) Window
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227], [1], [1 DESC NULLS LAST]

(10) Project [codegen id : 4]
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Input [6]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227]

(11) Sort [codegen id : 4]
Input [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Arguments: [1 ASC NULLS FIRST, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST], false, 0

(12) Window
Input [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Arguments: [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834, last(COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST]

(13) Project [codegen id : 5]
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187 AS COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [23]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500, COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559, COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979]

(14) Project [codegen id : 5]
Output [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217 AS COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(15) Exchange
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Arguments: hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, 10), ENSURE_REQUIREMENTS, [plan_id=1197845]

(16) ShuffleQueryStage
Output [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Arguments: 2

(17) Sort [codegen id : 6]
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Arguments: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150 ASC NULLS FIRST], false, 0

(18) Scan csv 
Output [1]: [Numéro Séjour#2428127]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_161404/passage_patient_VERSAILLES_2025.csv]
PushedFilters: [IsNotNull(Numéro Séjour)]
ReadSchema: struct<Numéro Séjour:string>

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

(20) Project [codegen id : 2]
Output [1]: [Numéro Séjour#2428127 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Input [1]: [Numéro Séjour#2428127]

(21) Exchange
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, 10), ENSURE_REQUIREMENTS, [plan_id=1197516]

(22) ShuffleQueryStage
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: 1

(23) Sort [codegen id : 7]
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343], [1 DESC NULLS LAST]

(25) Filter [codegen id : 8]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360 <=> 1)

(26) Project [codegen id : 8]
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343 AS 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360]

(27) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150]
Right keys [1]: [00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]
Join type: LeftOuter
Join condition: None

(28) Project [codegen id : 9]
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]

(29) Exchange
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 10), ENSURE_REQUIREMENTS, [plan_id=1201128]

(30) ShuffleQueryStage
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: 3

(31) Sort [codegen id : 10]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(32) Window
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146], [1 DESC NULLS LAST]

(33) Project [codegen id : 11]
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, size(str_list_intersect_fixed(str_split(XXX;CFU;FPL;FPX;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUN;CFU;FPL;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUNfPX;, ;), COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503, COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643]

(34) Project [codegen id : 11]
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766]

(35) Project [codegen id : 11]
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829]

(36) Project [codegen id : 11]
Output [19]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#2431016, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(37) WriteFiles
Input [19]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#2431016, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(38) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_161843, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_161843], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, COL_DE173389_FC77_42AB_B565_A267156FF638, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1, COL_57A29A37_9A17_4B66_8075_897F4B240E81, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09, COL_7283FB96_45C4_411A_901D_417BCF15E684, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854]

(39) Project
Output [2]: [_c0#2429147 AS COLL0#2429152, CREATE_DEPOT_METADATA({"reader_type":"CSV","current_version_mask":"{*rsf*.*,*RSF*.*}","sep":";","quote":"","header":false,"charset":"DEFAULT"}, {"type":"connector.mapping.sftp","user_configured_path":"","local":false,"host":"sftp.adobiscloud.ovh","port":22,"username":"App_780110078","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#2429154]
Input [1]: [_c0#2429147]

(40) Filter
Input [2]: [COLL0#2429152, COLL1#2429154]
Condition : isnotnull(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null))

(41) Project
Output [5]: [COLL0#2429152 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, get_json_object(COLL1#2429154, $.file) AS COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END OR CASE WHEN isnull(StartsWith(COLL0#2429152, B)) THEN false ELSE StartsWith(COLL0#2429152, B) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, C)) THEN false ELSE StartsWith(COLL0#2429152, C) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, H)) THEN false ELSE StartsWith(COLL0#2429152, H) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, L)) THEN false ELSE StartsWith(COLL0#2429152, L) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, M)) THEN false ELSE StartsWith(COLL0#2429152, M) END) OR CASE WHEN isnull(StartsWith(COLL0#2429152, P)) THEN false ELSE StartsWith(COLL0#2429152, P) END), str_extract_middle(COLL0#2429152, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, str_if_with_rule(CASE WHEN isnull(StartsWith(COLL0#2429152, A)) THEN false ELSE StartsWith(COLL0#2429152, A) END, str_complete(str_remove_space(str_extract_middle(COLL0#2429152, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, str_extract(COLL0#2429152, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Input [2]: [COLL0#2429152, COLL1#2429154]

(42) Exchange
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=1197411]

(43) Sort
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(44) Window
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227], [1], [1 DESC NULLS LAST]

(45) Project
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Input [6]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#2429208, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227]

(46) Sort
Input [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Arguments: [1 ASC NULLS FIRST, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST], false, 0

(47) Window
Input [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357]
Arguments: [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834, last(COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 ASC NULLS LAST]

(48) Project
Output [14]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187 AS COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [23]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#2429186, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#2429187, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#2429188, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#2429227, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#2429213, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#2429265, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#2429273, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#2429282, COL_25B879C4_36D2_489F_B446_6501A1E67754#2429292, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#2429303, COL_1A372C23_5064_4170_A811_4401991E73DD#2429315, COL_872A06E3_3546_4804_929D_A512DE4C1392#2429328, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#2429342, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#2429357, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#2429391, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#2429444, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#2429500, COL_C7343A35_76C1_46A3_B74D_C7263B786745#2429559, COL_52134AAB_9340_42E7_9290_A298AF6C9438#2429621, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#2429766, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#2429834, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#2429905, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#2429979]

(49) Project
Output [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217 AS COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(50) Exchange
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Arguments: hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, 10), ENSURE_REQUIREMENTS, [plan_id=1197427]

(51) Sort
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Arguments: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150 ASC NULLS FIRST], false, 0

(52) Filter
Input [1]: [Numéro Séjour#2428127]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#2428127, #)) THEN false ELSE StartsWith(Numéro Séjour#2428127, #) END AND isnotnull(Numéro Séjour#2428127))

(53) Project
Output [1]: [Numéro Séjour#2428127 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Input [1]: [Numéro Séjour#2428127]

(54) Exchange
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, 10), ENSURE_REQUIREMENTS, [plan_id=1197420]

(55) Sort
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(56) Window
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343], [1 DESC NULLS LAST]

(57) Filter
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360 <=> 1)

(58) Project
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343 AS 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2428343, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2428360]

(59) SortMergeJoin
Left keys [1]: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150]
Right keys [1]: [00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]
Join type: LeftOuter
Join condition: None

(60) Project
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, 00_C_PASSAGE_PA_161906_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2430285]

(61) Exchange
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 10), ENSURE_REQUIREMENTS, [plan_id=1197432]

(62) Sort
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(63) Window
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503]
Arguments: [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146], [1 DESC NULLS LAST]

(64) Project
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, size(str_list_intersect_fixed(str_split(XXX;CFU;FPL;FPX;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUN;CFU;FPL;FPM;FPU;FPV;FU0;FU1;FU2;FU3;FU4;PE1;PE2;SAS;SB2;SB3;SIC;SIM;SSF;SSN;SU2;SU3;SUB;SUF;SUM;SUNfPX;, ;), COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#2430503, COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#2430643]

(65) Project
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766]

(66) Project
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#2430433, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#2430766, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829]

(67) Project
Output [19]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#2431016, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(68) WriteFiles
Input [19]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#2430141, COL_DE173389_FC77_42AB_B565_A267156FF638#2430142, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#2430143, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#2430144, COL_57A29A37_9A17_4B66_8075_897F4B240E81#2430145, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#2430146, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#2430256, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#2430150, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#2430151, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#2430152, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#2430954, COL_7283FB96_45C4_411A_901D_417BCF15E684#2430147, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#2430148, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#2430153, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#2430154, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#2430959, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#2431016, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#2430829, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#2430217]

(69) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_161843, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_161843], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, COL_DE173389_FC77_42AB_B565_A267156FF638, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1, COL_57A29A37_9A17_4B66_8075_897F4B240E81, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09, COL_7283FB96_45C4_411A_901D_417BCF15E684, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854]

(70) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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