digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 0 ms<br>number of written files: 1<br>job commit time: 15 ms<br>number of output rows: 0<br>number of dynamic part: 0<br>written output: 1459.0 B"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 117 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
}
9 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 892.7 KiB<br>number of coalesced partitions: 1"];
10 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 12,897<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>17 ms (1 ms, 1 ms, 2 ms (stage 6261.0: task 8306))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 12,897<br>local bytes read: 851.8 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 10<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>3.1 MiB (297.5 KiB, 316.5 KiB, 328.6 KiB (stage 6261.0: task 8303))<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>851.8 KiB (80.3 KiB, 85.7 KiB, 89.8 KiB (stage 6261.0: task 8303))"];
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n995 ms (81 ms, 106 ms, 120 ms (stage 6261.0: task 8304))";
12 [labelType="html" label="<br><b>Project</b><br><br>"];
13 [labelType="html" label="<br><b>Project</b><br><br>"];
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="<b>CartesianProduct</b><br><br>number of output rows: 12,897"];
subgraph cluster19 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (82 ms, 107 ms, 121 ms (stage 6261.0: task 8304))";
20 [labelType="html" label="<br><b>Project</b><br><br>"];
21 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 12,897"];
22 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 12,897<br>number of input batches: 10"];
}
23 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>65 ms (3 ms, 7 ms, 11 ms (stage 6261.0: task 8304))<br>metadata time: 0 ms<br>size of files read: 2041.6 KiB<br>number of output rows: 12,897"];
subgraph cluster24 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n62 ms (3 ms, 7 ms, 9 ms (stage 6261.0: task 8304))";
25 [labelType="html" label="<br><b>Project</b><br><br>"];
26 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10"];
}
27 [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"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
8->7;
9->8;
10->9;
12->10;
13->12;
14->13;
15->14;
16->15;
17->16;
18->17;
20->18;
21->20;
22->21;
23->22;
25->18;
26->25;
27->26;
}
28
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146], 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#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#527451, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#527452, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#527453]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073]
Filter (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, 10), ENSURE_REQUIREMENTS, [plan_id=321455]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#525579, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610]
Project [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273]
WholeStageCodegen (3)
CartesianProduct
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733 AS COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023]
Filter isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740,COL_60F7C888_9836_4535_A22F_D43D2994E019#524745,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663], 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#524582 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047]
Filter ((isnotnull(REGLES#524581) AND (RC-FU-PE = REGLES#524581)) AND (APPLICABLE#524582 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#524581,APPLICABLE#524582] Batched: false, DataFilters: [isnotnull(REGLES#524581), (RC-FU-PE = REGLES#524581), (APPLICABLE#524582 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FU-PE), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
== Physical Plan ==
AdaptiveSparkPlan (68)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (24)
+- WriteFiles (23)
+- * Project (22)
+- * Project (21)
+- * Project (20)
+- * Filter (19)
+- * Project (18)
+- AQEShuffleRead (17)
+- ShuffleQueryStage (16), Statistics(sizeInBytes=3.1 MiB, rowCount=1.29E+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)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (67)
+- WriteFiles (66)
+- Project (65)
+- Project (64)
+- Project (63)
+- Filter (62)
+- SortMergeJoin LeftOuter (61)
:- Sort (37)
: +- Exchange (36)
: +- Project (35)
: +- Project (34)
: +- Project (33)
: +- Project (32)
: +- Project (31)
: +- Project (30)
: +- CartesianProduct Inner (29)
: :- Project (26)
: : +- Filter (25)
: : +- Scan parquet (1)
: +- Project (28)
: +- Filter (27)
: +- Scan csv (5)
+- Sort (60)
+- ObjectHashAggregate (59)
+- Exchange (58)
+- ObjectHashAggregate (57)
+- Project (56)
+- SortMergeJoin LeftOuter (55)
:- Project (49)
: +- SortMergeJoin LeftOuter (48)
: :- Sort (42)
: : +- Exchange (41)
: : +- Project (40)
: : +- Filter (39)
: : +- Scan csv (38)
: +- Sort (47)
: +- Exchange (46)
: +- Project (45)
: +- Filter (44)
: +- Scan parquet (43)
+- Sort (54)
+- Exchange (53)
+- Project (52)
+- Filter (51)
+- Scan parquet (50)
(1) Scan parquet
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663]
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#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
(3) Filter [codegen id : 1]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733)
(4) Project [codegen id : 1]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733 AS COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
(5) Scan csv
Output [2]: [REGLES#524581, APPLICABLE#524582]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/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#524581, APPLICABLE#524582]
Condition : ((isnotnull(REGLES#524581) AND (RC-FU-PE = REGLES#524581)) AND (APPLICABLE#524582 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#524582 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047]
Input [2]: [REGLES#524581, APPLICABLE#524582]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047]
(10) Project [codegen id : 3]
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#525579, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273]
(11) Project [codegen id : 3]
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578, COL_191330F1_7160_4037_ADAF_25928A72A739#525579, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610]
(12) Project [codegen id : 3]
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736]
(13) Project [codegen id : 3]
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341]
(14) Project [codegen id : 3]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
(15) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, 10), ENSURE_REQUIREMENTS, [plan_id=321455]
(16) ShuffleQueryStage
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Arguments: 0
(17) AQEShuffleRead
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Arguments: coalesced
(18) Project [codegen id : 7]
Output [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, cast(null as string) AS 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
(19) Filter [codegen id : 7]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(20) Project [codegen id : 7]
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
(21) Project [codegen id : 7]
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073]
(22) Project [codegen id : 7]
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#527451, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#527452, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#527453]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351]
(23) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#527451, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#527452, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#527453]
(24) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146], 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]
(25) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
Condition : isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733)
(26) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733 AS COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#524733, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#524736, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#524737, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#524738, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#524740, COL_60F7C888_9836_4535_A22F_D43D2994E019#524745, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#524749]
(27) Filter
Input [2]: [REGLES#524581, APPLICABLE#524582]
Condition : ((isnotnull(REGLES#524581) AND (RC-FU-PE = REGLES#524581)) AND (APPLICABLE#524582 <=> O))
(28) Project
Output [1]: [APPLICABLE#524582 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047]
Input [2]: [REGLES#524581, APPLICABLE#524582]
(29) CartesianProduct
Join type: Inner
Join condition: None
(30) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule(CASE WHEN isnull(((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99))) THEN false ELSE ((COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 0.0) AND (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 <= 3.99)) END, 1, 0) AS COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273]
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, REGLES_A_APPLIQ_225642_APPLICABLE_225644#525047]
(31) Project
Output [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, str_if_with_rule(((CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= -1.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 15.99)) END AND (COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0)) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <=> 0.0)), 1, 0) AS COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 16.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 44.99)) END, 1, 0) AS COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577, str_if_with_rule(CASE WHEN isnull(((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99))) THEN false ELSE ((COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 45.0) AND (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 <= 74.99)) END, 1, 0) AS COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578, str_if_with_rule(CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 >= 75.0) END, 1, 0) AS COL_191330F1_7160_4037_ADAF_25928A72A739#525579, str_if_with_rule((CASE WHEN isnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) THEN false ELSE (COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014 < 16.0) END AND CASE WHEN isnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) THEN false ELSE (COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023 >= 4.0) END), 1, 0) AS COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0+, str_if_with_rule(((COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END), FU0-, null)), null) AS COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_BD295954_9652_4047_A8E9_CBDDB8519B01#525273]
(32) Project
Output [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 1)), FU1+, str_if_with_rule((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END), FU1-, null)), null) AS COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END), FU2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU2) END AND (COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577 <=> 0)), FU2-, null)), null) AS COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, str_if_with_rule((isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014) AND isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3+, str_if_with_rule(((COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578 <=> 0) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU3) END), FU3-, null)), null) AS COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END), FU4+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU4) END AND (COL_191330F1_7160_4037_ADAF_25928A72A739#525579 <=> 0)), FU4-, null)), null) AS COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736]
Input [14]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_0E194329_5AC1_4821_9E0A_D1EEBB74DB3D#525577, COL_E89D23BF_3E5A_4FC6_8386_63E823C302A6#525578, COL_191330F1_7160_4037_ADAF_25928A72A739#525579, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610]
(33) Project
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, str_join(array(str_join(array(Age en Mois, dec_to_str(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023)), :), str_join(array(Age en Année, dec_to_str(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), :), str_join(array(Date Naissance , str_join(array(str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, LEFT, 2), str_extract_middle(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, 3, 2), str_extract(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, RIGHT, 4)), -)), : ), str_join(array(Entrée le , str_join(array(str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, LEFT, 2), str_extract_middle(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, 3, 2), str_extract(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, RIGHT, 4)), -)), : )), ;) AS COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_replace(str_remove_space(str_join(array(COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, str_if_with_rule((isnotnull(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023) AND isnotnull(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND (COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 1)) AND isnull(COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576)), FU1+, str_if_with_rule(((((COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580 <=> 0) AND (COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576 <=> 0)) AND CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END) AND NOT CASE WHEN isnull(Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-)) THEN false ELSE Contains(COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, FU1-) END), FU1-, null)), null), COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736), ), ONLY_ONE), , ,) AS COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341]
Input [15]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#525010, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#525014, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#525023, COL_7702A562_4E71_4BC3_8B3F_774FBBFB80D8#525576, COL_8A60045C_553F_4BC8_92C6_7B9FAE3B3AE9#525580, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_9D1D8FAF_4D67_4B4E_AA2E_14C463F890D0#525610, COL_B85FC0C7_A95C_499F_9883_0232DA327922#525640, COL_C10F9365_B37F_4197_AACD_41D6CFFB5A4C#525671, COL_BF945CE5_4DBC_4F75_9BF4_117304516C29#525703, COL_F8A6EC93_5926_4434_ACA2_88AF6C77FC78#525736]
(34) Project
Output [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, str_if_with_rule((COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341 <=> ), null, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341) AS COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, size(str_list_intersect_fixed(str_split(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, ,), [FU0+,FU1+]), true) AS COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Input [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341]
(35) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 > 0), 1, str_if_with_rule(((COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571 <=> 0) AND ((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU0) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU0-) END) OR (CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, FU1) END AND NOT CASE WHEN isnull(Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-)) THEN false ELSE Contains(COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, FU1-) END))), 1, 0)) AS COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Input [9]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_504F79F3_0D5A_4BD7_87C8_0F1203F5EB36#526341, COL_C1E660AE_1C75_4ACE_AB41_D804FE912AF9#526571, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
(36) Exchange
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Arguments: hashpartitioning(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, 10), ENSURE_REQUIREMENTS, [plan_id=321391]
(37) Sort
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268]
Arguments: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011 ASC NULLS FIRST], false, 0
(38) Scan csv
Output [2]: [Numéro Séjour#522325, code_Cim10#522326]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/04_DIAGNOSTICS__225507/diag_Patient_FVdp_M122025.csv]
PushedFilters: [IsNotNull(code_Cim10)]
ReadSchema: struct<Numéro Séjour:string,code_Cim10:string>
(39) Filter
Input [2]: [Numéro Séjour#522325, code_Cim10#522326]
Condition : (isnotnull(code_Cim10#522326) AND isnotnull(str_complete(str_remove_space(Numéro Séjour#522325, ALL), 0, 9, LEFT)))
(40) Project
Output [2]: [str_complete(str_remove_space(Numéro Séjour#522325, ALL), 0, 9, LEFT) AS COL_A188B73D_4933_4923_828E_687FE72CE189#522386, str_remove_extend(str_remove_space(code_Cim10#522326, ALL), [.]) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387]
Input [2]: [Numéro Séjour#522325, code_Cim10#522326]
(41) Exchange
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387]
Arguments: hashpartitioning(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, 10), ENSURE_REQUIREMENTS, [plan_id=321373]
(42) Sort
Input [2]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387]
Arguments: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387 ASC NULLS FIRST], false, 0
(43) Scan parquet
Output [1]: [Code+CIM+10#519380]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__225525_9909b37ba43c9289f6d60eed3db201d9/DP_PE1.xlsx_f0c450e04d6a2a88d5887c002661ae0d]
ReadSchema: struct<Code+CIM+10:string>
(44) Filter
Input [1]: [Code+CIM+10#519380]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#519380, [.]), RIGHT), [.]), RIGHT))
(45) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#519380, [.]), RIGHT) AS DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#519380, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
Input [1]: [Code+CIM+10#519380]
(46) Exchange
Input [2]: [DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399, DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
Arguments: hashpartitioning(DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405, 10), ENSURE_REQUIREMENTS, [plan_id=321374]
(47) Sort
Input [2]: [DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399, DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
Arguments: [DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405 ASC NULLS FIRST], false, 0
(48) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387]
Right keys [1]: [DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
Join type: LeftOuter
Join condition: None
(49) Project
Output [3]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, str_if_with_rule(isnotnull(DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399), 1, 0) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466]
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399, DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
(50) Scan parquet
Output [1]: [Code+CIM+10#519874]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/DIAGNOSTIC_PE2__225527_d1a895972471c5b14485ba2ac5bf9c6b/DP_PE2.xlsx_684a40931f77c94aeb8cadbb25001971]
ReadSchema: struct<Code+CIM+10:string>
(51) Filter
Input [1]: [Code+CIM+10#519874]
Condition : isnotnull(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#519874, [.]), RIGHT), [.]), RIGHT))
(52) Project
Output [2]: [str_remove_space(str_remove_extend(Code+CIM+10#519874, [.]), RIGHT) AS DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#519874, [.]), RIGHT), [.]), RIGHT) AS DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
Input [1]: [Code+CIM+10#519874]
(53) Exchange
Input [2]: [DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481, DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
Arguments: hashpartitioning(DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487, 10), ENSURE_REQUIREMENTS, [plan_id=321381]
(54) Sort
Input [2]: [DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481, DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
Arguments: [DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487 ASC NULLS FIRST], false, 0
(55) SortMergeJoin
Left keys [1]: [COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387]
Right keys [1]: [DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
Join type: LeftOuter
Join condition: None
(56) Project
Output [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, str_if_with_rule(isnotnull(DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481), 1, 0) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551]
Input [5]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481, DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
(57) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386]
Functions [3]: [partial_max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466), partial_max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551), partial_concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5a0a5284, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max#528359, max#527040, buf#528360]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, max#528361, max#527043, buf#528362]
(58) Exchange
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, max#528361, max#527043, buf#528362]
Arguments: hashpartitioning(COL_A188B73D_4933_4923_828E_687FE72CE189#522386, 10), ENSURE_REQUIREMENTS, [plan_id=321387]
(59) ObjectHashAggregate
Input [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, max#528361, max#527043, buf#528362]
Keys [1]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386]
Functions [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466), max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551), concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5a0a5284, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None)]
Aggregate Attributes [3]: [max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466)#522570, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551)#522572, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387))#522576]
Results [4]: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386 AS 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466)#522570 AS 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551)#522572 AS 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, ConcatWithSeparatorUDAF(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387))#522576 AS 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
(60) Sort
Input [4]: [00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
Arguments: [00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845 ASC NULLS FIRST], false, 0
(61) SortMergeJoin
Left keys [1]: [COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011]
Right keys [1]: [00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845]
Join type: LeftOuter
Join condition: None
(62) Filter
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
Condition : (NOT (str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,]) <=> ) AND isnotnull(str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null))), ), ONLY_ONE), [ ], [,])))
(63) Project
Output [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 AS COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 AS COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848 AS COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_if_with_rule((((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 1) AND NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE1+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE1) END AND (((00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846))), PE1-, null)) AS COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 1)) AND (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 1)), PE2+, str_if_with_rule((CASE WHEN isnull(Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2)) THEN false ELSE Contains(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, PE2) END AND (((00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847 <=> 0) OR (COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824 <=> 0)) OR isnull(00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847))), PE2-, null)) AS COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073]
Input [12]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#525019, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_3BB14381_E6AB_42C1_9AAC_D4A6315D3E29#526824, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, 00_E_DIAGNOSTIC_225838_COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#526845, 00_E_DIAGNOSTIC_225838_COL_22F494F7_741E_40CC_932F_1428DA298F77#526846, 00_E_DIAGNOSTIC_225838_COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#526847, 00_E_DIAGNOSTIC_225838_COL_22564C4C_27A7_4316_AD62_101B7408E7AA#526848]
(64) Project
Output [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, str_join(array(COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ;) AS COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314, str_replace_extend(str_remove_space(str_join(array(COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073), ), ONLY_ONE), [ ], [,]) AS COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351]
Input [11]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_ADC4A492_81BF_479D_A618_F1C5C1D7D922#526569, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_CB29862F_151B_4CA0_8D64_1D20B07B840A#527045, COL_67C7B1B6_C114_48E9_980B_4E276BE28BC6#527073]
(65) Project
Output [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, str_if_with_rule((isnotnull(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351) AND NOT (COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Switch de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), str_join(array(Ajout de forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et )), str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, -) END, str_join(array(Suppression de Forfait FU, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314), et ), )), COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012), @), ) AS COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#527451, str_create(RC-FU-PE) AS COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#527452, str_join(array(COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, str_join(array(str_join(array(Eligible PE1, int_to_str(COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910)), : ), str_join(array(Eligible PE2, int_to_str(COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911)), : )), - ), str_join(array(Diag(s) , COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912), - )), ; ) AS COL_96193E27_D3D2_4476_8CFF_4911255A14C5#527453]
Input [10]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_FEE983A1_7EFD_4B64_A88C_61BC09E24563#526910, COL_7F09E349_35E8_4ECE_AF03_4D5759587C18#526911, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#525012, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_17057DFC_41ED_4CC3_9258_4835753BE2A0#526268, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_152219DE_9E30_4C72_B6C4_3536674868FD#527314, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351]
(66) WriteFiles
Input [8]: [COL_6D461599_696B_4415_9E1E_62284656C432#525007, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#525011, COL_5276B642_7FD3_4362_A102_7091D784BB77#525074, COL_8AECDE1B_3284_4DBD_8F4F_E6F50B089B1C#526912, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#527351, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#527451, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#527452, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#527453]
(67) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR2_FU0_FU1__226146], 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]
(68) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true