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))\n20.3 s (1.8 s, 2.1 s, 2.3 s (stage 44445.0: task 63102))";
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: 15"];
}
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 44442.0: task 63098))"];
subgraph cluster7 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n20.9 s (1.9 s, 2.2 s, 2.3 s (stage 44445.0: task 63102))";
8 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>63 ms (6 ms, 6 ms, 7 ms (stage 44442.0: task 63101))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44442.0: task 63098))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44442.0: task 63098))"];
}
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>102 ms (9 ms, 10 ms, 11 ms (stage 44432.0: task 63091))<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 44442.0: task 63101))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44442.0: task 63098))<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 44432.0: task 63091))<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 44432.0: task 63091))"];
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 44432.0: task 63087))"];
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (116 ms, 123 ms, 156 ms (stage 44432.0: task 63091))";
12 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>64 ms (6 ms, 6 ms, 7 ms (stage 44432.0: task 63086))<br>peak memory total (min, med, max (stageId: taskId))<br>170.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 44432.0: task 63087))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 44432.0: task 63087))"];
}
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>92 ms (8 ms, 9 ms, 10 ms (stage 44430.0: task 63080))<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 44432.0: task 63091))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 44432.0: task 63087))<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 44430.0: task 63076))<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 44430.0: task 63076))"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.9 s (169 ms, 195 ms, 219 ms (stage 44430.0: task 63076))";
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))\n1.9 s (169 ms, 196 ms, 220 ms (stage 44430.0: task 63076))";
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>153 ms (11 ms, 13 ms, 35 ms (stage 44430.0: task 63084))<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))\n26 ms (2 ms, 3 ms, 3 ms (stage 44430.0: task 63077))";
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#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485]
Filter (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199) END)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (5)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 10), ENSURE_REQUIREMENTS, [plan_id=1805205]
Window [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190], [1 DESC NULLS LAST]
Sort [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (4)
Exchange hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 10), ENSURE_REQUIREMENTS, [plan_id=1805134]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Project [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190]
WholeStageCodegen (3)
CartesianProduct
Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072]
Filter NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A) END
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797,COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806,COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807] Batched: true, DataFilters: [NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, 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#3835758 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083]
Filter ((isnotnull(REGLES#3835757) AND (RC-DBL-RSF = REGLES#3835757)) AND (APPLICABLE#3835758 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#3835757,APPLICABLE#3835758] Batched: false, DataFilters: [isnotnull(REGLES#3835757), (RC-DBL-RSF = REGLES#3835757), (APPLICABLE#3835758 <=> 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#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
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#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
(3) Filter [codegen id : 1]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A) END
(4) Project [codegen id : 1]
Output [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
(5) Scan csv
Output [2]: [REGLES#3835757, APPLICABLE#3835758]
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#3835757, APPLICABLE#3835758]
Condition : ((isnotnull(REGLES#3835757) AND (RC-DBL-RSF = REGLES#3835757)) AND (APPLICABLE#3835758 <=> O))
(7) Project [codegen id : 2]
Output [1]: [APPLICABLE#3835758 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083]
Input [2]: [REGLES#3835757, APPLICABLE#3835758]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190]
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083]
(10) Project [codegen id : 3]
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190]
(11) Exchange
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 10), ENSURE_REQUIREMENTS, [plan_id=1805134]
(12) ShuffleQueryStage
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: 0
(13) Sort [codegen id : 4]
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(14) Window
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190], [1 DESC NULLS LAST]
(15) Exchange
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 10), ENSURE_REQUIREMENTS, [plan_id=1805205]
(16) ShuffleQueryStage
Output [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: 1
(17) Sort [codegen id : 5]
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(18) Window
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179], [1 DESC NULLS LAST]
(19) Filter [codegen id : 6]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376]
Condition : (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199) END)
(20) Project [codegen id : 6]
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376]
(21) Project [codegen id : 6]
Output [21]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485]
(22) CollectLimit
Input [21]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: 1500
(23) Filter
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
Condition : NOT CASE WHEN isnull(StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A)) THEN false ELSE StartsWith(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, A) END
(24) Project
Output [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776 AS COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778 AS COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779 AS COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780 AS COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788 AS COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797 AS COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806 AS COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807 AS COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072]
Input [8]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#3835776, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#3835778, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#3835779, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#3835780, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#3835788, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#3835797, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#3835806, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#3835807]
(25) Filter
Input [2]: [REGLES#3835757, APPLICABLE#3835758]
Condition : ((isnotnull(REGLES#3835757) AND (RC-DBL-RSF = REGLES#3835757)) AND (APPLICABLE#3835758 <=> O))
(26) Project
Output [1]: [APPLICABLE#3835758 AS REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083]
Input [2]: [REGLES#3835757, APPLICABLE#3835758]
(27) CartesianProduct
Join type: Inner
Join condition: None
(28) Project
Output [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083 AS COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_join(array(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SS) END, SS*, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, SU) END AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUB)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUM)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU2)) AND NOT (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SU3)), SU*, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU)) THEN false ELSE StartsWith(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, FU) END, FU*, str_if_with_rule(((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIC) OR (COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM)), SI*, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)))) AS COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190]
Input [9]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, REGLES_A_APPLIQ_212923_APPLICABLE_212925#3836083]
(29) Project
Output [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, str_join(array(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072), -) AS COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Input [11]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190]
(30) Exchange
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 10), ENSURE_REQUIREMENTS, [plan_id=1805079]
(31) Sort
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(32) Window
Input [12]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: [collect_list(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 0, 0) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, count(1) windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190], [1 DESC NULLS LAST]
(33) Exchange
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: hashpartitioning(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 10), ENSURE_REQUIREMENTS, [plan_id=1805083]
(34) Sort
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068 ASC NULLS FIRST, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(35) Window
Input [14]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L]
Arguments: [row_number() windowspecdefinition(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376], [COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179], [1 DESC NULLS LAST]
(36) Filter
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376]
Condition : (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065)), 243254199) END OR CASE WHEN isnull(Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199)) THEN false ELSE Contains(cast(COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066 as string), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179)), 243254199) END) OR Contains(cast(COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249)), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ))), 243254199) END) OR Contains(cast(COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 as string), 243254199)) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIC) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSN) END AND CASE WHEN isnull(Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF)) THEN false ELSE Contains(str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280), SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ))), 243254199) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199)) THEN false ELSE Contains(str_remove_accent(upper(COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097)), 243254199) END)
(37) Project
Output [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, str_if_with_rule((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1), Trait, ) AS COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, str_list_as_str(COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280) AS COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485]
Input [15]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376]
(38) Project
Output [21]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SU*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SUF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SUF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SI*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIC) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SIM) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SIM), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, str_if_with_rule(((COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L > 1) AND (COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190 <=> SS*)), str_if_with_rule((CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSN) END AND CASE WHEN isnull(Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF)) THEN false ELSE Contains(COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, SSF) END), str_if_with_rule((COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070 <=> SSF), 1, ), str_if_with_rule((COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376 > 1), 1, )), ) AS COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, str_join(array(str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 7, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 5, 2), str_extract_middle(COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, 1, 4)), ) AS COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Input [17]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485]
(39) CollectLimit
Input [21]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: 1500
(40) AdaptiveSparkPlan
Output [21]: [COL_F1A5EBCC_B434_48F8_91A2_308534B1A640#3836065, COL_E330EE99_A328_496E_80B6_25B2D7CB4677#3836066, COL_8F619D37_09A8_4F1E_87D0_6E773792BCBF#3836067, COL_61FD7A9B_3C34_41AB_B7C6_A1A83575AE0A#3836068, COL_63547AC2_5784_462F_B7C6_4FC04EBA1DE0#3836069, COL_CB815C2C_5454_4B99_92AC_DB287B0702FF#3836070, COL_BF89C1A2_4AFA_45C4_9975_13CB5B490A33#3836071, COL_979ACEF9_0A9A_458D_920F_AEB1241F98D5#3836072, COL_7175D003_CC52_45DE_B7AC_182967CBBDEB#3836179, COL_B5CFEB01_25DB_4E06_A332_B639763883A4#3836327L, COL_47F06879_65A4_43A0_A1AE_73EAB94B3824#3836280, COL_58537AE8_C308_4D0B_A490_A6833DE36F07#3836190, COL_E772EB66_034C_43F7_9D28_FC11A1081BF7#3836249, COL_664CFF8A_045C_4BD8_AD38_8718F690F5BF#3836468, COL_C50674E1_02A7_4B50_AD44_5E24A3F3FC1C#3836376, COL_06564648_2F0F_44A3_A0DC_A6B4C2846533#3836485, COL_A281A8B6_1D5F_4D97_A281_D0C45377BDF1#3836669, COL_B9E3A8C8_69E0_4F50_B5BF_96786AE09702#3836670, COL_1B30CF55_748B_4183_BAFF_4E483748DC83#3836671, COL_9EB51151_720C_48FE_9329_D1497E19F37E#3836672, COL_032B6CD9_6C80_4F9C_ADFE_1C9206030F7B#3836097]
Arguments: isFinalPlan=true