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 total (min, med, max (stageId: taskId))<br>1 ms (0 ms, 1 ms, 1 ms (stage 15191.0: task 21031))<br>number of written files: 2<br>job commit time: 8 ms<br>number of output rows: 4,996<br>number of dynamic part: 0<br>written output: 227.8 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (14)\n \nduration: total (min, med, max (stageId: taskId))\n1.2 s (488 ms, 666 ms, 666 ms (stage 15191.0: task 21031))";
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="<b>Filter</b><br><br>number of output rows: 4,996"];
8 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 34,259<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15191.0: task 21030))"];
}
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n1.5 s (683 ms, 858 ms, 858 ms (stage 15191.0: task 21031))";
10 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>8 ms (2 ms, 6 ms, 6 ms (stage 15191.0: task 21031))<br>peak memory total (min, med, max (stageId: taskId))<br>33.0 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 15191.0: task 21030))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15191.0: task 21030))"];
}
11 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>2.5 MiB (1022.8 KiB, 1527.7 KiB, 1527.7 KiB (driver))<br>number of coalesced partitions: 2"];
12 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 34,259<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>30 ms (2 ms, 2 ms, 4 ms (stage 15178.0: task 21017))<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: 34,259<br>local bytes read total (min, med, max (stageId: taskId))<br>2.4 MiB (978.4 KiB, 1453.0 KiB, 1453.0 KiB (stage 15191.0: task 21031))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 15191.0: task 21030))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 20<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>8.2 MiB (818.2 KiB, 845.7 KiB, 849.2 KiB (stage 15178.0: task 21016))<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>2.4 MiB (237.6 KiB, 245.3 KiB, 247.0 KiB (stage 15178.0: task 21016))"];
subgraph cluster13 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.9 s (268 ms, 293 ms, 334 ms (stage 15178.0: task 21022))";
14 [labelType="html" label="<br><b>Project</b><br><br>"];
15 [labelType="html" label="<br><b>Project</b><br><br>"];
16 [labelType="html" label="<br><b>Project</b><br><br>"];
17 [labelType="html" label="<br><b>Project</b><br><br>"];
18 [labelType="html" label="<br><b>Project</b><br><br>"];
19 [labelType="html" label="<br><b>Project</b><br><br>"];
}
20 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 34,259"];
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.0 s (269 ms, 294 ms, 335 ms (stage 15178.0: task 21022))";
22 [labelType="html" label="<br><b>Project</b><br><br>"];
23 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 34,259"];
24 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 34,259<br>number of input batches: 10"];
}
25 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>97 ms (6 ms, 8 ms, 21 ms (stage 15178.0: task 21022))<br>metadata time: 0 ms<br>size of files read: 5.7 MiB<br>number of output rows: 34,259"];
subgraph cluster26 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n60 ms (4 ms, 6 ms, 9 ms (stage 15178.0: task 21019))";
27 [labelType="html" label="<br><b>Project</b><br><br>"];
28 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10"];
}
29 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 10<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.0 B"];
subgraph cluster30 {
isCluster="true";
label="WholeStageCodegen (13)\n \nduration: 777 ms";
31 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 15191.0: task 21030))<br>peak memory total (min, med, max (stageId: taskId))<br>33.5 MiB (16.5 MiB, 17.0 MiB, 17.0 MiB (stage 15191.0: task 21031))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15191.0: task 21030))"];
}
32 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 43,029<br>time in aggregation build total (min, med, max (stageId: taskId))<br>124 ms (58 ms, 66 ms, 66 ms (stage 15191.0: task 21031))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15191.0: task 21030))<br>number of sort fallback tasks: 2"];
33 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>823.0 KiB (329.2 KiB, 493.8 KiB, 493.8 KiB (driver))<br>number of coalesced partitions: 2"];
34 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 43,029<br>local merged chunks fetched: 0<br>shuffle write time: 5 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: 43,029<br>local bytes read total (min, med, max (stageId: taskId))<br>794.8 KiB (318.9 KiB, 475.9 KiB, 475.9 KiB (stage 15191.0: task 21031))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 15191.0: task 21030))<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: 3.9 MiB<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: 794.8 KiB"];
35 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 43,029<br>time in aggregation build: 195 ms<br>spill size: 0.0 B<br>number of sort fallback tasks: 1"];
subgraph cluster36 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 178 ms";
37 [labelType="html" label="<br><b>Project</b><br><br>"];
38 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 43,054<br>spill size: 0.0 B"];
}
subgraph cluster39 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 179 ms";
40 [labelType="html" label="<br><b>Project</b><br><br>"];
41 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 43,054<br>spill size: 0.0 B"];
}
subgraph cluster42 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 181 ms";
43 [labelType="html" label="<b>Sort</b><br><br>sort time: 18 ms<br>peak memory: 17.0 MiB<br>spill size: 0.0 B"];
}
44 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 579.2 KiB<br>number of coalesced partitions: 1"];
45 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 43,054<br>local merged chunks fetched: 0<br>shuffle write time: 3 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: 43,054<br>local bytes read: 556.2 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: 2018.2 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: 556.2 KiB"];
subgraph cluster46 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 212 ms";
47 [labelType="html" label="<br><b>Project</b><br><br>"];
48 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 43,054"];
}
49 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 43,054<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 630.4 KiB"];
subgraph cluster50 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 2.6 m";
51 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
52 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 19.3 KiB<br>number of coalesced partitions: 1"];
53 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1,470<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: 1,470<br>local bytes read: 18.2 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: 57.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: 18.2 KiB"];
subgraph cluster54 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 16 ms";
55 [labelType="html" label="<br><b>Project</b><br><br>"];
56 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1,470"];
57 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1,470<br>number of input batches: 1"];
}
58 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 42.4 KiB<br>number of output rows: 1,470"];
subgraph cluster59 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 0 ms";
60 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
61 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 32.6 KiB<br>number of coalesced partitions: 1"];
62 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 2,574<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: 2,574<br>local bytes read: 31.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: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 100.5 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: 31.1 KiB"];
subgraph cluster63 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 18 ms";
64 [labelType="html" label="<br><b>Project</b><br><br>"];
65 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2,574"];
66 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2,576<br>number of input batches: 1"];
}
67 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 57.3 KiB<br>number of output rows: 2,576"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
8->7;
10->8;
11->10;
12->11;
14->12;
15->14;
16->15;
17->16;
18->17;
19->18;
20->19;
22->20;
23->22;
24->23;
25->24;
27->20;
28->27;
29->28;
31->8;
32->31;
33->32;
34->33;
35->34;
37->35;
38->37;
40->38;
41->40;
43->41;
44->43;
45->44;
47->45;
48->47;
49->48;
51->41;
52->51;
53->52;
55->53;
56->55;
57->56;
58->57;
60->38;
61->60;
62->61;
64->62;
65->64;
66->65;
67->66;
}
68
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979], Overwrite, [COL_6D461599_696B_4415_9E1E_62284656C432, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5, COL_5276B642_7FD3_4362_A102_7091D784BB77, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267, COL_96193E27_D3D2_4476_8CFF_4911255A14C5]
WriteFiles
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1181619, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1181620, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1181621]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413]
Filter (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
SortMergeJoin [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147], [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293], LeftOuter
WholeStageCodegen (14)
Sort [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147 ASC NULLS FIRST], false, 0
WholeStageCodegen (12)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, 10), ENSURE_REQUIREMENTS, [plan_id=615790]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#1180669, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420]
WholeStageCodegen (3)
CartesianProduct
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469 AS COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159]
Filter isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476,COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F)], ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:s...
Project [APPLICABLE#1178446 AS REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184]
Filter ((isnotnull(REGLES#1178445) AND (RC-FU-PE = REGLES#1178445)) AND (APPLICABLE#1178446 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#1178445,APPLICABLE#1178446] Batched: false, DataFilters: [isnotnull(REGLES#1178445), (RC-FU-PE = REGLES#1178445), (APPLICABLE#1178446 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FU-PE), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
Sort [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293 ASC NULLS FIRST], false, 0
WholeStageCodegen (13)
ObjectHashAggregate(keys=[COL_A188B73D_4933_4923_828E_687FE72CE189#1179667], functions=[max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)])
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, 10), ENSURE_REQUIREMENTS, [plan_id=616194]
ObjectHashAggregate(keys=[COL_A188B73D_4933_4923_828E_687FE72CE189#1179667], functions=[partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)])
Project [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822]
SortMergeJoin [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668], [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758], LeftOuter
WholeStageCodegen (11)
Project [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737]
SortMergeJoin [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668], [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686], LeftOuter
WholeStageCodegen (9)
Sort [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668 ASC NULLS FIRST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, 10), ENSURE_REQUIREMENTS, [plan_id=615866]
Project [str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, str_remove_extend(str_remove_space(code_Cim10#1178554, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Filter (isnotnull(code_Cim10#1178554) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT)))
WholeStageCodegen (4)
FileScan csv [Numéro Séjour#1178553,code_Cim10#1178554] Batched: false, DataFilters: [isnotnull(code_Cim10#1178554), isnotnull(str_complete(str_remove_space(Numéro Séjour#1178553, AL..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/04_DIAGNOSTICS__175674/diag_patient_Gra..., PartitionFilters: [], PushedFilters: [IsNotNull(code_Cim10)], ReadSchema: struct<Numéro Séjour:string,code_Cim10:string>
Sort [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686, 10), ENSURE_REQUIREMENTS, [plan_id=615886]
Project [str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Filter isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT))
ColumnarToRow
WholeStageCodegen (5)
FileScan parquet [Code+CIM+10#1179373] Batched: true, DataFilters: [isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__175693_0b6a6a134cce..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code+CIM+10:string>
Sort [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758 ASC NULLS FIRST], false, 0
WholeStageCodegen (10)
AQEShuffleRead coalesced
Exchange hashpartitioning(DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758, 10), ENSURE_REQUIREMENTS, [plan_id=615909]
Project [str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Filter isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT))
ColumnarToRow
WholeStageCodegen (6)
FileScan parquet [Code+CIM+10#1179514] Batched: true, DataFilters: [isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__175695_9226ef765e96..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code+CIM+10:string>
== Physical Plan ==
AdaptiveSparkPlan (99)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (58)
+- WriteFiles (57)
+- * Project (56)
+- * Project (55)
+- * Project (54)
+- * Filter (53)
+- * SortMergeJoin LeftOuter (52)
:- * Sort (18)
: +- AQEShuffleRead (17)
: +- ShuffleQueryStage (16), Statistics(sizeInBytes=8.2 MiB, rowCount=3.43E+4)
: +- Exchange (15)
: +- * Project (14)
: +- * Project (13)
: +- * Project (12)
: +- * Project (11)
: +- * Project (10)
: +- * Project (9)
: +- CartesianProduct Inner (8)
: :- * Project (4)
: : +- * Filter (3)
: : +- * ColumnarToRow (2)
: : +- Scan parquet (1)
: +- * Project (7)
: +- * Filter (6)
: +- Scan csv (5)
+- * Sort (51)
+- ObjectHashAggregate (50)
+- AQEShuffleRead (49)
+- ShuffleQueryStage (48), Statistics(sizeInBytes=3.9 MiB, rowCount=4.30E+4)
+- Exchange (47)
+- ObjectHashAggregate (46)
+- * Project (45)
+- * SortMergeJoin LeftOuter (44)
:- * Project (35)
: +- * SortMergeJoin LeftOuter (34)
: :- * Sort (25)
: : +- AQEShuffleRead (24)
: : +- ShuffleQueryStage (23), Statistics(sizeInBytes=2018.2 KiB, rowCount=4.31E+4)
: : +- Exchange (22)
: : +- * Project (21)
: : +- * Filter (20)
: : +- Scan csv (19)
: +- * Sort (33)
: +- AQEShuffleRead (32)
: +- ShuffleQueryStage (31), Statistics(sizeInBytes=57.4 KiB, rowCount=1.47E+3)
: +- Exchange (30)
: +- * Project (29)
: +- * Filter (28)
: +- * ColumnarToRow (27)
: +- Scan parquet (26)
+- * Sort (43)
+- AQEShuffleRead (42)
+- ShuffleQueryStage (41), Statistics(sizeInBytes=100.5 KiB, rowCount=2.57E+3)
+- Exchange (40)
+- * Project (39)
+- * Filter (38)
+- * ColumnarToRow (37)
+- Scan parquet (36)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (98)
+- WriteFiles (97)
+- Project (96)
+- Project (95)
+- Project (94)
+- Filter (93)
+- SortMergeJoin LeftOuter (92)
:- Sort (71)
: +- Exchange (70)
: +- Project (69)
: +- Project (68)
: +- Project (67)
: +- Project (66)
: +- Project (65)
: +- Project (64)
: +- CartesianProduct Inner (63)
: :- Project (60)
: : +- Filter (59)
: : +- Scan parquet (1)
: +- Project (62)
: +- Filter (61)
: +- Scan csv (5)
+- Sort (91)
+- ObjectHashAggregate (90)
+- Exchange (89)
+- ObjectHashAggregate (88)
+- Project (87)
+- SortMergeJoin LeftOuter (86)
:- Project (81)
: +- SortMergeJoin LeftOuter (80)
: :- Sort (75)
: : +- Exchange (74)
: : +- Project (73)
: : +- Filter (72)
: : +- Scan csv (19)
: +- Sort (79)
: +- Exchange (78)
: +- Project (77)
: +- Filter (76)
: +- Scan parquet (26)
+- Sort (85)
+- Exchange (84)
+- Project (83)
+- Filter (82)
+- Scan parquet (36)
(1) Scan parquet
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_175988]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2:double>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
(3) Filter [codegen id : 1]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469)
(4) Project [codegen id : 1]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469 AS COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
(5) Scan csv
Output [2]: [REGLES#1178445, APPLICABLE#1178446]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/REGLES-A-TTT new GRASSE 290126.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FU-PE), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#1178445, APPLICABLE#1178446]
Condition : ((isnotnull(REGLES#1178445) AND (RC-FU-PE = REGLES#1178445)) AND (APPLICABLE#1178446 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#1178446 AS REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184]
Input [2]: [REGLES#1178445, APPLICABLE#1178446]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184]
(10) Project [codegen id : 3]
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#1180669, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420]
(11) Project [codegen id : 3]
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668, COL_191330F1_7160_4037_ADAF_25928A72A739#1180669, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701]
(12) Project [codegen id : 3]
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831]
(13) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083]
(14) Project [codegen id : 3]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
(15) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, 10), ENSURE_REQUIREMENTS, [plan_id=615790]
(16) ShuffleQueryStage
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: 0
(17) AQEShuffleRead
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: coalesced
(18) Sort [codegen id : 12]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147 ASC NULLS FIRST], false, 0
(19) Scan csv
Output [2]: [Numéro Séjour#1178553, code_Cim10#1178554]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/04_DIAGNOSTICS__175674/diag_patient_Grasse_2025.csv]
PushedFilters: [IsNotNull(code_Cim10)]
ReadSchema: struct<Numéro Séjour:string,code_Cim10:string>
(20) Filter [codegen id : 4]
Input [2]: [Numéro Séjour#1178553, code_Cim10#1178554]
Condition : (isnotnull(code_Cim10#1178554) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT)))
(21) Project [codegen id : 4]
Output [2]: [str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, str_remove_extend(str_remove_space(code_Cim10#1178554, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Input [2]: [Numéro Séjour#1178553, code_Cim10#1178554]
(22) Exchange
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, 10), ENSURE_REQUIREMENTS, [plan_id=615866]
(23) ShuffleQueryStage
Output [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: 1
(24) AQEShuffleRead
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: coalesced
(25) Sort [codegen id : 7]
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668 ASC NULLS FIRST], false, 0
(26) Scan parquet
Output [1]: [Code+CIM+10#1179373]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__175693_0b6a6a134cce716a155853e393041aff/DP_PE1.xlsx_c41296e3225d89905b563b2d98d34051]
ReadSchema: struct<Code+CIM+10:string>
(27) ColumnarToRow [codegen id : 5]
Input [1]: [Code+CIM+10#1179373]
(28) Filter [codegen id : 5]
Input [1]: [Code+CIM+10#1179373]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT))
(29) Project [codegen id : 5]
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Input [1]: [Code+CIM+10#1179373]
(30) Exchange
Input [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: hashpartitioning(DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686, 10), ENSURE_REQUIREMENTS, [plan_id=615886]
(31) ShuffleQueryStage
Output [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: 2
(32) AQEShuffleRead
Input [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: coalesced
(33) Sort [codegen id : 8]
Input [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686 ASC NULLS FIRST], false, 0
(34) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Right keys [1]: [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Join type: LeftOuter
Join condition: None
(35) Project [codegen id : 9]
Output [3]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737]
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
(36) Scan parquet
Output [1]: [Code+CIM+10#1179514]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__175695_9226ef765e96a81da4c228e928186478/DP_PE2.xlsx_fade5fd5e40efe52871e520371c0b4c9]
ReadSchema: struct<Code+CIM+10:string>
(37) ColumnarToRow [codegen id : 6]
Input [1]: [Code+CIM+10#1179514]
(38) Filter [codegen id : 6]
Input [1]: [Code+CIM+10#1179514]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT))
(39) Project [codegen id : 6]
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Input [1]: [Code+CIM+10#1179514]
(40) Exchange
Input [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: hashpartitioning(DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758, 10), ENSURE_REQUIREMENTS, [plan_id=615909]
(41) ShuffleQueryStage
Output [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: 3
(42) AQEShuffleRead
Input [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: coalesced
(43) Sort [codegen id : 10]
Input [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758 ASC NULLS FIRST], false, 0
(44) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Right keys [1]: [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Join type: LeftOuter
Join condition: None
(45) Project [codegen id : 11]
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822]
Input [5]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
(46) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667]
Functions [3]: [partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max#1181767, max#1181633, buf#1181768]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
(47) Exchange
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Arguments: hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, 10), ENSURE_REQUIREMENTS, [plan_id=616194]
(48) ShuffleQueryStage
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Arguments: 4
(49) AQEShuffleRead
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Arguments: coalesced
(50) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667]
Functions [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737)#1179841, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822)#1179843, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668))#1179847]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667 AS 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737)#1179841 AS 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822)#1179843 AS 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668))#1179847 AS 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
(51) Sort [codegen id : 13]
Input [4]: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
Arguments: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293 ASC NULLS FIRST], false, 0
(52) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147]
Right keys [1]: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293]
Join type: LeftOuter
Join condition: None
(53) Filter [codegen id : 14]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(54) Project [codegen id : 14]
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
(55) Project [codegen id : 14]
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413]
(56) Project [codegen id : 14]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1181619, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1181620, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1181621]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532]
(57) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1181619, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1181620, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1181621]
(58) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979], Overwrite, [COL_6D461599_696B_4415_9E1E_62284656C432, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5, COL_5276B642_7FD3_4362_A102_7091D784BB77, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267, COL_96193E27_D3D2_4476_8CFF_4911255A14C5]
(59) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469)
(60) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469 AS COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1178469, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1178472, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1178473, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1178474, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1178476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1178481, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1178485]
(61) Filter
Input [2]: [REGLES#1178445, APPLICABLE#1178446]
Condition : ((isnotnull(REGLES#1178445) AND (RC-FU-PE = REGLES#1178445)) AND (APPLICABLE#1178446 <=> O))
(62) Project
Output [1]: [APPLICABLE#1178446 AS REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184]
Input [2]: [REGLES#1178445, APPLICABLE#1178446]
(63) CartesianProduct
Join type: Inner
Join condition: None
(64) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, REGLES_A_APPLIQ_175810_APPLICABLE_175812#1180184]
(65) Project
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#1180669, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#1180420]
(66) Project
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#1180669 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#1180667, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#1180668, COL_191330F1_7160_4037_ADAF_25928A72A739#1180669, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701]
(67) Project
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1180146, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1180150, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1180159, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#1180666, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#1180670, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#1180701, COL_B85FC0C7_A95C_499F_9883_0232DA327922#1180732, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#1180764, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#1180797, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#1180831]
(68) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083]
(69) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#1181083, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#1181223, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
(70) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, 10), ENSURE_REQUIREMENTS, [plan_id=615726]
(71) Sort
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046]
Arguments: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147 ASC NULLS FIRST], false, 0
(72) Filter
Input [2]: [Numéro Séjour#1178553, code_Cim10#1178554]
Condition : (isnotnull(code_Cim10#1178554) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT)))
(73) Project
Output [2]: [str_complete(str_remove_space(Numéro Séjour#1178553, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, str_remove_extend(str_remove_space(code_Cim10#1178554, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Input [2]: [Numéro Séjour#1178553, code_Cim10#1178554]
(74) Exchange
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, 10), ENSURE_REQUIREMENTS, [plan_id=615708]
(75) Sort
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Arguments: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668 ASC NULLS FIRST], false, 0
(76) Filter
Input [1]: [Code+CIM+10#1179373]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT))
(77) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179373, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Input [1]: [Code+CIM+10#1179373]
(78) Exchange
Input [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: hashpartitioning(DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686, 10), ENSURE_REQUIREMENTS, [plan_id=615709]
(79) Sort
Input [2]: [DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Arguments: [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686 ASC NULLS FIRST], false, 0
(80) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Right keys [1]: [DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
Join type: LeftOuter
Join condition: None
(81) Project
Output [3]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737]
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, DIAGNOSTIC_PE1__175730_CODE_CIM_10_175731#1179680, DIAGNOSTIC_PE1__175730_CODE_CIM10_NORM_175737#1179686]
(82) Filter
Input [1]: [Code+CIM+10#1179514]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT))
(83) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1179514, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Input [1]: [Code+CIM+10#1179514]
(84) Exchange
Input [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: hashpartitioning(DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758, 10), ENSURE_REQUIREMENTS, [plan_id=615716]
(85) Sort
Input [2]: [DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Arguments: [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758 ASC NULLS FIRST], false, 0
(86) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668]
Right keys [1]: [DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
Join type: LeftOuter
Join condition: None
(87) Project
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822]
Input [5]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, DIAGNOSTIC_PE2__175813_CODE_CIM_10_175814#1179752, DIAGNOSTIC_PE2__175813_CODE_CIM10_NORM_175820#1179758]
(88) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667]
Functions [3]: [partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max#1181767, max#1181633, buf#1181768]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
(89) Exchange
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Arguments: hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, 10), ENSURE_REQUIREMENTS, [plan_id=615722]
(90) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667, max#1181769, max#1181636, buf#1181770]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667]
Functions [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6b9c542f, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737)#1179841, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822)#1179843, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668))#1179847]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#1179667 AS 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1179737)#1179841 AS 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1179822)#1179843 AS 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1179668))#1179847 AS 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
(91) Sort
Input [4]: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
Arguments: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293 ASC NULLS FIRST], false, 0
(92) SortMergeJoin
Left keys [1]: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147]
Right keys [1]: [00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293]
Join type: LeftOuter
Join condition: None
(93) Filter
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(94) Project
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_if_with_rule((((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE1) END AND (((00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, PE2) END AND (((00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272 <=> 0)) OR isnull(00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1180155, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#1181272, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, 00_E_DIAGNOSTIC_176292_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1181293, 00_E_DIAGNOSTIC_176292_COL_22F494F7_741E_40CC_932F_1428DA298F77#1181294, 00_E_DIAGNOSTIC_176292_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1181295, 00_E_DIAGNOSTIC_176292_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1181296]
(95) Project
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#1181221, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#1181398, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#1181413]
(96) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1181619, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1181620, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1181621]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#1181375, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#1181376, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1180148, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#1181046, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_152219DE_9E30_4C72_B6C4_3536674868FD#1181513, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532]
(97) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#1180143, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1180147, COL_5276B642_7FD3_4362_A102_7091D784BB77#1180212, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#1181377, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1181532, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1181619, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1181620, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1181621]
(98) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__175979], Overwrite, [COL_6D461599_696B_4415_9E1E_62284656C432, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5, COL_5276B642_7FD3_4362_A102_7091D784BB77, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267, COL_96193E27_D3D2_4476_8CFF_4911255A14C5]
(99) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true