SP1 - Details for Query 12022

Submitted Time: 2026/01/24 21:07:43
Duration: 0.9 s
Succeeded Jobs: 17893

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 11 ms (0 ms, 1 ms, 4 ms (stage 32497.0: task 39386)) number of written files: 10 job commit time: 12 ms number of output rows: 43 number of dynamic part: 0 written output: 36.4 KiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.1 s (141 ms, 223 ms, 254 ms (stage 32497.0: task 39392))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; } 7 [labelType="html" label="CartesianProduct number of output rows: 43"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.7 s (203 ms, 286 ms, 317 ms (stage 32497.0: task 39392))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 43"]; 11 [labelType="html" label="ColumnarToRow number of output rows: 48,615 number of input batches: 20"]; } 12 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 171 ms (3 ms, 19 ms, 33 ms (stage 32497.0: task 39387)) metadata time: 0 ms size of files read: 7.8 MiB number of output rows: 48,615"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n25 ms (2 ms, 3 ms, 3 ms (stage 32497.0: task 39385))"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="Filter number of output rows: 10"]; } 16 [labelType="html" label="Scan csv number of output rows: 10 number of files read: 1 metadata time: 0 ms size of files read: 163.0 B"]; 1->0; 3->1; 4->3; 5->4; 6->5; 7->6; 9->7; 10->9; 11->10; 12->11; 14->7; 15->14; 16->15; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR1_FPU_FPV__161727, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR1_FPU_FPV__161727], Overwrite, [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1, COL_15EAD78F_1575_44B6_9C81_A848988B6244, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE, COL_597B3862_9A4F_4729_9C5A_5165E797CC60]

WriteFiles

Project [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, str_if_with_rule((NOT (COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060 <=> ) AND isnotnull(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060)), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, +)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -) END, Switch de forfait (FP*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -) END, Suppression de Forfait, )), COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691), @), ) AS COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#2457255, str_create(RC-FP* et CFU) AS COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#2457256, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, str_join(array(str_join(array(Nature Assurance , COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697), : ), str_join(array(Exonération , COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696), : )), - ) AS COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#2457258, COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684]

Project [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, str_if_with_rule((COL_BB992EBD_8D6F_41A1_B497_1BF1B088399B#2456434 <=> 1), str_if_with_rule((COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439 <=> 1), null, FPU+), str_if_with_rule((COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439 <=> 1), FPU-, null)) AS COL_BB45FB6A_0AD0_4D9A_A6B5_40E716B4638B#2456755, str_if_with_rule((COL_E65081AF_2A51_4716_BAB0_8BA16906D8A8#2456435 <=> 1), str_if_with_rule((COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440 <=> 1), null, FPX+), str_if_with_rule((COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440 <=> 1), FPX-, null)) AS COL_B6940F7B_B9E1_4746_AA19_EE33A055CD4F#2456758, str_if_with_rule((COL_447756CA_0157_478B_9C6C_CAB1D9691BD5#2456436 <=> 1), str_if_with_rule((COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441 <=> 1), null, FPL+), str_if_with_rule((COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441 <=> 1), FPL-, null)) AS COL_06393809_DC88_40E0_BBA7_7018E194F5CB#2456759, str_if_with_rule((COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#2456437 <=> 1), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442 <=> 1), null, FPV+), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442 <=> 1), FPV-, null)) AS COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760, str_if_with_rule((COL_015BC927_6ED3_42E2_9BA5_F5F8614EF5EE#2456438 <=> 1), str_if_with_rule((COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443 <=> 1), null, FPM+), str_if_with_rule((COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443 <=> 1), FPM-, null)) AS COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU) END, 1, 0) AS COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#2456792, str_if_with_rule((((COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4) AND ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) OR (COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0))), 1, 0) AS COL_4DA521F7_900D_4579_BF5A_0030844A1E22#2456823]

Project [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)), 1, 0) AS COL_BB992EBD_8D6F_41A1_B497_1BF1B088399B#2456434, str_if_with_rule((((((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 30) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 5))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 3))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 5))), 1, 0) AS COL_E65081AF_2A51_4716_BAB0_8BA16906D8A8#2456435, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)), 1, 0) AS COL_447756CA_0157_478B_9C6C_CAB1D9691BD5#2456436, str_if_with_rule((((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4)) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0))), 1, 0) AS COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#2456437, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4)), 1, 0) AS COL_015BC927_6ED3_42E2_9BA5_F5F8614EF5EE#2456438, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPU) END, 1, 0) AS COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPX)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPX) END, 1, 0) AS COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPL)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPL) END, 1, 0) AS COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV) END, 1, 0) AS COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM) END, 1, 0) AS COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443, REGLES_A_APPLIQ_161538_APPLICABLE_161540#2455725 AS COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752]

WholeStageCodegen (3)

CartesianProduct

Project [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451 AS COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453 AS COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457 AS COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458 AS COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 AS COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 AS COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465 AS COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698]

Filter ((NOT (str_replace(str_remove_space(str_join(array(str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), null, FPU+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), FPU-, null)), str_if_with_rule((str_if_with_rule((((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 30) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 3))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), null, FPX+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), FPX-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), null, FPL+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), FPL-, null)), str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)), str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END) OR ((str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+) OR (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM+))) OR (NOT (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END)), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, CFU-, null))), ), ONLY_ONE), , ,) <=> ) AND isnotnull(str_replace(str_remove_space(str_join(array(str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), null, FPU+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), FPU-, null)), str_if_with_rule((str_if_with_rule((((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 30) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 3))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), null, FPX+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), FPX-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), null, FPL+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), FPL-, null)), str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)), str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END) OR ((str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+) OR (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM+))) OR (NOT (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END)), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, CFU-, null))), ), ONLY_ONE), , ,))) AND isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458,COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464,COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465] Batched: true, DataFilters: [NOT (str_replace(str_remove_space(str_join(array(str_if_with_rule((str_if_with_rule(((COL_5B5B15..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_161568], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F)], ReadSchema: struct<COL_1856697C_8DD2_425F_AA61_054524CA3E4B:int,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:stri...

Project [APPLICABLE#2455299 AS REGLES_A_APPLIQ_161538_APPLICABLE_161540#2455725]

Filter ((isnotnull(REGLES#2455298) AND (RC-FP* et CFU = REGLES#2455298)) AND (APPLICABLE#2455299 <=> O))

WholeStageCodegen (2)

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

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (14)
+- WriteFiles (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)


(1) Scan parquet 
Output [7]: [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_161568]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F)]
ReadSchema: struct<COL_1856697C_8DD2_425F_AA61_054524CA3E4B:int,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_43523D61_1E4B_4377_998B_7E898D87B867:string,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string>

(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465]

(3) Filter [codegen id : 1]
Input [7]: [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465]
Condition : ((NOT (str_replace(str_remove_space(str_join(array(str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), null, FPU+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), FPU-, null)), str_if_with_rule((str_if_with_rule((((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 30) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 3))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), null, FPX+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), FPX-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), null, FPL+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), FPL-, null)), str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)), str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END) OR ((str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+) OR (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM+))) OR (NOT (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END)), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, CFU-, null))),  ), ONLY_ONE),  , ,) <=> ) AND isnotnull(str_replace(str_remove_space(str_join(array(str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), null, FPU+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPU) END, 1, 0) <=> 1), FPU-, null)), str_if_with_rule((str_if_with_rule((((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 30) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 3))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 5))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), null, FPX+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPX) END, 1, 0) <=> 1), FPX-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), null, FPL+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPL) END, 1, 0) <=> 1), FPL-, null)), str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)), str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)), str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END) OR ((str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), null, FPV+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+) OR (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM+))) OR (NOT (str_if_with_rule((str_if_with_rule(((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 <=> 13) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 <=> 4)), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), null, FPM+), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END, 1, 0) <=> 1), FPM-, null)) <=> FPM-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, FPM) END)), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465, CFU) END, CFU-, null))),  ), ONLY_ONE),  , ,))) AND isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453))

(4) Project [codegen id : 1]
Output [7]: [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451 AS COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453 AS COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457 AS COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458 AS COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463 AS COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464 AS COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465 AS COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698]
Input [7]: [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#2455451, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2455453, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2455457, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2455458, COL_43523D61_1E4B_4377_998B_7E898D87B867#2455463, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#2455464, COL_60F7C888_9836_4535_A22F_D43D2994E019#2455465]

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

(6) Filter [codegen id : 2]
Input [2]: [REGLES#2455298, APPLICABLE#2455299]
Condition : ((isnotnull(REGLES#2455298) AND (RC-FP* et CFU = REGLES#2455298)) AND (APPLICABLE#2455299 <=> O))

(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#2455299 AS REGLES_A_APPLIQ_161538_APPLICABLE_161540#2455725]
Input [2]: [REGLES#2455298, APPLICABLE#2455299]

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

(9) Project [codegen id : 3]
Output [18]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)), 1, 0) AS COL_BB992EBD_8D6F_41A1_B497_1BF1B088399B#2456434, str_if_with_rule((((((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 30) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 5))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 3))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 5))), 1, 0) AS COL_E65081AF_2A51_4716_BAB0_8BA16906D8A8#2456435, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0)), 1, 0) AS COL_447756CA_0157_478B_9C6C_CAB1D9691BD5#2456436, str_if_with_rule((((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4)) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0))), 1, 0) AS COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#2456437, str_if_with_rule(((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4)), 1, 0) AS COL_015BC927_6ED3_42E2_9BA5_F5F8614EF5EE#2456438, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPU) END, 1, 0) AS COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPX)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPX) END, 1, 0) AS COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPL)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPL) END, 1, 0) AS COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV) END, 1, 0) AS COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM) END, 1, 0) AS COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443, REGLES_A_APPLIQ_161538_APPLICABLE_161540#2455725 AS COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752]
Input [8]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, REGLES_A_APPLIQ_161538_APPLICABLE_161540#2455725]

(10) Project [codegen id : 3]
Output [15]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, str_if_with_rule((COL_BB992EBD_8D6F_41A1_B497_1BF1B088399B#2456434 <=> 1), str_if_with_rule((COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439 <=> 1), null, FPU+), str_if_with_rule((COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439 <=> 1), FPU-, null)) AS COL_BB45FB6A_0AD0_4D9A_A6B5_40E716B4638B#2456755, str_if_with_rule((COL_E65081AF_2A51_4716_BAB0_8BA16906D8A8#2456435 <=> 1), str_if_with_rule((COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440 <=> 1), null, FPX+), str_if_with_rule((COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440 <=> 1), FPX-, null)) AS COL_B6940F7B_B9E1_4746_AA19_EE33A055CD4F#2456758, str_if_with_rule((COL_447756CA_0157_478B_9C6C_CAB1D9691BD5#2456436 <=> 1), str_if_with_rule((COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441 <=> 1), null, FPL+), str_if_with_rule((COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441 <=> 1), FPL-, null)) AS COL_06393809_DC88_40E0_BBA7_7018E194F5CB#2456759, str_if_with_rule((COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#2456437 <=> 1), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442 <=> 1), null, FPV+), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442 <=> 1), FPV-, null)) AS COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760, str_if_with_rule((COL_015BC927_6ED3_42E2_9BA5_F5F8614EF5EE#2456438 <=> 1), str_if_with_rule((COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443 <=> 1), null, FPM+), str_if_with_rule((COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443 <=> 1), FPM-, null)) AS COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU) END, 1, 0) AS COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#2456792, str_if_with_rule((((COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 4) AND ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 10) OR (COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 13))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696 <=> 0))), 1, 0) AS COL_4DA521F7_900D_4579_BF5A_0030844A1E22#2456823]
Input [18]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, COL_BB992EBD_8D6F_41A1_B497_1BF1B088399B#2456434, COL_E65081AF_2A51_4716_BAB0_8BA16906D8A8#2456435, COL_447756CA_0157_478B_9C6C_CAB1D9691BD5#2456436, COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#2456437, COL_015BC927_6ED3_42E2_9BA5_F5F8614EF5EE#2456438, COL_FB942620_27F3_4A39_A0A5_9E8CDDE103E2#2456439, COL_F3020149_0CB0_444E_858F_A385216D2B18#2456440, COL_12129EFD_1241_4357_B497_59761A88F7BD#2456441, COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#2456442, COL_D2A97F4A_B92E_4D60_A45C_B00199F1B695#2456443, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752]

(11) Project [codegen id : 3]
Output [8]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, str_replace(str_remove_space(str_join(array(COL_BB45FB6A_0AD0_4D9A_A6B5_40E716B4638B#2456755, COL_B6940F7B_B9E1_4746_AA19_EE33A055CD4F#2456758, COL_06393809_DC88_40E0_BBA7_7018E194F5CB#2456759, COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760, COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761, str_if_with_rule(((COL_4DA521F7_900D_4579_BF5A_0030844A1E22#2456823 <=> 1) AND (str_if_with_rule((((NOT (COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760 <=> FPV-) AND CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPV) END) OR ((COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760 <=> FPV+) OR (COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761 <=> FPM+))) OR (NOT (COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761 <=> FPM-) AND CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, FPM) END)), 1, 0) <=> 1)), str_if_with_rule((COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#2456792 <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, CFU) END, CFU-, null))),  ), ONLY_ONE),  , ,) AS COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060]
Input [15]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#2455698, COL_BB45FB6A_0AD0_4D9A_A6B5_40E716B4638B#2456755, COL_B6940F7B_B9E1_4746_AA19_EE33A055CD4F#2456758, COL_06393809_DC88_40E0_BBA7_7018E194F5CB#2456759, COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#2456760, COL_0E3EB835_787B_4EBF_82E2_FFA66B044130#2456761, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#2456792, COL_4DA521F7_900D_4579_BF5A_0030844A1E22#2456823]

(12) Project [codegen id : 3]
Output [8]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, str_if_with_rule((NOT (COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060 <=> ) AND isnotnull(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060)), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, +)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -) END, Switch de forfait (FP*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, -) END, Suppression de Forfait, )), COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691), @), ) AS COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#2457255, str_create(RC-FP* et CFU) AS COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#2457256, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, str_join(array(str_join(array(Nature Assurance , COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697),  : ), str_join(array(Exonération , COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696),  : )),  - ) AS COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#2457258, COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684]
Input [8]: [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#2455691, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#2455696, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#2455697, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060]

(13) WriteFiles
Input [8]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#2455686, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#2455690, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#2457060, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#2457255, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#2457256, COL_15EAD78F_1575_44B6_9C81_A848988B6244#2455752, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#2457258, COL_597B3862_9A4F_4729_9C5A_5165E797CC60#2455684]

(14) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR1_FPU_FPV__161727, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR1_FPU_FPV__161727], Overwrite, [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1, COL_15EAD78F_1575_44B6_9C81_A848988B6244, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE, COL_597B3862_9A4F_4729_9C5A_5165E797CC60]

SQL / DataFrame Properties

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