digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 0 ms<br>number of written files: 1<br>job commit time: 10 ms<br>number of output rows: 386<br>number of dynamic part: 0<br>written output: 26.1 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (14)\n \nduration: 52 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<br><b>Project</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
}
9 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster10 {
isCluster="true";
label="WholeStageCodegen (13)\n \nduration: 114 ms";
11 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
12 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 28.1 KiB<br>number of coalesced partitions: 1"];
13 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 386<br>local merged chunks fetched: 0<br>shuffle write time: 2 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 386<br>local bytes read: 26.8 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 143.4 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 26.8 KiB"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: 81 ms";
15 [labelType="html" label="<br><b>Project</b><br><br>"];
16 [labelType="html" label="<b>Generate</b><br><br>number of output rows: 386"];
17 [labelType="html" label="<br><b>Project</b><br><br>"];
18 [labelType="html" label="<br><b>Project</b><br><br>"];
19 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 345"];
}
20 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 197 ms";
22 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.3 MiB<br>spill size: 0.0 B"];
23 [labelType="html" label="<br><b>Project</b><br><br>"];
24 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 6,181<br>spill size: 0.0 B"];
}
subgraph cluster25 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 113 ms";
26 [labelType="html" label="<br><b>Project</b><br><br>"];
}
27 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster28 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 116 ms";
29 [labelType="html" label="<br><b>Project</b><br><br>"];
}
30 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster31 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 129 ms";
32 [labelType="html" label="<b>Sort</b><br><br>sort time: 2 ms<br>peak memory: 16.5 MiB<br>spill size: 0.0 B"];
}
33 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 430.8 KiB<br>number of coalesced partitions: 1"];
34 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 12,240<br>local merged chunks fetched: 0<br>shuffle write time: 2 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 12,240<br>local bytes read: 411.5 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 1903.1 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 411.5 KiB"];
subgraph cluster35 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 23 ms";
36 [labelType="html" label="<br><b>Project</b><br><br>"];
37 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 12,240"];
}
38 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster39 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 58 ms";
40 [labelType="html" label="<b>Sort</b><br><br>sort time: 6 ms<br>peak memory: 17.0 MiB<br>spill size: 0.0 B"];
}
41 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 723.7 KiB<br>number of coalesced partitions: 1"];
42 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 24,063<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>5 ms (2 ms, 3 ms, 3 ms (stage 14740.0: task 20471))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 24,063<br>local bytes read: 687.0 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>3.6 MiB (1845.6 KiB, 1882.0 KiB, 1882.0 KiB (stage 14740.0: task 20471))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>687.0 KiB (340.0 KiB, 347.0 KiB, 347.0 KiB (stage 14740.0: task 20471))"];
subgraph cluster43 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n130 ms (56 ms, 74 ms, 74 ms (stage 14740.0: task 20471))";
44 [labelType="html" label="<br><b>Project</b><br><br>"];
}
45 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 24,063"];
subgraph cluster46 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n130 ms (56 ms, 74 ms, 74 ms (stage 14740.0: task 20471))";
47 [labelType="html" label="<br><b>Project</b><br><br>"];
48 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 24,063"];
49 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 24,063<br>number of input batches: 6"];
}
50 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 2<br>scan time total (min, med, max (stageId: taskId))<br>13 ms (6 ms, 7 ms, 7 ms (stage 14740.0: task 20471))<br>metadata time: 0 ms<br>size of files read: 1518.7 KiB<br>number of output rows: 24,063"];
subgraph cluster51 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n13 ms (6 ms, 7 ms, 7 ms (stage 14740.0: task 20472))";
52 [labelType="html" label="<br><b>Project</b><br><br>"];
53 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
}
54 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 2<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.0 B"];
subgraph cluster55 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 0 ms";
56 [labelType="html" label="<b>Sort</b><br><br>sort time: 2 ms<br>peak memory: 16.3 MiB<br>spill size: 0.0 B"];
}
57 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 253.4 KiB<br>number of coalesced partitions: 1"];
58 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 10,259<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>26 ms (1 ms, 2 ms, 4 ms (stage 14741.0: task 20477))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 10,259<br>local bytes read: 242.1 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 10<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>930.8 KiB (90.5 KiB, 92.9 KiB, 95.1 KiB (stage 14741.0: task 20473))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>242.1 KiB (23.5 KiB, 24.2 KiB, 24.8 KiB (stage 14741.0: task 20473))"];
subgraph cluster59 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n241 ms (12 ms, 27 ms, 37 ms (stage 14741.0: task 20474))";
60 [labelType="html" label="<br><b>Project</b><br><br>"];
61 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10,259"];
62 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 45,283<br>number of input batches: 20"];
}
63 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>114 ms (5 ms, 11 ms, 25 ms (stage 14741.0: task 20474))<br>metadata time: 0 ms<br>size of files read: 3.4 MiB<br>number of output rows: 45,283"];
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;
}
64
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832], 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#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1147249, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971]
WholeStageCodegen (14)
Window [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549], [1 DESC NULLS LAST]
Sort [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (13)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 10), ENSURE_REQUIREMENTS, [plan_id=651118]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Generate explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210]
Filter ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087 <=> 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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))
WholeStageCodegen (12)
Window [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST]
Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST], false, 0
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
SortMergeJoin [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767], Inner
WholeStageCodegen (11)
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
WholeStageCodegen (9)
Window [concatwithseparatorudaf(_w0#1145617, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3eb2937, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191) AS _w0#1145617]
WholeStageCodegen (8)
Window [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 10), ENSURE_REQUIREMENTS, [plan_id=650709]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Filter (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409 <=> 1)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST]
Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST], false, 0
WholeStageCodegen (5)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, 10), ENSURE_REQUIREMENTS, [plan_id=650305]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
WholeStageCodegen (3)
CartesianProduct
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193]
Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905,COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_172578], 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#1144886) AND (RC-SSN-SSF = REGLES#1144886)) AND (APPLICABLE#1144887 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#1144886,APPLICABLE#1144887] Batched: false, DataFilters: [isnotnull(REGLES#1144886), (RC-SSN-SSF = REGLES#1144886), (APPLICABLE#1144887 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
Sort [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767 ASC NULLS FIRST], false, 0
WholeStageCodegen (10)
AQEShuffleRead coalesced
Exchange hashpartitioning(02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 10), ENSURE_REQUIREMENTS, [plan_id=650345]
Project [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568 AS 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572 AS 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608 AS 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609 AS 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Filter ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572))
ColumnarToRow
WholeStageCodegen (4)
FileScan parquet [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568,COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572,COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609] Batched: true, DataFilters: [isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567), (A = COL_1DDA21A4_0127_416B_A5DB_7E..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496], 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...
== 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=143.4 KiB, rowCount=386)
+- 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=1903.1 KiB, rowCount=1.22E+4)
: +- Exchange (17)
: +- * Project (16)
: +- * Filter (15)
: +- Window (14)
: +- * Sort (13)
: +- AQEShuffleRead (12)
: +- ShuffleQueryStage (11), Statistics(sizeInBytes=3.6 MiB, rowCount=2.41E+4)
: +- 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=930.8 KiB, rowCount=1.03E+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#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_172578]
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#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
(3) Filter [codegen id : 1]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905)
(4) Project [codegen id : 1]
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
(5) Scan csv
Output [2]: [REGLES#1144886, APPLICABLE#1144887]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new Aigle.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#1144886, APPLICABLE#1144887]
Condition : ((isnotnull(REGLES#1144886) AND (RC-SSN-SSF = REGLES#1144886)) AND (APPLICABLE#1144887 <=> O))
(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#1144886, APPLICABLE#1144887]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Input [5]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193]
(10) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, 10), ENSURE_REQUIREMENTS, [plan_id=650305]
(11) ShuffleQueryStage
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: 0
(12) AQEShuffleRead
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: coalesced
(13) Sort [codegen id : 5]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST], false, 0
(14) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST]
(15) Filter [codegen id : 6]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409 <=> 1)
(16) Project [codegen id : 6]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
(17) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 10), ENSURE_REQUIREMENTS, [plan_id=650709]
(18) ShuffleQueryStage
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: 2
(19) AQEShuffleRead
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: coalesced
(20) Sort [codegen id : 7]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(21) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
(22) Project [codegen id : 8]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191) AS _w0#1145617]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566]
(23) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, _w0#1145617]
Arguments: [concatwithseparatorudaf(_w0#1145617, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3eb2937, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
(24) Project [codegen id : 9]
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, _w0#1145617, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616]
(25) Scan parquet
Output [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496]
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#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
(27) Filter [codegen id : 4]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
Condition : ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572))
(28) Project [codegen id : 4]
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568 AS 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572 AS 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608 AS 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609 AS 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
(29) Exchange
Input [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: hashpartitioning(02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 10), ENSURE_REQUIREMENTS, [plan_id=650345]
(30) ShuffleQueryStage
Output [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: 1
(31) AQEShuffleRead
Input [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: coalesced
(32) Sort [codegen id : 10]
Input [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767 ASC NULLS FIRST], false, 0
(33) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188]
Right keys [1]: [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767]
Join type: Inner
Join condition: None
(34) Project [codegen id : 11]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
(35) Sort [codegen id : 11]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST], false, 0
(36) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST]
(37) Filter [codegen id : 12]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087 <=> 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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))
(38) Project [codegen id : 12]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087]
(39) Project [codegen id : 12]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210]
(40) Generate [codegen id : 12]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411]
(41) Project [codegen id : 12]
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411]
(42) Exchange
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 10), ENSURE_REQUIREMENTS, [plan_id=651118]
(43) ShuffleQueryStage
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: 3
(44) AQEShuffleRead
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: coalesced
(45) Sort [codegen id : 13]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(46) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549], [1 DESC NULLS LAST]
(47) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L]
(48) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971]
(49) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030]
(50) Project [codegen id : 14]
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069]
(51) Project [codegen id : 14]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1147249, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101]
(52) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1147249, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
(53) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832], 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#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905)
(55) Project
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1144905, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1144927, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1144939, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1144947, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1144953]
(56) Filter
Input [2]: [REGLES#1144886, APPLICABLE#1144887]
Condition : ((isnotnull(REGLES#1144886) AND (RC-SSN-SSF = REGLES#1144886)) AND (APPLICABLE#1144887 <=> O))
(57) Project
Output: []
Input [2]: [REGLES#1144886, APPLICABLE#1144887]
(58) CartesianProduct
Join type: Inner
Join condition: None
(59) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Input [5]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193]
(60) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, 10), ENSURE_REQUIREMENTS, [plan_id=650186]
(61) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST], false, 0
(62) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193 ASC NULLS LAST]
(63) Filter
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409 <=> 1)
(64) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1145343, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
(65) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 10), ENSURE_REQUIREMENTS, [plan_id=650192]
(66) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(67) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
(68) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191) AS _w0#1145617]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1145190, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1145191, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566]
(69) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, _w0#1145617]
Arguments: [concatwithseparatorudaf(_w0#1145617, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3eb2937, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [1 DESC NULLS LAST]
(70) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, _w0#1145617, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616]
(71) Filter
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
Condition : ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572))
(72) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568 AS 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572 AS 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608 AS 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609 AS 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1140567, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1140568, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1140572, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1140608, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1140609]
(73) Exchange
Input [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: hashpartitioning(02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 10), ENSURE_REQUIREMENTS, [plan_id=650200]
(74) Sort
Input [4]: [02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
Arguments: [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767 ASC NULLS FIRST], false, 0
(75) SortMergeJoin
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188]
Right keys [1]: [02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767]
Join type: Inner
Join condition: None
(76) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, 02_A_ELIGIBLE_172496_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1145763, 02_A_ELIGIBLE_172496_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1145767, 02_A_ELIGIBLE_172496_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1145803, 02_A_ELIGIBLE_172496_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1145804]
(77) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST], false, 0
(78) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998 DESC NULLS LAST]
(79) Filter
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087 <=> 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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [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#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))
(80) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1145566, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1145192, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1145997, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1146087]
(81) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1146033, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1146191, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1146210]
(82) Generate
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1146386), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411]
(83) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411]
(84) Exchange
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 10), ENSURE_REQUIREMENTS, [plan_id=650213]
(85) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(86) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549]
Arguments: [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549], [1 DESC NULLS LAST]
(87) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1146549, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L]
(88) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1145616, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971]
(89) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1147030]
(90) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1146971, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069]
(91) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1147249, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1146411, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1145998, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1146607L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1147069, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101]
(92) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1145188, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1145994, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1146920, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1147101, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1147249, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1146311, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1145193, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1145379, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1145409]
(93) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_172832], 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