digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 16881.0: task 23423))<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: 1454.0 B"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.8 s (97 ms, 130 ms, 558 ms (stage 16881.0: task 23427))";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
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>CartesianProduct</b><br><br>number of output rows: 0"];
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 s (56 ms, 69 ms, 279 ms (stage 16881.0: task 23427))";
9 [labelType="html" label="<br><b>Project</b><br><br>"];
10 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1,554"];
11 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 48,276<br>number of input batches: 20"];
}
12 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>45 ms (3 ms, 4 ms, 7 ms (stage 16881.0: task 23424))<br>metadata time: 0 ms<br>size of files read: 8.7 MiB<br>number of output rows: 48,276"];
subgraph cluster13 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n44 ms (3 ms, 3 ms, 8 ms (stage 16881.0: task 23423))";
14 [labelType="html" label="<br><b>Project</b><br><br>"];
15 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 0"];
}
16 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 0<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.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;
}
17
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR1_FPU_FPV__188391, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR1_FPU_FPV__188391], 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#1307509, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1307513, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, str_if_with_rule((NOT (COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894 <=> ) AND isnotnull(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894)), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, +)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, -) END, Switch de forfait (FP*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, -)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894, -) END, Suppression de Forfait, )), COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1307514), @), ) AS COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1309101, str_create(RC-FP* et CFU) AS COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#1309102, COL_15EAD78F_1575_44B6_9C81_A848988B6244#1307575, str_join(array(str_join(array(Nature Assurance , COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520), : ), str_join(array(Exonération , COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519), : )), - ) AS COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#1309104, COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1307507]
Project [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1307507, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1307509, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1307513, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1307514, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520, COL_15EAD78F_1575_44B6_9C81_A848988B6244#1307575, str_replace(str_remove_space(str_join(array(null, null, null, COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#1308608, null, str_if_with_rule(((COL_4DA521F7_900D_4579_BF5A_0030844A1E22#1308671 <=> 1) AND (str_if_with_rule((((NOT (COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#1308608 <=> FPV-) AND CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPV)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPV) END) OR (COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#1308608 <=> FPV+)) OR CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPM)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPM) END), 1, 0) <=> 1)), str_if_with_rule((COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#1308640 <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, CFU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, CFU) END, CFU-, null))), ), ONLY_ONE), , ,) AS COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1308894]
Project [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1307507, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1307509, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1307513, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1307514, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, str_if_with_rule((COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#1308281 <=> 1), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#1308286 <=> 1), null, FPV+), str_if_with_rule((COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#1308286 <=> 1), FPV-, null)) AS COL_02F9F9EC_9115_45CC_8C49_284B6393E25E#1308608, COL_15EAD78F_1575_44B6_9C81_A848988B6244#1307575, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, CFU)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, CFU) END, 1, 0) AS COL_D7BBBEB2_EBEC_4917_9F64_4B75517FDE2F#1308640, str_if_with_rule((((COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519 <=> 4) AND ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520 <=> 10) OR (COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520 <=> 13))) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519 <=> 0))), 1, 0) AS COL_4DA521F7_900D_4579_BF5A_0030844A1E22#1308671]
Project [COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1307507, COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1307509, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1307513, COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1307514, COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519, COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520, COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, str_if_with_rule((((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520 <=> 10) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519 <=> 4)) OR ((COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520 <=> 41) AND (COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519 <=> 0))), 1, 0) AS COL_3F93AC42_AB40_43A8_9084_C5E0610FF0E1#1308281, str_if_with_rule(CASE WHEN isnull(Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPV)) THEN false ELSE Contains(COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521, FPV) END, 1, 0) AS COL_4C1D6A5B_F0A9_4DAA_B053_C73132684F4A#1308286, REGLES_A_APPLIQ_188031_APPLICABLE_188033#1307548 AS COL_15EAD78F_1575_44B6_9C81_A848988B6244#1307575]
WholeStageCodegen (3)
CartesianProduct
Project [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1307274 AS COL_597B3862_9A4F_4729_9C5A_5165E797CC60#1307507, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1307276 AS COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1307509, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1307280 AS COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1307513, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1307281 AS COL_6D8CD11F_C576_42E2_86B8_DC6F5F42EE03#1307514, COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 AS COL_594EE85F_5C4E_4C38_BF0A_B20BA69148B3#1307519, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 AS COL_5E499CAA_5EE2_43AE_82A4_8E9674C85107#1307520, COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288 AS COL_EB343FAC_E34F_4881_8FE4_47C3CA912FD9#1307521]
Filter ((NOT (str_replace(str_remove_space(str_join(array(null, null, null, str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)), null, str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END) OR (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+)) OR CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPM) END), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU) END, CFU-, null))), ), ONLY_ONE), , ,) <=> ) AND isnotnull(str_replace(str_remove_space(str_join(array(null, null, null, str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)), null, str_if_with_rule(((str_if_with_rule((((COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4) AND ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) OR (COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 13))) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1) AND (str_if_with_rule((((NOT (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV-) AND CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END) OR (str_if_with_rule((str_if_with_rule((((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 10) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 4)) OR ((COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287 <=> 41) AND (COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286 <=> 0))), 1, 0) <=> 1), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, 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#1307288, FPV)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPV) END, 1, 0) <=> 1), FPV-, null)) <=> FPV+)) OR CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPM)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, FPM) END), 1, 0) <=> 1)), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU) END, 1, 0) <=> 1), null, CFU+), str_if_with_rule(CASE WHEN isnull(Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU)) THEN false ELSE Contains(COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288, CFU) END, CFU-, null))), ), ONLY_ONE), , ,))) AND isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1307276))
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1307274,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1307276,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1307280,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1307281,COL_43523D61_1E4B_4377_998B_7E898D87B867#1307286,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1307287,COL_60F7C888_9836_4535_A22F_D43D2994E019#1307288] Batched: true, DataFilters: [NOT (str_replace(str_remove_space(str_join(array(null, null, null, str_if_with_rule((str_if_with..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182], 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#1307253 AS REGLES_A_APPLIQ_188031_APPLICABLE_188033#1307548]
Filter ((isnotnull(REGLES#1307252) AND (RC-FP* et CFU = REGLES#1307252)) AND (APPLICABLE#1307253 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#1307252,APPLICABLE#1307253] Batched: false, DataFilters: [isnotnull(REGLES#1307252), (RC-FP* et CFU = REGLES#1307252), (APPLICABLE#1307253 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FP* et CFU), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>