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))\n21.4 s (1.8 s, 2.3 s, 2.5 s (stage 44583.0: task 63412))";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 20"];
}
6 [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 44577.0: task 63407))"];
subgraph cluster7 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n22.0 s (1.9 s, 2.4 s, 2.6 s (stage 44583.0: task 63412))";
8 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>97 ms (6 ms, 8 ms, 17 ms (stage 44580.0: task 63408))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44577.0: task 63407))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44577.0: task 63407))"];
}
9 [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>104 ms (8 ms, 9 ms, 12 ms (stage 44570.0: task 63401))<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>30.2 MiB (3.0 MiB, 3.0 MiB, 3.1 MiB (stage 44580.0: task 63411))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44577.0: task 63407))<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>124.1 MiB (12.3 MiB, 12.4 MiB, 12.6 MiB (stage 44570.0: task 63401))<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>30.2 MiB (3.0 MiB, 3.0 MiB, 3.1 MiB (stage 44570.0: task 63401))"];
10 [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 44570.0: task 63398))"];
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (122 ms, 127 ms, 146 ms (stage 44570.0: task 63400))";
12 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>65 ms (6 ms, 7 ms, 7 ms (stage 44570.0: task 63396))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44570.0: task 63398))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44570.0: task 63398))"];
}
13 [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 (7 ms, 8 ms, 10 ms (stage 44568.0: task 63386))<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>24.9 MiB (2.5 MiB, 2.5 MiB, 2.5 MiB (stage 44570.0: task 63401))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44570.0: task 63398))<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.9 MiB (10.4 MiB, 10.5 MiB, 11.0 MiB (stage 44568.0: task 63386))<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>24.9 MiB (2.4 MiB, 2.5 MiB, 2.6 MiB (stage 44568.0: task 63386))"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (171 ms, 188 ms, 299 ms (stage 44568.0: task 63386))";
15 [labelType="html" label="<br><b>Project</b><br><br>"];
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))\n2.0 s (171 ms, 189 ms, 300 ms (stage 44568.0: task 63386))";
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>139 ms (11 ms, 13 ms, 23 ms (stage 44568.0: task 63386))<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))\n31 ms (2 ms, 3 ms, 4 ms (stage 44568.0: task 63387))";
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;
8->6;
9->8;
10->9;
12->10;
13->12;
15->13;
16->15;
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#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ) AS COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397]
Filter ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453) END)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (5)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 10), ENSURE_REQUIREMENTS, [plan_id=1809150]
Window [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (4)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 10), ENSURE_REQUIREMENTS, [plan_id=1809079]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102]
WholeStageCodegen (3)
CartesianProduct
Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984]
Filter NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A) END
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709,COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718,COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719] Batched: true, DataFilters: [NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, 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#3847670 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995]
Filter ((isnotnull(REGLES#3847669) AND (RC-DBL-RSF = REGLES#3847669)) AND (APPLICABLE#3847670 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#3847669,APPLICABLE#3847670] Batched: false, DataFilters: [isnotnull(REGLES#3847669), (RC-DBL-RSF = REGLES#3847669), (APPLICABLE#3847670 <=> 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)
+- * Filter (19)
+- Window (18)
+- * Sort (17)
+- ShuffleQueryStage (16), Statistics(sizeInBytes=124.1 MiB, rowCount=3.00E+5)
+- Exchange (15)
+- Window (14)
+- * Sort (13)
+- ShuffleQueryStage (12), Statistics(sizeInBytes=105.9 MiB, rowCount=3.00E+5)
+- Exchange (11)
+- * Project (10)
+- * Project (9)
+- CartesianProduct Inner (8)
:- * Project (4)
: +- * Filter (3)
: +- * ColumnarToRow (2)
: +- Scan parquet (1)
+- * Project (7)
+- * Filter (6)
+- Scan csv (5)
+- == Initial Plan ==
CollectLimit (39)
+- Project (38)
+- Project (37)
+- Filter (36)
+- Window (35)
+- Sort (34)
+- Exchange (33)
+- Window (32)
+- Sort (31)
+- Exchange (30)
+- Project (29)
+- Project (28)
+- CartesianProduct Inner (27)
:- Project (24)
: +- Filter (23)
: +- Scan parquet (1)
+- Project (26)
+- Filter (25)
+- Scan csv (5)
(1) Scan parquet
Output [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
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_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51: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 [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
(3) Filter [codegen id : 1]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A) END
(4) Project [codegen id : 1]
Output [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
(5) Scan csv
Output [2]: [REGLES#3847669, APPLICABLE#3847670]
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#3847669, APPLICABLE#3847670]
Condition : ((isnotnull(REGLES#3847669) AND (RC-DBL-RSF = REGLES#3847669)) AND (APPLICABLE#3847670 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#3847670 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995]
Input [2]: [REGLES#3847669, APPLICABLE#3847670]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102]
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995]
(10) Project [codegen id : 3]
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102]
(11) Exchange
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 10), ENSURE_REQUIREMENTS, [plan_id=1809079]
(12) ShuffleQueryStage
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: 0
(13) Sort [codegen id : 4]
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(14) Window
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102], [1 DESC NULLS LAST]
(15) Exchange
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 10), ENSURE_REQUIREMENTS, [plan_id=1809150]
(16) ShuffleQueryStage
Output [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: 1
(17) Sort [codegen id : 5]
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(18) Window
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091], [1 DESC NULLS LAST]
(19) Filter [codegen id : 6]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288]
Condition : ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453) END)
(20) Project [codegen id : 6]
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288]
(21) Project [codegen id : 6]
Output [22]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ) AS COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397]
(22) CollectLimit
Input [22]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Arguments: 1500
(23) Filter
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, A) END
(24) Project
Output [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3847688, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3847690, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3847691, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3847692, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3847700, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3847709, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3847718, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3847719]
(25) Filter
Input [2]: [REGLES#3847669, APPLICABLE#3847670]
Condition : ((isnotnull(REGLES#3847669) AND (RC-DBL-RSF = REGLES#3847669)) AND (APPLICABLE#3847670 <=> O))
(26) Project
Output [1]: [APPLICABLE#3847670 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995]
Input [2]: [REGLES#3847669, APPLICABLE#3847670]
(27) CartesianProduct
Join type: Inner
Join condition: None
(28) Project
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102]
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3847995]
(29) Project
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102]
(30) Exchange
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 10), ENSURE_REQUIREMENTS, [plan_id=1809024]
(31) Sort
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(32) Window
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102], [1 DESC NULLS LAST]
(33) Exchange
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 10), ENSURE_REQUIREMENTS, [plan_id=1809028]
(34) Sort
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(35) Window
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091], [1 DESC NULLS LAST]
(36) Filter
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288]
Condition : ((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977)), 243267453) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978 as string), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091)), 243267453) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ))), 243267453) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 as string), 243267453)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ))), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009)), 243267453) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ))), 243267453) END)
(37) Project
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288]
(38) Project
Output [22]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L > 1) AND CASE WHEN isnull(Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS)) THEN false ELSE Contains(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, SAS) END), 1, ) AS COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397]
(39) CollectLimit
Input [22]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Arguments: 1500
(40) AdaptiveSparkPlan
Output [22]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3847977, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3847978, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3847979, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3847980, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3847981, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3847982, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3847983, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3847984, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3848091, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3848239L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3848192, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3848102, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3848161, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3848380, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3848288, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3848397, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3848604, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3848605, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3848606, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3848607, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3848009, COL_68CB48BF_8741_4573_9E9F_2677383D6124#3848609]
Arguments: isFinalPlan=true