SP1 - Details for Query 11354

Submitted Time: 2026/01/24 15:06:59
Duration: 6 s
Succeeded Jobs: 16896 16897 16901 16907 16921

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)) 0 ms (0 ms, 0 ms, 0 ms (stage 30884.0: task 36885)) number of written files: 2 job commit time: 11 ms number of output rows: 25,424 number of dynamic part: 0 written output: 1169.2 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (463 ms, 905 ms, 905 ms (stage 30884.0: task 36887))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; } 9 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30884.0: task 36885))"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (625 ms, 945 ms, 945 ms (stage 30884.0: task 36887))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 9 ms (3 ms, 6 ms, 6 ms (stage 30884.0: task 36887)) peak memory total (min, med, max (stageId: taskId)) 33.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 30884.0: task 36885)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30884.0: task 36885))"]; } 12 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.1 MiB (1081.4 KiB, 1099.9 KiB, 1099.9 KiB (driver)) number of coalesced partitions: 2"]; 13 [labelType="html" label="Exchange shuffle records written: 25,424 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 31 ms (9 ms, 10 ms, 11 ms (stage 30861.0: task 36826)) 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: 25,424 local bytes read total (min, med, max (stageId: taskId)) 2.0 MiB (1033.6 KiB, 1041.5 KiB, 1041.5 KiB (stage 30884.0: task 36887)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 30884.0: task 36885)) 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)) 9.7 MiB (2.9 MiB, 2.9 MiB, 3.9 MiB (stage 30861.0: task 36826)) 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)) 2.0 MiB (618.7 KiB, 621.4 KiB, 835.0 KiB (stage 30861.0: task 36826))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n2.2 s (531 ms, 542 ms, 1.1 s (stage 30861.0: task 36826))"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Generate number of output rows: 25,424"]; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Filter number of output rows: 20,845"]; } 20 [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 30861.0: task 36824))"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n4.4 s (1.3 s, 1.3 s, 1.8 s (stage 30861.0: task 36826))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 19 ms (2 ms, 3 ms, 14 ms (stage 30861.0: task 36825)) peak memory total (min, med, max (stageId: taskId)) 50.0 MiB (16.5 MiB, 16.5 MiB, 17.0 MiB (stage 30861.0: task 36826)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30861.0: task 36824))"]; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="SortMergeJoin number of output rows: 58,943 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30861.0: task 36824))"]; } subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 0 ms"; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 29 [labelType="html" label=" Project "]; } 30 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 32 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 28 ms (7 ms, 7 ms, 14 ms (stage 30861.0: task 36826)) peak memory total (min, med, max (stageId: taskId)) 51.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 30861.0: task 36824)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30861.0: task 36824))"]; } 33 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 3.6 MiB (1077.0 KiB, 1109.9 KiB, 1451.5 KiB (driver)) number of coalesced partitions: 3"]; 34 [labelType="html" label="Exchange shuffle records written: 103,581 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 24 ms (2 ms, 2 ms, 3 ms (stage 30852.0: task 36780)) 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: 103,581 local bytes read total (min, med, max (stageId: taskId)) 3.4 MiB (1033.0 KiB, 1044.4 KiB, 1380.1 KiB (stage 30861.0: task 36826)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 30861.0: task 36824)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 24 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 15.3 MiB (1532.5 KiB, 1574.7 KiB, 3.1 MiB (stage 30852.0: task 36778)) 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)) 3.4 MiB (340.9 KiB, 350.5 KiB, 685.2 KiB (stage 30852.0: task 36778))"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n2.7 s (134 ms, 328 ms, 493 ms (stage 30852.0: task 36778))"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label="Filter number of output rows: 103,581"]; } 38 [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 30852.0: task 36780))"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n4.7 s (165 ms, 598 ms, 782 ms (stage 30852.0: task 36778))"; 40 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 532 ms (4 ms, 73 ms, 84 ms (stage 30852.0: task 36777)) peak memory total (min, med, max (stageId: taskId)) 180.0 MiB (18.0 MiB, 18.0 MiB, 36.0 MiB (stage 30852.0: task 36777)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30852.0: task 36780))"]; } 41 [labelType="html" label="AQEShuffleRead number of partitions: 8 partition data size total (min, med, max (stageId: taskId)) 10.0 MiB (1035.5 KiB, 1043.3 KiB, 1999.4 KiB (driver)) number of coalesced partitions: 2"]; 42 [labelType="html" label="Exchange shuffle records written: 591,883 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 45 ms (4 ms, 4 ms, 5 ms (stage 30842.0: task 36766)) 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: 591,883 local bytes read total (min, med, max (stageId: taskId)) 9.4 MiB (949.8 KiB, 974.2 KiB, 1923.0 KiB (stage 30852.0: task 36777)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 30852.0: task 36780)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 80 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 90.2 MiB (8.9 MiB, 9.0 MiB, 9.2 MiB (stage 30842.0: task 36744)) 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.4 MiB (942.6 KiB, 958.1 KiB, 980.3 KiB (stage 30842.0: task 36736))"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n3.1 s (257 ms, 276 ms, 486 ms (stage 30842.0: task 36736))"; 44 [labelType="html" label=" Project "]; } 45 [labelType="html" label="CartesianProduct number of output rows: 591,883"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.2 s (257 ms, 276 ms, 501 ms (stage 30842.0: task 36736))"; 47 [labelType="html" label=" Project "]; 48 [labelType="html" label="Filter number of output rows: 591,883"]; 49 [labelType="html" label="ColumnarToRow number of output rows: 591,883 number of input batches: 150"]; } 50 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 87 ms (6 ms, 8 ms, 15 ms (stage 30842.0: task 36762)) metadata time: 0 ms size of files read: 14.2 MiB number of output rows: 591,883"]; subgraph cluster51 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n24 ms (2 ms, 2 ms, 3 ms (stage 30842.0: task 36736))"; 52 [labelType="html" label=" Project "]; 53 [labelType="html" label="Filter number of output rows: 10"]; } 54 [labelType="html" label="Scan csv number of output rows: 10 number of files read: 1 metadata time: 0 ms size of files read: 163.0 B"]; subgraph cluster55 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n3.9 s (1.2 s, 1.3 s, 1.3 s (stage 30861.0: task 36824))"; 56 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 11 ms (2 ms, 4 ms, 5 ms (stage 30861.0: task 36825)) peak memory total (min, med, max (stageId: taskId)) 49.5 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 30861.0: task 36824)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30861.0: task 36824))"]; } 57 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 1272.5 KiB (381.7 KiB, 384.2 KiB, 506.6 KiB (driver)) number of coalesced partitions: 3"]; 58 [labelType="html" label="Exchange shuffle records written: 48,615 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 21 ms (1 ms, 2 ms, 2 ms (stage 30843.0: task 36737)) 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: 48,615 local bytes read total (min, med, max (stageId: taskId)) 1214.5 KiB (363.8 KiB, 364.3 KiB, 486.3 KiB (stage 30861.0: task 36826)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 30861.0: task 36824)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 30 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.7 MiB (464.5 KiB, 481.7 KiB, 491.9 KiB (stage 30843.0: task 36740)) 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)) 1214.5 KiB (117.6 KiB, 121.6 KiB, 124.1 KiB (stage 30843.0: task 36740))"]; subgraph cluster59 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n469 ms (32 ms, 44 ms, 69 ms (stage 30843.0: task 36745))"; 60 [labelType="html" label=" Project "]; 61 [labelType="html" label="Filter number of output rows: 48,615"]; 62 [labelType="html" label="ColumnarToRow number of output rows: 474,437 number of input batches: 120"]; } 63 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 50 ms (4 ms, 4 ms, 11 ms (stage 30843.0: task 36747)) metadata time: 0 ms size of files read: 21.5 MiB number of output rows: 474,437"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; 19->18; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 29->27; 30->29; 32->30; 33->32; 34->33; 36->34; 37->36; 38->37; 40->38; 41->40; 42->41; 44->42; 45->44; 47->45; 48->47; 49->48; 50->49; 52->45; 53->52; 54->53; 56->24; 57->56; 58->57; 60->58; 61->60; 62->61; 63->62; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983], Overwrite, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C]

WriteFiles

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#2344092, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115]

WholeStageCodegen (14)

Window [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388], [1 DESC NULLS LAST]

Sort [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 10), ENSURE_REQUIREMENTS, [plan_id=1166932]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]

Generate explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748]

Filter ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

WholeStageCodegen (12)

Window [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST], false, 0

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]

SortMergeJoin [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292], Inner

WholeStageCodegen (11)

WholeStageCodegen (9)

Window [concatwithseparatorudaf(_w0#2341142, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@62db8afd, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724) AS _w0#2341142]

WholeStageCodegen (8)

Window [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

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

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 10), ENSURE_REQUIREMENTS, [plan_id=1166440]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

Filter (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942 <=> 1)

WholeStageCodegen (6)

Window [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, 10), ENSURE_REQUIREMENTS, [plan_id=1165578]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726]

Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438,COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_161749], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:s...

Project

Filter ((isnotnull(REGLES#2340337) AND (RC-SSN-SSF = REGLES#2340337)) AND (APPLICABLE#2340338 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#2340337,APPLICABLE#2340338] Batched: false, DataFilters: [isnotnull(REGLES#2340337), (RC-SSN-SSF = REGLES#2340337), (APPLICABLE#2340338 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_161411/REGLES-A-TTT.csv], PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Sort [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 10), ENSURE_REQUIREMENTS, [plan_id=1165618]

Project [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649 AS 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653 AS 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689 AS 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690 AS 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]

Filter ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649,COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653,COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690] Batched: true, DataFilters: [isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648), (A = COL_1DDA21A4_0127_416B_A5DB_7E..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_161654], PartitionFilters: [], PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC..., ReadSchema: struct<COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (94)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (53)
   +- WriteFiles (52)
      +- * Project (51)
         +- * Project (50)
            +- * Project (49)
               +- * Project (48)
                  +- * Project (47)
                     +- Window (46)
                        +- * Sort (45)
                           +- AQEShuffleRead (44)
                              +- ShuffleQueryStage (43), Statistics(sizeInBytes=9.7 MiB, rowCount=2.54E+4)
                                 +- Exchange (42)
                                    +- * Project (41)
                                       +- * Generate (40)
                                          +- * Project (39)
                                             +- * Project (38)
                                                +- * Filter (37)
                                                   +- Window (36)
                                                      +- * Sort (35)
                                                         +- * Project (34)
                                                            +- * SortMergeJoin Inner (33)
                                                               :- * Project (24)
                                                               :  +- Window (23)
                                                               :     +- * Project (22)
                                                               :        +- Window (21)
                                                               :           +- * Sort (20)
                                                               :              +- AQEShuffleRead (19)
                                                               :                 +- ShuffleQueryStage (18), Statistics(sizeInBytes=15.3 MiB, rowCount=1.04E+5)
                                                               :                    +- Exchange (17)
                                                               :                       +- * Project (16)
                                                               :                          +- * Filter (15)
                                                               :                             +- Window (14)
                                                               :                                +- * Sort (13)
                                                               :                                   +- AQEShuffleRead (12)
                                                               :                                      +- ShuffleQueryStage (11), Statistics(sizeInBytes=90.2 MiB, rowCount=5.92E+5)
                                                               :                                         +- Exchange (10)
                                                               :                                            +- * Project (9)
                                                               :                                               +- CartesianProduct Inner (8)
                                                               :                                                  :- * Project (4)
                                                               :                                                  :  +- * Filter (3)
                                                               :                                                  :     +- * ColumnarToRow (2)
                                                               :                                                  :        +- Scan parquet  (1)
                                                               :                                                  +- * Project (7)
                                                               :                                                     +- * Filter (6)
                                                               :                                                        +- Scan csv  (5)
                                                               +- * Sort (32)
                                                                  +- AQEShuffleRead (31)
                                                                     +- ShuffleQueryStage (30), Statistics(sizeInBytes=4.7 MiB, rowCount=4.86E+4)
                                                                        +- Exchange (29)
                                                                           +- * Project (28)
                                                                              +- * Filter (27)
                                                                                 +- * ColumnarToRow (26)
                                                                                    +- Scan parquet  (25)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (93)
   +- WriteFiles (92)
      +- Project (91)
         +- Project (90)
            +- Project (89)
               +- Project (88)
                  +- Project (87)
                     +- Window (86)
                        +- Sort (85)
                           +- Exchange (84)
                              +- Project (83)
                                 +- Generate (82)
                                    +- Project (81)
                                       +- Project (80)
                                          +- Filter (79)
                                             +- Window (78)
                                                +- Sort (77)
                                                   +- Project (76)
                                                      +- SortMergeJoin Inner (75)
                                                         :- Project (70)
                                                         :  +- Window (69)
                                                         :     +- Project (68)
                                                         :        +- Window (67)
                                                         :           +- Sort (66)
                                                         :              +- Exchange (65)
                                                         :                 +- Project (64)
                                                         :                    +- Filter (63)
                                                         :                       +- Window (62)
                                                         :                          +- Sort (61)
                                                         :                             +- Exchange (60)
                                                         :                                +- Project (59)
                                                         :                                   +- CartesianProduct Inner (58)
                                                         :                                      :- Project (55)
                                                         :                                      :  +- Filter (54)
                                                         :                                      :     +- Scan parquet  (1)
                                                         :                                      +- Project (57)
                                                         :                                         +- Filter (56)
                                                         :                                            +- Scan csv  (5)
                                                         +- Sort (74)
                                                            +- Exchange (73)
                                                               +- Project (72)
                                                                  +- Filter (71)
                                                                     +- Scan parquet  (25)


(1) Scan parquet 
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_161749]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:string,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157:string,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>

(2) ColumnarToRow [codegen id : 1]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]

(3) Filter [codegen id : 1]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438)

(4) Project [codegen id : 1]
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]

(5) Scan csv 
Output [2]: [REGLES#2340337, APPLICABLE#2340338]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_161411/REGLES-A-TTT.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(6) Filter [codegen id : 2]
Input [2]: [REGLES#2340337, APPLICABLE#2340338]
Condition : ((isnotnull(REGLES#2340337) AND (RC-SSN-SSF = REGLES#2340337)) AND (APPLICABLE#2340338 <=> O))

(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#2340337, APPLICABLE#2340338]

(8) CartesianProduct
Join type: Inner
Join condition: None

(9) Project [codegen id : 3]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Input [5]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726]

(10) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, 10), ENSURE_REQUIREMENTS, [plan_id=1165578]

(11) ShuffleQueryStage
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: 0

(12) AQEShuffleRead
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: coalesced

(13) Sort [codegen id : 5]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST], false, 0

(14) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST]

(15) Filter [codegen id : 6]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942 <=> 1)

(16) Project [codegen id : 6]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

(17) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 10), ENSURE_REQUIREMENTS, [plan_id=1166440]

(18) ShuffleQueryStage
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: 2

(19) AQEShuffleRead
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: coalesced

(20) Sort [codegen id : 7]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(21) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

(22) Project [codegen id : 8]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724) AS _w0#2341142]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091]

(23) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, _w0#2341142]
Arguments: [concatwithseparatorudaf(_w0#2341142, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@62db8afd, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

(24) Project [codegen id : 9]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, _w0#2341142, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141]

(25) Scan parquet 
Output [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_161654]
PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A), IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_95383EBC_3648_4E94_9C53_D311092BF5F4:array<string>,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD:string>

(26) ColumnarToRow [codegen id : 4]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]

(27) Filter [codegen id : 4]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]
Condition : ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653))

(28) Project [codegen id : 4]
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649 AS 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653 AS 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689 AS 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690 AS 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]

(29) Exchange
Input [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: hashpartitioning(02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 10), ENSURE_REQUIREMENTS, [plan_id=1165618]

(30) ShuffleQueryStage
Output [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: 1

(31) AQEShuffleRead
Input [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: coalesced

(32) Sort [codegen id : 10]
Input [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292 ASC NULLS FIRST], false, 0

(33) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721]
Right keys [1]: [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292]
Join type: Inner
Join condition: None

(34) Project [codegen id : 11]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]

(35) Sort [codegen id : 11]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST], false, 0

(36) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST]

(37) Filter [codegen id : 12]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

(38) Project [codegen id : 12]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612]

(39) Project [codegen id : 12]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716)),  : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558)),  : )),  - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748]

(40) Generate [codegen id : 12]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962]

(41) Project [codegen id : 12]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962]

(42) Exchange
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 10), ENSURE_REQUIREMENTS, [plan_id=1166932]

(43) ShuffleQueryStage
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: 3

(44) AQEShuffleRead
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: coalesced

(45) Sort [codegen id : 13]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(46) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388], [1 DESC NULLS LAST]

(47) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L]

(48) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115]

(49) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383]

(50) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487]

(51) Project [codegen id : 14]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#2344092, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636]

(52) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#2344092, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

(53) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983], Overwrite, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C]

(54) Filter
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438)

(55) Project
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2340438, COL_7D270645_B926_42AF_A110_EB3A1A53031B#2340460, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#2340472, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#2340480, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#2340486]

(56) Filter
Input [2]: [REGLES#2340337, APPLICABLE#2340338]
Condition : ((isnotnull(REGLES#2340337) AND (RC-SSN-SSF = REGLES#2340337)) AND (APPLICABLE#2340338 <=> O))

(57) Project
Output: []
Input [2]: [REGLES#2340337, APPLICABLE#2340338]

(58) CartesianProduct
Join type: Inner
Join condition: None

(59) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Input [5]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726]

(60) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, 10), ENSURE_REQUIREMENTS, [plan_id=1165459]

(61) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST], false, 0

(62) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726 ASC NULLS LAST]

(63) Filter
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942 <=> 1)

(64) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#2340876, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

(65) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 10), ENSURE_REQUIREMENTS, [plan_id=1165465]

(66) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(67) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

(68) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724) AS _w0#2341142]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#2340723, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#2340724, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091]

(69) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, _w0#2341142]
Arguments: [concatwithseparatorudaf(_w0#2341142, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@62db8afd, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [1 DESC NULLS LAST]

(70) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, _w0#2341142, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141]

(71) Filter
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]
Condition : ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653))

(72) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649 AS 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653 AS 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689 AS 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690 AS 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#2338648, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2338649, COL_F76265AB_8748_4114_92B4_00E37DE25D34#2338653, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2338689, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2338690]

(73) Exchange
Input [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: hashpartitioning(02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 10), ENSURE_REQUIREMENTS, [plan_id=1165473]

(74) Sort
Input [4]: [02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]
Arguments: [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292 ASC NULLS FIRST], false, 0

(75) SortMergeJoin
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721]
Right keys [1]: [02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292]
Join type: Inner
Join condition: None

(76) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, 02_A_ELIGIBLE_161654_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#2341288, 02_A_ELIGIBLE_161654_COL_F76265AB_8748_4114_92B4_00E37DE25D34#2341292, 02_A_ELIGIBLE_161654_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#2341328, 02_A_ELIGIBLE_161654_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#2341329]

(77) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST], false, 0

(78) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523 DESC NULLS LAST]

(79) Filter
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

(80) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#2341091, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#2340725, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#2341522, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#2341612]

(81) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716)),  : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558)),  : )),  - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#2341558, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#2341716, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#2341748]

(82) Generate
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#2341937), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962]

(83) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962]

(84) Exchange
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 10), ENSURE_REQUIREMENTS, [plan_id=1165486]

(85) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(86) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388]
Arguments: [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388], [1 DESC NULLS LAST]

(87) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#2342388, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L]

(88) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#2341141, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115]

(89) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#2343383]

(90) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#2343115, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487]

(91) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#2344092, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#2341962, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#2341523, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#2342621L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#2343487, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636]

(92) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#2340721, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#2341519, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#2343022, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#2343636, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#2344092, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#2341846, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#2340726, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#2340912, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#2340942]

(93) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_161983], Overwrite, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C]

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

SQL / DataFrame Properties

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