SP1 - Details for Query 2276

Submitted Time: 2026/09/17 16:17:53
Duration: 4 s
Succeeded Jobs: 3251 3252 3253 3258 3259

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)) 1 ms (0 ms, 0 ms, 1 ms (stage 6544.0: task 8671)) number of written files: 5 job commit time: 16 ms number of output rows: 116,733 number of dynamic part: 0 written output: 6.1 MiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n4.2 s (805 ms, 827 ms, 879 ms (stage 6544.0: task 8668))"; 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 6544.0: task 8669))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n4.8 s (925 ms, 951 ms, 1.0 s (stage 6544.0: task 8668))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 85 ms (13 ms, 17 ms, 20 ms (stage 6544.0: task 8669)) peak memory total (min, med, max (stageId: taskId)) 85.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 6544.0: task 8669)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6544.0: task 8669))"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 9.5 MiB (1905.4 KiB, 1960.1 KiB, 2000.7 KiB (driver)) number of coalesced partitions: 5"]; 12 [labelType="html" label="Exchange shuffle records written: 116,733 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 27 ms (5 ms, 5 ms, 5 ms (stage 6539.0: task 8665)) 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: 116,733 local bytes read total (min, med, max (stageId: taskId)) 9.1 MiB (1819.0 KiB, 1840.5 KiB, 1905.4 KiB (stage 6544.0: task 8667)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 6544.0: task 8669)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 25 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 55.0 MiB (10.9 MiB, 11.0 MiB, 11.2 MiB (stage 6539.0: task 8664)) 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)) 9.1 MiB (1834.4 KiB, 1856.2 KiB, 1879.5 KiB (stage 6539.0: task 8664))"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n1.5 s (297 ms, 300 ms, 318 ms (stage 6539.0: task 8662))"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="SortMergeJoin number of output rows: 116,733 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6539.0: task 8663))"]; } subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (335 ms, 337 ms, 355 ms (stage 6539.0: task 8662))"; 17 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 16 ms (3 ms, 3 ms, 4 ms (stage 6539.0: task 8666)) peak memory total (min, med, max (stageId: taskId)) 85.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 6539.0: task 8663)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6539.0: task 8663))"]; } 18 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 8.6 MiB (1702.4 KiB, 1783.5 KiB, 1783.5 KiB (driver)) number of coalesced partitions: 5"]; 19 [labelType="html" label="Exchange shuffle records written: 116,733 local merged chunks fetched: 0 shuffle write time: 22 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: 116,733 local bytes read total (min, med, max (stageId: taskId)) 8.0 MiB (1628.8 KiB, 1646.6 KiB, 1665.7 KiB (stage 6539.0: task 8664)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 6539.0: task 8663)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size: 50.8 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: 8.0 MiB"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 601 ms"; 21 [labelType="html" label=" Project "]; 22 [labelType="html" label=" Project "]; } 23 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 1.3 s"; 25 [labelType="html" label="Sort sort time: 12 ms peak memory: 52.0 MiB spill size: 0.0 B"]; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 151 ms"; 29 [labelType="html" label="Sort sort time: 12 ms peak memory: 36.0 MiB spill size: 0.0 B"]; } 30 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 5.1 MiB number of coalesced partitions: 1"]; 31 [labelType="html" label="Exchange shuffle records written: 116,733 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 18 ms (2 ms, 3 ms, 3 ms (stage 6526.0: task 8654)) 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: 116,733 local bytes read: 5.0 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 30.8 MiB (3.8 MiB, 5.4 MiB, 5.4 MiB (stage 6526.0: task 8651)) 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)) 5.0 MiB (724.7 KiB, 793.0 KiB, 1076.3 KiB (stage 6526.0: task 8654))"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n714 ms (91 ms, 125 ms, 128 ms (stage 6526.0: task 8654))"; 33 [labelType="html" label=" Project "]; 34 [labelType="html" label="Filter number of output rows: 116,733"]; } 35 [labelType="html" label="Scan csv number of output rows: 116,733 number of files read: 1 metadata time: 0 ms size of files read: 22.9 MiB"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n1.5 s (297 ms, 300 ms, 318 ms (stage 6539.0: task 8662))"; 37 [labelType="html" label=" Project "]; 38 [labelType="html" label="Filter number of output rows: 33,279"]; } 39 [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 6539.0: task 8663))"]; subgraph cluster40 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (334 ms, 336 ms, 353 ms (stage 6539.0: task 8662))"; 41 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 1 ms (stage 6539.0: task 8663)) peak memory total (min, med, max (stageId: taskId)) 85.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 6539.0: task 8663)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 6539.0: task 8663))"]; } 42 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 317.3 KiB (63.5 KiB, 63.5 KiB, 63.5 KiB (driver)) number of coalesced partitions: 5"]; 43 [labelType="html" label="Exchange shuffle records written: 116,733 local merged chunks fetched: 0 shuffle write time: 2 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: 116,733 local bytes read total (min, med, max (stageId: taskId)) 300.5 KiB (59.5 KiB, 60.1 KiB, 60.9 KiB (stage 6539.0: task 8664)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 6539.0: task 8663)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size: 3.6 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: 300.5 KiB"]; subgraph cluster44 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 228 ms"; 45 [labelType="html" label=" Project "]; 46 [labelType="html" label="Filter number of output rows: 116,733"]; } 47 [labelType="html" label="Scan csv number of output rows: 116,733 number of files read: 1 metadata time: 0 ms size of files read: 1938.1 KiB"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 17->15; 18->17; 19->18; 21->19; 22->21; 23->22; 25->23; 26->25; 27->26; 29->27; 30->29; 31->30; 33->31; 34->33; 35->34; 37->15; 38->37; 39->38; 41->39; 42->41; 43->42; 45->43; 46->45; 47->46; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_226165, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_226165], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, 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#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#548270, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, 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#547972), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082]

WholeStageCodegen (11)

Window [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#547972], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689], [1 DESC NULLS LAST]

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

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 10), ENSURE_REQUIREMENTS, [plan_id=332800]

Project [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]

SortMergeJoin [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693], [00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806], LeftOuter

WholeStageCodegen (9)

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, 10), ENSURE_REQUIREMENTS, [plan_id=332570]

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

WholeStageCodegen (5)

Window [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373, last(COL_1A372C23_5064_4170_A811_4401991E73DD#546866, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST]

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

Project [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#546866, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]

WholeStageCodegen (4)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788], [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=332388]

Project [_c0#546720 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END OR CASE WHEN isnull(StartsWith(_c0#546720, B)) THEN false ELSE StartsWith(_c0#546720, B) END) OR CASE WHEN isnull(StartsWith(_c0#546720, C)) THEN false ELSE StartsWith(_c0#546720, C) END) OR CASE WHEN isnull(StartsWith(_c0#546720, H)) THEN false ELSE StartsWith(_c0#546720, H) END) OR CASE WHEN isnull(StartsWith(_c0#546720, L)) THEN false ELSE StartsWith(_c0#546720, L) END) OR CASE WHEN isnull(StartsWith(_c0#546720, M)) THEN false ELSE StartsWith(_c0#546720, M) END) OR CASE WHEN isnull(StartsWith(_c0#546720, P)) THEN false ELSE StartsWith(_c0#546720, P) END), str_extract_middle(_c0#546720, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END, str_complete(str_remove_space(str_extract_middle(_c0#546720, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, str_extract(_c0#546720, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]

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

WholeStageCodegen (1)

FileScan csv [_c0#546720] Batched: false, DataFilters: [isnotnull(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE Sta..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSF_SERVEUR_225513/RSF_RSSA_19022026195..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842 AS 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858 <=> 1)

WholeStageCodegen (8)

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

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

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, 10), ENSURE_REQUIREMENTS, [plan_id=332410]

Project [Numéro Séjour#545663 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842]

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

WholeStageCodegen (2)

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

Details

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


(1) Scan csv 
Output [1]: [_c0#546720]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSF_SERVEUR_225513/RSF_RSSA_190220261957.TXT]
ReadSchema: struct<_c0:string>

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

(3) Project [codegen id : 1]
Output [4]: [_c0#546720 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END OR CASE WHEN isnull(StartsWith(_c0#546720, B)) THEN false ELSE StartsWith(_c0#546720, B) END) OR CASE WHEN isnull(StartsWith(_c0#546720, C)) THEN false ELSE StartsWith(_c0#546720, C) END) OR CASE WHEN isnull(StartsWith(_c0#546720, H)) THEN false ELSE StartsWith(_c0#546720, H) END) OR CASE WHEN isnull(StartsWith(_c0#546720, L)) THEN false ELSE StartsWith(_c0#546720, L) END) OR CASE WHEN isnull(StartsWith(_c0#546720, M)) THEN false ELSE StartsWith(_c0#546720, M) END) OR CASE WHEN isnull(StartsWith(_c0#546720, P)) THEN false ELSE StartsWith(_c0#546720, P) END), str_extract_middle(_c0#546720, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END, str_complete(str_remove_space(str_extract_middle(_c0#546720, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, str_extract(_c0#546720, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Input [1]: [_c0#546720]

(4) Exchange
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=332388]

(5) ShuffleQueryStage
Output [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: 0

(6) AQEShuffleRead
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: coalesced

(7) Sort [codegen id : 3]
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788], [1], [1 DESC NULLS LAST]

(9) Project [codegen id : 4]
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#546866, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788]

(10) Sort [codegen id : 4]
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Arguments: [1 ASC NULLS FIRST, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST], false, 0

(11) Window
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Arguments: [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373, last(COL_1A372C23_5064_4170_A811_4401991E73DD#546866, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST]

(12) Project [codegen id : 5]
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [22]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040, COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096, COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533]

(13) Project [codegen id : 5]
Output [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756 AS COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [13]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(14) Exchange
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, 10), ENSURE_REQUIREMENTS, [plan_id=332570]

(15) ShuffleQueryStage
Output [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: 2

(16) AQEShuffleRead
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: coalesced

(17) Sort [codegen id : 6]
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693 ASC NULLS FIRST], false, 0

(18) Scan csv 
Output [1]: [Numéro Séjour#545663]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_225508/passage_Patient.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#545663]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#545663, #)) THEN false ELSE StartsWith(Numéro Séjour#545663, #) END AND isnotnull(Numéro Séjour#545663))

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

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

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

(23) AQEShuffleRead
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842]
Arguments: coalesced

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

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

(26) Filter [codegen id : 8]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858 <=> 1)

(27) Project [codegen id : 8]
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842 AS 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]

(28) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693]
Right keys [1]: [00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]
Join type: LeftOuter
Join condition: None

(29) Project [codegen id : 9]
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]

(30) Exchange
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 10), ENSURE_REQUIREMENTS, [plan_id=332800]

(31) ShuffleQueryStage
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: 3

(32) AQEShuffleRead
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: coalesced

(33) Sort [codegen id : 10]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(34) Window
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#547972], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689], [1 DESC NULLS LAST]

(35) Project [codegen id : 11]
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, 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#547972), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933, COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#547972]

(36) Project [codegen id : 11]
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082]

(37) Project [codegen id : 11]
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102]

(38) Project [codegen id : 11]
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#548270, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(39) WriteFiles
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#548270, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(40) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_226165, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_226165], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, 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]

(41) Filter
Input [1]: [_c0#546720]
Condition : isnotnull(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END OR CASE WHEN isnull(StartsWith(_c0#546720, B)) THEN false ELSE StartsWith(_c0#546720, B) END) OR CASE WHEN isnull(StartsWith(_c0#546720, C)) THEN false ELSE StartsWith(_c0#546720, C) END) OR CASE WHEN isnull(StartsWith(_c0#546720, H)) THEN false ELSE StartsWith(_c0#546720, H) END) OR CASE WHEN isnull(StartsWith(_c0#546720, L)) THEN false ELSE StartsWith(_c0#546720, L) END) OR CASE WHEN isnull(StartsWith(_c0#546720, M)) THEN false ELSE StartsWith(_c0#546720, M) END) OR CASE WHEN isnull(StartsWith(_c0#546720, P)) THEN false ELSE StartsWith(_c0#546720, P) END), str_extract_middle(_c0#546720, 2, 9), null))

(42) Project
Output [4]: [_c0#546720 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END OR CASE WHEN isnull(StartsWith(_c0#546720, B)) THEN false ELSE StartsWith(_c0#546720, B) END) OR CASE WHEN isnull(StartsWith(_c0#546720, C)) THEN false ELSE StartsWith(_c0#546720, C) END) OR CASE WHEN isnull(StartsWith(_c0#546720, H)) THEN false ELSE StartsWith(_c0#546720, H) END) OR CASE WHEN isnull(StartsWith(_c0#546720, L)) THEN false ELSE StartsWith(_c0#546720, L) END) OR CASE WHEN isnull(StartsWith(_c0#546720, M)) THEN false ELSE StartsWith(_c0#546720, M) END) OR CASE WHEN isnull(StartsWith(_c0#546720, P)) THEN false ELSE StartsWith(_c0#546720, P) END), str_extract_middle(_c0#546720, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, str_if_with_rule(CASE WHEN isnull(StartsWith(_c0#546720, A)) THEN false ELSE StartsWith(_c0#546720, A) END, str_complete(str_remove_space(str_extract_middle(_c0#546720, 40, 9), ALL), 0, 9, LEFT), null) AS COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, str_extract(_c0#546720, LEFT, 1) AS COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Input [1]: [_c0#546720]

(43) Exchange
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=332310]

(44) Sort
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(45) Window
Input [4]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788], [1], [1 DESC NULLS LAST]

(46) Project
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_join(array(COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, str_complete(int_to_str(COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788), 0, 7, LEFT), COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772), -), null) AS COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, str_remove_space(str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 172, 1), null), ALL) AS COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 71, 1), null) AS COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 76, 8), null) AS COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, str_create(COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772) AS COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 85, 8), null) AS COL_1A372C23_5064_4170_A811_4401991E73DD#546866, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 93, 8), null) AS COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 66, 2), null) AS COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, str_if_with_rule((COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 <=> A), str_extract_middle(COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, 70, 1), null) AS COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Input [5]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_2664BA73_E6B4_4AB9_90D6_2C3C28D2F025#546772, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788]

(47) Sort
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Arguments: [1 ASC NULLS FIRST, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST], false, 0

(48) Window
Input [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905]
Arguments: [last(COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937, last(COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987, last(COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040, last(COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096, last(COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155, last(COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308, last(COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373, last(COL_1A372C23_5064_4170_A811_4401991E73DD#546866, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443, last(COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, true) windowspecdefinition(1, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533], [1], [COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 ASC NULLS LAST]

(49) Project
Output [13]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756 AS COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757 AS COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788 AS COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776 AS COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937 AS COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987 AS COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040 AS COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373 AS COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443 AS COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533 AS COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155 AS COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096 AS COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308 <=> 00000000), null, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308) AS COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [22]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#546756, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#546757, COL_AAF7896D_A513_4CEC_9984_26D0D5838E44#546788, COL_1ADA21FB_DB08_4A1F_986E_E8E363B14F38#546776, COL_4A7AC898_9611_4A0A_86C5_61D6CB1AD7DA#546821, COL_44CE2B15_015A_4E14_8FA8_248E657CF570#546828, COL_8E936474_0FF1_479F_82B0_AB95B3B0DCAF#546836, COL_25B879C4_36D2_489F_B446_6501A1E67754#546845, COL_680C5F82_0BF3_40D6_B7C6_9ABF5D4EDAA0#546855, COL_1A372C23_5064_4170_A811_4401991E73DD#546866, COL_872A06E3_3546_4804_929D_A512DE4C1392#546878, COL_0FAE0227_5D0A_422A_B526_12CF16B5C8CE#546891, COL_72E7C5E1_DD35_48E8_80FA_08AF51714D5E#546905, COL_0767075F_6D90_4406_A1C5_BC087A39F7CE#546937, COL_9E2EC32D_FCB5_4E43_A453_428839A5DAD4#546987, COL_E53A575D_3952_4C14_AC9F_075847D06BB1#547040, COL_C7343A35_76C1_46A3_B74D_C7263B786745#547096, COL_52134AAB_9340_42E7_9290_A298AF6C9438#547155, COL_95A012EF_312B_40A6_8CFC_200BFD4465E3#547308, COL_1CCAED33_3E69_435E_B522_DAE3B9E63F9D#547373, COL_B72BD372_650E_474E_B8E0_7CB995AE80BF#547443, COL_5E65448D_2CBA_49A0_8E69_D8B1EF0C0EBA#547533]

(50) Project
Output [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756 AS COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [13]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(51) Exchange
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: hashpartitioning(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, 10), ENSURE_REQUIREMENTS, [plan_id=332326]

(52) Sort
Input [14]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Arguments: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693 ASC NULLS FIRST], false, 0

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

(54) Project
Output [1]: [Numéro Séjour#545663 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842]
Input [1]: [Numéro Séjour#545663]

(55) Exchange
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, 10), ENSURE_REQUIREMENTS, [plan_id=332319]

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

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

(58) Filter
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858 <=> 1)

(59) Project
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842 AS 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]

(60) SortMergeJoin
Left keys [1]: [COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693]
Right keys [1]: [00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]
Join type: LeftOuter
Join condition: None

(61) Project
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806 AS COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, str_if_with_rule(((COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> B) OR (COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688 <=> C)), str_remove_space(str_extract_middle(COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, 78, 5), RIGHT), null) AS COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Input [15]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, 00_C_PASSAGE_PA_226115_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#547806]

(62) Exchange
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: hashpartitioning(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 10), ENSURE_REQUIREMENTS, [plan_id=332331]

(63) Sort
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(64) Window
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933]
Arguments: [collect_set(COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933, 0, 0) windowspecdefinition(COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#547972], [COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689], [1 DESC NULLS LAST]

(65) Project
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, 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#547972), true) AS COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_22CFBF1B_0E21_4C64_B658_320E46C18AC2#547933, COL_99B4E8C4_6745_4934_8A73_3229F66B23B0#547972]

(66) Project
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082]

(67) Project
Output [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, str_if_with_rule(((((COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691 <=> 1) AND isnotnull(COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911)) AND (COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102 <=> Oui)) AND ((COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> 0) OR (COL_7283FB96_45C4_411A_901D_417BCF15E684#547690 <=> ))), Eligible, Non Eligible) AS COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, str_if_with_rule((COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082 <=> 0), Non, Oui) AS COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_86C350FA_6356_4025_B9F8_ECC937A6950E#547911, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756, COL_4E463602_5D4E_4B84_A4D5_B483B4237C2A#548082, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102]

(68) Project
Output [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, str_join(array(COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, str_extract(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, LEFT, 1)), -) AS COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#548270, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]
Input [17]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(69) WriteFiles
Input [18]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#547685, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#547686, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#547687, COL_57A29A37_9A17_4B66_8075_897F4B240E81#547688, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#547689, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#547779, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#547693, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#547694, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#547695, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#548211, COL_7283FB96_45C4_411A_901D_417BCF15E684#547690, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#547691, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#547696, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#547697, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#548216, COL_3F6EE217_B885_4F0D_9AE7_146BFA9A86AF#548270, COL_400F4F63_3E70_49ED_B3DD_FB34965B955B#548102, COL_E28DBB78_F6FA_4AFF_952A_934AA92EE854#547756]

(70) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_226165, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_D_DETERMINAT_226165], Overwrite, [COL_016E6242_B446_46F7_97DC_5F775D66196E, 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]

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

SQL / DataFrame Properties

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