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>0 ms (0 ms, 0 ms, 0 ms (stage 12841.0: task 16881))<br>number of written files: 3<br>job commit time: 14 ms<br>number of output rows: 173<br>number of dynamic part: 0<br>written output: 20.9 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.1 s (314 ms, 358 ms, 397 ms (stage 12841.0: task 16883))";
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: 173"];
8 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 38,684<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 12841.0: task 16881))"];
}
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (411 ms, 455 ms, 495 ms (stage 12841.0: task 16883))";
10 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>9 ms (2 ms, 3 ms, 4 ms (stage 12841.0: task 16883))<br>peak memory total (min, med, max (stageId: taskId))<br>49.5 MiB (16.5 MiB, 16.5 MiB, 16.5 MiB (stage 12841.0: task 16881))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 12841.0: task 16881))"];
}
11 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 3<br>partition data size total (min, med, max (stageId: taskId))<br>2.7 MiB (815.6 KiB, 844.9 KiB, 1106.9 KiB (driver))<br>number of coalesced partitions: 3"];
12 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 38,684<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>19 ms (1 ms, 1 ms, 2 ms (stage 12822.0: task 16868))<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: 38,684<br>local bytes read total (min, med, max (stageId: taskId))<br>2.6 MiB (782.1 KiB, 803.7 KiB, 1056.4 KiB (stage 12841.0: task 16883))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 12841.0: task 16881))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 30<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>9.3 MiB (939.6 KiB, 949.3 KiB, 962.5 KiB (stage 12822.0: task 16866))<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.6 MiB (260.6 KiB, 264.8 KiB, 267.3 KiB (stage 12822.0: task 16866))"];
subgraph cluster13 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.4 s (211 ms, 227 ms, 317 ms (stage 12822.0: task 16868))";
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: 38,684"];
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.4 s (212 ms, 227 ms, 318 ms (stage 12822.0: task 16868))";
22 [labelType="html" label="<br><b>Project</b><br><br>"];
23 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 38,684"];
24 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 38,684<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>66 ms (4 ms, 6 ms, 10 ms (stage 12822.0: task 16872))<br>metadata time: 0 ms<br>size of files read: 6.0 MiB<br>number of output rows: 38,684"];
subgraph cluster26 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n62 ms (3 ms, 6 ms, 11 ms (stage 12822.0: task 16872))";
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: 0 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 12841.0: task 16881))<br>peak memory total (min, med, max (stageId: taskId))<br>50.0 MiB (16.5 MiB, 16.5 MiB, 17.0 MiB (stage 12841.0: task 16883))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 12841.0: task 16881))"];
}
32 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 64,613<br>time in aggregation build total (min, med, max (stageId: taskId))<br>107 ms (35 ms, 35 ms, 37 ms (stage 12841.0: task 16882))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 12841.0: task 16881))<br>number of sort fallback tasks: 3"];
33 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 3<br>partition data size total (min, med, max (stageId: taskId))<br>1205.0 KiB (361.5 KiB, 361.5 KiB, 482.0 KiB (driver))<br>number of coalesced partitions: 3"];
34 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 64,613<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: 64,613<br>local bytes read total (min, med, max (stageId: taskId))<br>1124.5 KiB (336.5 KiB, 338.2 KiB, 449.8 KiB (stage 12841.0: task 16883))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 12841.0: task 16881))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 3<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 5.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: 1124.5 KiB"];
35 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 64,613<br>time in aggregation build: 226 ms<br>spill size: 0.0 B<br>number of sort fallback tasks: 1"];
subgraph cluster36 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 189 ms";
37 [labelType="html" label="<br><b>Project</b><br><br>"];
38 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 64,613<br>spill size: 0.0 B"];
}
subgraph cluster39 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 191 ms";
40 [labelType="html" label="<br><b>Project</b><br><br>"];
41 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 64,613<br>spill size: 0.0 B"];
}
subgraph cluster42 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 193 ms";
43 [labelType="html" label="<b>Sort</b><br><br>sort time: 31 ms<br>peak memory: 18.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: 739.9 KiB<br>number of coalesced partitions: 1"];
45 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 64,613<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: 64,613<br>local bytes read: 712.9 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: 3.0 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: 712.9 KiB"];
subgraph cluster46 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 178 ms";
47 [labelType="html" label="<br><b>Project</b><br><br>"];
48 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 64,613"];
}
49 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 64,613<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 950.8 KiB"];
subgraph cluster50 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 12.1 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: 17 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: 570 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,575<br>local merged chunks fetched: 0<br>shuffle write time: 1 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,575<br>local bytes read: 31.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: 100.6 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.2 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,575"];
66 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2,577<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,577"];
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__235409, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__235409], 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#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#938977, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#938979, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#938981]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294]
Filter (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
SortMergeJoin [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781], [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963], LeftOuter
WholeStageCodegen (14)
Sort [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781 ASC NULLS FIRST], false, 0
WholeStageCodegen (12)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, 10), ENSURE_REQUIREMENTS, [plan_id=616565]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#937295, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049]
WholeStageCodegen (3)
CartesianProduct
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549 AS COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793]
Filter isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556,COL_60F7C888_9836_4535_A22F_D43D2994E019#936561,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_234720], 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#933200 AS REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823]
Filter ((isnotnull(REGLES#933199) AND (RC-FU-PE = REGLES#933199)) AND (APPLICABLE#933200 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#933199,APPLICABLE#933200] Batched: false, DataFilters: [isnotnull(REGLES#933199), (RC-FU-PE = REGLES#933199), (APPLICABLE#933200 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_234572/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_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963 ASC NULLS FIRST], false, 0
WholeStageCodegen (13)
ObjectHashAggregate(keys=[COL_A188B73D_4933_4923_828E_687FE72CE189#936237], functions=[max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)])
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#936237, 10), ENSURE_REQUIREMENTS, [plan_id=617121]
ObjectHashAggregate(keys=[COL_A188B73D_4933_4923_828E_687FE72CE189#936237], functions=[partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)])
Project [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392]
SortMergeJoin [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238], [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328], LeftOuter
WholeStageCodegen (11)
Project [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307]
SortMergeJoin [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238], [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256], LeftOuter
WholeStageCodegen (9)
Sort [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238 ASC NULLS FIRST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, 10), ENSURE_REQUIREMENTS, [plan_id=616643]
Project [str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#936237, str_remove_extend(str_remove_space(code_Cim10#933834, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Filter (isnotnull(code_Cim10#933834) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT)))
WholeStageCodegen (4)
FileScan csv [Numéro Séjour#933833,code_Cim10#933834] Batched: false, DataFilters: [isnotnull(code_Cim10#933834), isnotnull(str_complete(str_remove_space(Numéro Séjour#933833, ALL)..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/04_DIAGNOSTICS__234564/diag_Patient_Arg..., PartitionFilters: [], PushedFilters: [IsNotNull(code_Cim10)], ReadSchema: struct<Numéro Séjour:string,code_Cim10:string>
Sort [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256, 10), ENSURE_REQUIREMENTS, [plan_id=616663]
Project [str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Filter isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT))
ColumnarToRow
WholeStageCodegen (5)
FileScan parquet [Code+CIM+10#935785] Batched: true, DataFilters: [isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#9357..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__234582_d79840771cca..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code+CIM+10:string>
Sort [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328 ASC NULLS FIRST], false, 0
WholeStageCodegen (10)
AQEShuffleRead coalesced
Exchange hashpartitioning(DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328, 10), ENSURE_REQUIREMENTS, [plan_id=616686]
Project [str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Filter isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT))
ColumnarToRow
WholeStageCodegen (6)
FileScan parquet [Code+CIM+10#936056] Batched: true, DataFilters: [isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#9360..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__234584_796b999f7aef..., 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=9.3 MiB, rowCount=3.87E+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=5.9 MiB, rowCount=6.46E+4)
+- Exchange (47)
+- ObjectHashAggregate (46)
+- * Project (45)
+- * SortMergeJoin LeftOuter (44)
:- * Project (35)
: +- * SortMergeJoin LeftOuter (34)
: :- * Sort (25)
: : +- AQEShuffleRead (24)
: : +- ShuffleQueryStage (23), Statistics(sizeInBytes=3.0 MiB, rowCount=6.46E+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.6 KiB, rowCount=2.58E+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#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_234720]
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#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
(3) Filter [codegen id : 1]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549)
(4) Project [codegen id : 1]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549 AS COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
(5) Scan csv
Output [2]: [REGLES#933199, APPLICABLE#933200]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_234572/REGLES-A-TTT new.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#933199, APPLICABLE#933200]
Condition : ((isnotnull(REGLES#933199) AND (RC-FU-PE = REGLES#933199)) AND (APPLICABLE#933200 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#933200 AS REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823]
Input [2]: [REGLES#933199, APPLICABLE#933200]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823]
(10) Project [codegen id : 3]
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#937295, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049]
(11) Project [codegen id : 3]
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294, COL_191330F1_7160_4037_ADAF_25928A72A739#937295, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326]
(12) Project [codegen id : 3]
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453]
(13) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700]
(14) Project [codegen id : 3]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
(15) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, 10), ENSURE_REQUIREMENTS, [plan_id=616565]
(16) ShuffleQueryStage
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: 0
(17) AQEShuffleRead
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: coalesced
(18) Sort [codegen id : 12]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781 ASC NULLS FIRST], false, 0
(19) Scan csv
Output [2]: [Numéro Séjour#933833, code_Cim10#933834]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/04_DIAGNOSTICS__234564/diag_Patient_Argenteuil_M122026.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#933833, code_Cim10#933834]
Condition : (isnotnull(code_Cim10#933834) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT)))
(21) Project [codegen id : 4]
Output [2]: [str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#936237, str_remove_extend(str_remove_space(code_Cim10#933834, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Input [2]: [Numéro Séjour#933833, code_Cim10#933834]
(22) Exchange
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, 10), ENSURE_REQUIREMENTS, [plan_id=616643]
(23) ShuffleQueryStage
Output [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: 1
(24) AQEShuffleRead
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: coalesced
(25) Sort [codegen id : 7]
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238 ASC NULLS FIRST], false, 0
(26) Scan parquet
Output [1]: [Code+CIM+10#935785]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__234582_d79840771cca9ecd711cba7dc1bc9f37/DP_PE1.xlsx_a8258ccd53df97b62ffb98054f5786e4]
ReadSchema: struct<Code+CIM+10:string>
(27) ColumnarToRow [codegen id : 5]
Input [1]: [Code+CIM+10#935785]
(28) Filter [codegen id : 5]
Input [1]: [Code+CIM+10#935785]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT))
(29) Project [codegen id : 5]
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Input [1]: [Code+CIM+10#935785]
(30) Exchange
Input [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: hashpartitioning(DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256, 10), ENSURE_REQUIREMENTS, [plan_id=616663]
(31) ShuffleQueryStage
Output [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: 2
(32) AQEShuffleRead
Input [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: coalesced
(33) Sort [codegen id : 8]
Input [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256 ASC NULLS FIRST], false, 0
(34) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Right keys [1]: [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Join type: LeftOuter
Join condition: None
(35) Project [codegen id : 9]
Output [3]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307]
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
(36) Scan parquet
Output [1]: [Code+CIM+10#936056]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__234584_796b999f7aef2875e93c2dc2557ed79b/DP_PE2.xlsx_d6b411d8bd618cd81884df0bb69a0dae]
ReadSchema: struct<Code+CIM+10:string>
(37) ColumnarToRow [codegen id : 6]
Input [1]: [Code+CIM+10#936056]
(38) Filter [codegen id : 6]
Input [1]: [Code+CIM+10#936056]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT))
(39) Project [codegen id : 6]
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Input [1]: [Code+CIM+10#936056]
(40) Exchange
Input [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: hashpartitioning(DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328, 10), ENSURE_REQUIREMENTS, [plan_id=616686]
(41) ShuffleQueryStage
Output [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: 3
(42) AQEShuffleRead
Input [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: coalesced
(43) Sort [codegen id : 10]
Input [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328 ASC NULLS FIRST], false, 0
(44) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Right keys [1]: [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Join type: LeftOuter
Join condition: None
(45) Project [codegen id : 11]
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392]
Input [5]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
(46) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237]
Functions [3]: [partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max#939424, max#938200, buf#939425]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
(47) Exchange
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Arguments: hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#936237, 10), ENSURE_REQUIREMENTS, [plan_id=617121]
(48) ShuffleQueryStage
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Arguments: 4
(49) AQEShuffleRead
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Arguments: coalesced
(50) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237]
Functions [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307)#936411, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392)#936413, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238))#936417]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237 AS 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307)#936411 AS 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392)#936413 AS 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238))#936417 AS 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
(51) Sort [codegen id : 13]
Input [4]: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
Arguments: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963 ASC NULLS FIRST], false, 0
(52) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781]
Right keys [1]: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963]
Join type: LeftOuter
Join condition: None
(53) Filter [codegen id : 14]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(54) Project [codegen id : 14]
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
(55) Project [codegen id : 14]
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294]
(56) Project [codegen id : 14]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#938977, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#938979, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#938981]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723]
(57) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#938977, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#938979, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#938981]
(58) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__235409, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__235409], 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#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549)
(60) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549 AS COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#936549, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#936552, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#936553, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#936554, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#936556, COL_60F7C888_9836_4535_A22F_D43D2994E019#936561, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#936565]
(61) Filter
Input [2]: [REGLES#933199, APPLICABLE#933200]
Condition : ((isnotnull(REGLES#933199) AND (RC-FU-PE = REGLES#933199)) AND (APPLICABLE#933200 <=> O))
(62) Project
Output [1]: [APPLICABLE#933200 AS REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823]
Input [2]: [REGLES#933199, APPLICABLE#933200]
(63) CartesianProduct
Join type: Inner
Join condition: None
(64) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, REGLES_A_APPLIQ_234699_APPLICABLE_234701#936823]
(65) Project
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#937295, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#937049]
(66) Project
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#937295 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#937293, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#937294, COL_191330F1_7160_4037_ADAF_25928A72A739#937295, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326]
(67) Project
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#936780, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#936784, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#936793, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#937292, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#937296, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#937326, COL_B85FC0C7_A95C_499F_9883_0232DA327922#937357, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#937388, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#937420, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#937453]
(68) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700]
(69) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#937700, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#937839, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
(70) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, 10), ENSURE_REQUIREMENTS, [plan_id=616496]
(71) Sort
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664]
Arguments: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781 ASC NULLS FIRST], false, 0
(72) Filter
Input [2]: [Numéro Séjour#933833, code_Cim10#933834]
Condition : (isnotnull(code_Cim10#933834) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT)))
(73) Project
Output [2]: [str_complete(str_remove_space(Numéro Séjour#933833, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#936237, str_remove_extend(str_remove_space(code_Cim10#933834, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Input [2]: [Numéro Séjour#933833, code_Cim10#933834]
(74) Exchange
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, 10), ENSURE_REQUIREMENTS, [plan_id=616478]
(75) Sort
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Arguments: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238 ASC NULLS FIRST], false, 0
(76) Filter
Input [1]: [Code+CIM+10#935785]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT))
(77) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#935785, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Input [1]: [Code+CIM+10#935785]
(78) Exchange
Input [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: hashpartitioning(DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256, 10), ENSURE_REQUIREMENTS, [plan_id=616479]
(79) Sort
Input [2]: [DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Arguments: [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256 ASC NULLS FIRST], false, 0
(80) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Right keys [1]: [DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
Join type: LeftOuter
Join condition: None
(81) Project
Output [3]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307]
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, DIAGNOSTIC_PE1__234619_CODE_CIM_10_234620#936250, DIAGNOSTIC_PE1__234619_CODE_CIM10_NORM_234626#936256]
(82) Filter
Input [1]: [Code+CIM+10#936056]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT))
(83) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#936056, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Input [1]: [Code+CIM+10#936056]
(84) Exchange
Input [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: hashpartitioning(DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328, 10), ENSURE_REQUIREMENTS, [plan_id=616486]
(85) Sort
Input [2]: [DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Arguments: [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328 ASC NULLS FIRST], false, 0
(86) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238]
Right keys [1]: [DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
Join type: LeftOuter
Join condition: None
(87) Project
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392]
Input [5]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, DIAGNOSTIC_PE2__234702_CODE_CIM_10_234703#936322, DIAGNOSTIC_PE2__234702_CODE_CIM10_NORM_234709#936328]
(88) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237]
Functions [3]: [partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max#939424, max#938200, buf#939425]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
(89) Exchange
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Arguments: hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#936237, 10), ENSURE_REQUIREMENTS, [plan_id=616492]
(90) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237, max#939426, max#938203, buf#939427]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237]
Functions [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5dbb2060, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307)#936411, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392)#936413, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238))#936417]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#936237 AS 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#936307)#936411 AS 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#936392)#936413 AS 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#936238))#936417 AS 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
(91) Sort
Input [4]: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
Arguments: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963 ASC NULLS FIRST], false, 0
(92) SortMergeJoin
Left keys [1]: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781]
Right keys [1]: [00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963]
Join type: LeftOuter
Join condition: None
(93) Filter
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(94) Project
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_if_with_rule((((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE1) END AND (((00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, PE2) END AND (((00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928 <=> 0)) OR isnull(00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#936789, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#937928, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, 00_E_DIAGNOSTIC_234911_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#937963, 00_E_DIAGNOSTIC_234911_COL_22F494F7_741E_40CC_932F_1428DA298F77#937964, 00_E_DIAGNOSTIC_234911_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#937965, 00_E_DIAGNOSTIC_234911_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#937966]
(95) Project
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#937837, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#938205, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#938294]
(96) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#938977, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#938979, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#938981]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#938008, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#938009, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#936782, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#937664, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_152219DE_9E30_4C72_B6C4_3536674868FD#938664, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723]
(97) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#936777, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#936781, COL_5276B642_7FD3_4362_A102_7091D784BB77#936850, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#938010, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#938723, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#938977, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#938979, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#938981]
(98) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__235409, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__235409], 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