digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n35.6 s (3.3 s, 3.6 s, 3.9 s (stage 44471.0: task 63168))";
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="<b>Filter</b><br><br>number of output rows: 15"];
}
7 [labelType="html" label="<b>Window</b><br><br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44461.0: task 63161))"];
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n36.2 s (3.3 s, 3.7 s, 4.0 s (stage 44471.0: task 63168))";
9 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>76 ms (6 ms, 6 ms, 12 ms (stage 44468.0: task 63166))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44461.0: task 63161))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44461.0: task 63161))"];
}
10 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 299,977<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>88 ms (8 ms, 8 ms, 10 ms (stage 44458.0: task 63152))<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: 299,977<br>local bytes read total (min, med, max (stageId: taskId))<br>26.0 MiB (2.6 MiB, 2.6 MiB, 2.6 MiB (stage 44468.0: task 63166))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44461.0: task 63161))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 100<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>105.8 MiB (10.5 MiB, 10.6 MiB, 10.8 MiB (stage 44458.0: task 63156))<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>26.0 MiB (2.6 MiB, 2.6 MiB, 2.6 MiB (stage 44458.0: task 63156))"];
11 [labelType="html" label="<b>Window</b><br><br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44458.0: task 63151))"];
subgraph cluster12 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n1.2 s (107 ms, 115 ms, 169 ms (stage 44458.0: task 63158))";
13 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>62 ms (6 ms, 6 ms, 8 ms (stage 44458.0: task 63158))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44458.0: task 63151))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44458.0: task 63151))"];
}
14 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 299,977<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>91 ms (7 ms, 8 ms, 14 ms (stage 44456.0: task 63150))<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: 299,977<br>local bytes read total (min, med, max (stageId: taskId))<br>21.4 MiB (2.1 MiB, 2.1 MiB, 2.2 MiB (stage 44458.0: task 63156))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44458.0: task 63151))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 100<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>87.6 MiB (8.6 MiB, 8.7 MiB, 9.1 MiB (stage 44456.0: task 63141))<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>21.4 MiB (2.1 MiB, 2.1 MiB, 2.2 MiB (stage 44456.0: task 63141))"];
subgraph cluster15 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (136 ms, 175 ms, 226 ms (stage 44456.0: task 63150))";
16 [labelType="html" label="<br><b>Project</b><br><br>"];
}
17 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 299,977"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (137 ms, 175 ms, 226 ms (stage 44456.0: task 63150))";
19 [labelType="html" label="<br><b>Project</b><br><br>"];
20 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 299,977"];
21 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 350,135<br>number of input batches: 90"];
}
22 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>162 ms (11 ms, 14 ms, 44 ms (stage 44456.0: task 63143))<br>metadata time: 0 ms<br>size of files read: 23.0 MiB<br>number of output rows: 350,135"];
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n63 ms (2 ms, 3 ms, 33 ms (stage 44456.0: task 63144))";
24 [labelType="html" label="<br><b>Project</b><br><br>"];
25 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10"];
}
26 [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: 174.0 B"];
1->0;
3->1;
4->3;
5->4;
6->5;
7->6;
9->7;
10->9;
11->10;
13->11;
14->13;
16->14;
17->16;
19->17;
20->19;
21->20;
22->21;
24->17;
25->24;
26->25;
}
27
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_if_with_rule((((COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077 <=> 1) OR (COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078 <=> 1)) OR (COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079 <=> 1)), 1, ) AS COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, str_create(RC DBL-RSF) AS COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, str_concat(array(Suppression de Forfait@, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))) AS COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) AS COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT) AS COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851]
Filter ((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199) END) OR CASE WHEN isnull(Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199)) THEN false ELSE Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199) END)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (5)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 10), ENSURE_REQUIREMENTS, [plan_id=1805751]
Window [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (4)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 10), ENSURE_REQUIREMENTS, [plan_id=1805677]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
WholeStageCodegen (3)
CartesianProduct
Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438]
Filter NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A) END
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163,COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172,COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173] Batched: true, DataFilters: [NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A)) THEN false..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_212978], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_CEFA2472_1E3F_469C_9633_864540C40AD9:i...
Project [APPLICABLE#3838124 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449]
Filter ((isnotnull(REGLES#3838123) AND (RC-DBL-RSF = REGLES#3838123)) AND (APPLICABLE#3838124 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#3838123,APPLICABLE#3838124] Batched: false, DataFilters: [isnotnull(REGLES#3838123), (RC-DBL-RSF = REGLES#3838123), (APPLICABLE#3838124 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_212796/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-DBL-RSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
== Physical Plan ==
AdaptiveSparkPlan (40)
+- == Final Plan ==
CollectLimit (22)
+- * Project (21)
+- * Project (20)
+- * Project (19)
+- * Filter (18)
+- Window (17)
+- * Sort (16)
+- ShuffleQueryStage (15), Statistics(sizeInBytes=105.8 MiB, rowCount=3.00E+5)
+- Exchange (14)
+- Window (13)
+- * Sort (12)
+- ShuffleQueryStage (11), Statistics(sizeInBytes=87.6 MiB, rowCount=3.00E+5)
+- Exchange (10)
+- * Project (9)
+- CartesianProduct Inner (8)
:- * Project (4)
: +- * Filter (3)
: +- * ColumnarToRow (2)
: +- Scan parquet (1)
+- * Project (7)
+- * Filter (6)
+- Scan csv (5)
+- == Initial Plan ==
CollectLimit (39)
+- Project (38)
+- Project (37)
+- Project (36)
+- Filter (35)
+- Window (34)
+- Sort (33)
+- Exchange (32)
+- Window (31)
+- Sort (30)
+- Exchange (29)
+- Project (28)
+- CartesianProduct Inner (27)
:- Project (24)
: +- Filter (23)
: +- Scan parquet (1)
+- Project (26)
+- Filter (25)
+- Scan csv (5)
(1) Scan parquet
Output [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_212978]
ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_CEFA2472_1E3F_469C_9633_864540C40AD9:int,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC:string,COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4:string,COL_B2D69078_23A7_4B36_BBF2_3F9C29840464:string>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
(3) Filter [codegen id : 1]
Input [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A) END
(4) Project [codegen id : 1]
Output [6]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438]
Input [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
(5) Scan csv
Output [2]: [REGLES#3838123, APPLICABLE#3838124]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_212796/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-DBL-RSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#3838123, APPLICABLE#3838124]
Condition : ((isnotnull(REGLES#3838123) AND (RC-DBL-RSF = REGLES#3838123)) AND (APPLICABLE#3838124 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#3838124 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449]
Input [2]: [REGLES#3838123, APPLICABLE#3838124]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Input [7]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449]
(10) Exchange
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 10), ENSURE_REQUIREMENTS, [plan_id=1805677]
(11) ShuffleQueryStage
Output [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: 0
(12) Sort [codegen id : 4]
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(13) Window
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614], [1 DESC NULLS LAST]
(14) Exchange
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 10), ENSURE_REQUIREMENTS, [plan_id=1805751]
(15) ShuffleQueryStage
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: 1
(16) Sort [codegen id : 5]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(17) Window
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613], [1 DESC NULLS LAST]
(18) Filter [codegen id : 6]
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742]
Condition : ((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199) END) OR CASE WHEN isnull(Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199)) THEN false ELSE Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199) END)
(19) Project [codegen id : 6]
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851]
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742]
(20) Project [codegen id : 6]
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT) AS COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851]
(21) Project [codegen id : 6]
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_if_with_rule((((COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077 <=> 1) OR (COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078 <=> 1)) OR (COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079 <=> 1)), 1, ) AS COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, str_create(RC DBL-RSF) AS COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, str_concat(array(Suppression de Forfait@, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))) AS COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) AS COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103]
(22) CollectLimit
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: 1500
(23) Filter
Input [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, A) END
(24) Project
Output [6]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438]
Input [7]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3838142, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3838144, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3838145, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3838146, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3838163, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3838172, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3838173]
(25) Filter
Input [2]: [REGLES#3838123, APPLICABLE#3838124]
Condition : ((isnotnull(REGLES#3838123) AND (RC-DBL-RSF = REGLES#3838123)) AND (APPLICABLE#3838124 <=> O))
(26) Project
Output [1]: [APPLICABLE#3838124 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449]
Input [2]: [REGLES#3838123, APPLICABLE#3838124]
(27) CartesianProduct
Join type: Inner
Join condition: None
(28) Project
Output [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Input [7]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3838449]
(29) Exchange
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 10), ENSURE_REQUIREMENTS, [plan_id=1805625]
(30) Sort
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(31) Window
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614], [1 DESC NULLS LAST]
(32) Exchange
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 10), ENSURE_REQUIREMENTS, [plan_id=1805629]
(33) Sort
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(34) Window
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613], [1 DESC NULLS LAST]
(35) Filter
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742]
Condition : ((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((((str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)) OR (str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) <=> 1)), 1, ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_create(RC DBL-RSF))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(Suppression de Forfait@, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ), @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))))), 243254199) END) OR CASE WHEN isnull(Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199)) THEN false ELSE Contains(cast(int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463)), 243254199) END)
(36) Project
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851]
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3838613, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3838646, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742]
(37) Project
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, str_extract_by_str(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, -, RIGHT) AS COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3838437, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3838693L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3838614, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3838742, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3838851]
(38) Project
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, str_if_with_rule((((COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077 <=> 1) OR (COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078 <=> 1)) OR (COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079 <=> 1)), 1, ) AS COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, str_create(RC DBL-RSF) AS COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, str_concat(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, -!, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, _, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, str_concat(array(Suppression de Forfait@, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, @, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438)) AS COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, str_concat(array(str_join(array(Suppression Doublon du RSF, int_to_str(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432)), -))) AS COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, int_create(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432) AS COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103]
(39) CollectLimit
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: 1500
(40) AdaptiveSparkPlan
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3838431, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3838432, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3838434, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3838436, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3839080, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3838438, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3839077, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3839078, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3839079, COL_33AC5813_B6CD_4BC6_8242_F7D5955D24DC#3839294, COL_84C53E17_0BB9_4F8A_B77D_E65F3D73209F#3839103, COL_EAE05588_2D3F_4748_9B79_D92ACB23F067#3839296, COL_93AE3F44_ACE2_4DCB_B04C_DE8D5790D101#3839297, COL_D0DE69B5_A369_4EF9_9F44_CF7D95310050#3839298, COL_C63CAED1_D0E2_4104_BC0C_5FC74C96BF92#3839299, COL_3823A558_7BE6_47C9_89DE_C420833259DA#3839300, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3838463]
Arguments: isFinalPlan=true