SP1 - Details for Query 3425

Submitted Time: 2026/08/26 10:30:06
Duration: 0.1 s
Failed Jobs: 3893

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; 2 [labelType="html" label=" HashAggregate "]; 3 [labelType="html" label=" Exchange "]; 4 [labelType="html" label=" HashAggregate "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Filter "]; 7 [labelType="html" label=" Window "]; 8 [labelType="html" label=" Sort "]; 9 [labelType="html" label=" Exchange "]; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label=" SortMergeJoin "]; 12 [labelType="html" label=" Sort "]; 13 [labelType="html" label=" Exchange "]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (3)"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label=" Filter "]; 17 [labelType="html" label=" Generate "]; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label=" Project "]; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label=" Project "]; } 24 [labelType="html" label=" CartesianProduct "]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (1)"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label=" ColumnarToRow "]; } 28 [labelType="html" label=" Scan parquet "]; subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (2)"; 30 [labelType="html" label=" Project "]; 31 [labelType="html" label=" ColumnarToRow "]; } 32 [labelType="html" label=" Scan parquet "]; 33 [labelType="html" label=" Sort "]; 34 [labelType="html" label="Exchange number of partitions: 10"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (4)"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label=" Filter "]; } 38 [labelType="html" label="Scan csv number of files read: 1 metadata time: 0 ms size of files read: 952.0 B"]; 1->0; 2->1; 3->2; 4->3; 5->4; 6->5; 7->6; 8->7; 9->8; 10->9; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; 19->18; 20->19; 21->20; 22->21; 23->22; 24->23; 26->24; 27->26; 28->27; 30->24; 31->30; 32->31; 33->11; 34->33; 36->34; 37->36; 38->37; }

AdaptiveSparkPlan isFinalPlan=false

TakeOrderedAndProject(limit=500000, orderBy=[COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L DESC NULLS LAST], output=[COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294,COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295,COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296,COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297,COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L])

HashAggregate(keys=[COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194], functions=[count(1)])

Exchange hashpartitioning(COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, 10), ENSURE_REQUIREMENTS, [plan_id=113605]

Project [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 AS COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351 AS COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352 AS COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353 AS COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]

Filter (COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L <=> 2)

Window [count(1) windowspecdefinition(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L], [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131], [1 DESC NULLS LAST]

Sort [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129 ASC NULLS FIRST, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Exchange hashpartitioning(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 10), ENSURE_REQUIREMENTS, [plan_id=113599]

Project [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, THESREGLES_66145_LIBELLE_66147#828025 AS COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, THESREGLES_66145_PRIORITE_66148#828026 AS COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, THESREGLES_66145_CATEGORIE_66149#828024 AS COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]

SortMergeJoin [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832], [THESREGLES_66145_REGLES_66146#828027], LeftOuter

Sort [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 ASC NULLS FIRST], false, 0

Exchange hashpartitioning(COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, 10), ENSURE_REQUIREMENTS, [plan_id=113545]

Project [str_extract_by_str(col1#825419, @, LEFT) AS COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668 AS COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670 AS COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]

Filter NOT (str_remove_accent(upper(col1#825419)) <=> )

Generate stack(9, RD001, COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, RD002, COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, RD003, COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, RN001, COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, RN002, COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, RN003, null, RN004, COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, RP001, null, RS001, COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229), [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670], false, [col0#825418, col1#825419]

Project [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382 AS COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389 AS COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619 AS COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620 AS COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, COL_E989545D_EB28_4780_8678_8516E577F623#818621 AS COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, COL_CF21557A_4168_4725_901E_C283B950D1C9#818622 AS COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623 AS COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, str_if_with_rule(((CASE WHEN isnull(((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2))) THEN false ELSE ((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2)) END AND CASE WHEN isnull(((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2))) THEN false ELSE ((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2)) END) AND NOT (str_remove_accent(upper(COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)), ) AS COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, str_if_with_rule((CASE WHEN isnull(((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2))) THEN false ELSE ((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2)) END AND NOT (COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386 <=> COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393)), RS001@, ) AS COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229]

Project [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_if_with_rule(((COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771 <=> 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0)), RD001@, ) AS COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619, str_if_with_rule(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0) AND (COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 1)), RD002@, ) AS COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620, str_if_with_rule((((COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND NOT (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR)) OR (NOT (COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR))), RD003@, ) AS COL_E989545D_EB28_4780_8678_8516E577F623#818621, str_if_with_rule(((COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 0) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 1)), RN001@, ) AS COL_CF21557A_4168_4725_901E_C283B950D1C9#818622, str_if_with_rule((CASE WHEN isnull(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2))) THEN false ELSE ((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2)) END AND ((COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390 <=> COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385) OR (COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392 <=> COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383))), RN002@, ) AS COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623, int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383), str_size(COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390))))) AS COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588, str_levenshtein(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390) AS COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216, str_extract(str_diff(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390), LEFT, 1) AS COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517]

Project [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, RIGHT, 2)) <=> str_extract(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, RIGHT, 2)) AND NOT (str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)) <=> )) AND NOT (str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> )) AND NOT (COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261 <=> COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263) <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> )) AND NOT (str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)) <=> )) AND (COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721 <=> 12)) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265) <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> )) AND NOT (str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)) <=> )) AND CASE WHEN isnull(COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326) THEN false ELSE (COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326 <= 31) END) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)))), 1, 0))))) AS COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771, dec_to_int(dec_operator(SOMME, array(COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399))) AS COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255]

Project [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262))), 0, 1)), str_to_integer(str_if_with_rule((COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263 <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264), 0, 1)), str_to_integer(str_if_with_rule((COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265 <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266), 0, 1))))) AS COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_to_integer(str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) AS COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326, str_to_integer(str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) AS COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721]

Project [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 AS COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 AS COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 AS COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 AS COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 AS COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276 AS COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277 AS COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_EC933D6C_8084_4730_A30C_8DD484065385#794279 AS COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280 AS COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281 AS COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284 AS COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285 AS COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286 AS COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) AS COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, str_extract(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, LEFT, 4) AS COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) AS COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 5, 7) AS COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) AS COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 8, 10) AS COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288))) AS COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922]

Project [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699 AS COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 AS COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 AS COL_EC933D6C_8084_4730_A30C_8DD484065385#794279, DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703 AS COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280, DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 AS COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)) AS COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)) AS COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)) AS COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)) AS COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)) AS COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288]

WholeStageCodegen (3)

CartesianProduct (((((CASE WHEN isnull(((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0))) THEN false ELSE ((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0)) END AND (str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)) <=> 1)) AND (str_if_with_rule((str_remove_accent(upper(DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705)) <=> str_remove_accent(upper(COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565))), 1, 0) <=> 1)) AND NOT (str_remove_accent(upper(str_remove_space(str_concat(array(str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4), RIGHT, 2)) <=> str_extract(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4), RIGHT, 2)) AND NOT (str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))) <=> )) AND NOT (str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> )) AND NOT (str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) <=> str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))) <=> )) AND (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> 12)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))) <=> )) AND CASE WHEN isnull(str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)))) THEN false ELSE (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <= 31) END) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))))), 1, 0))))) <=> 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0)), RD001@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 1)), RD002@, ), str_if_with_rule((((DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND NOT (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR)) OR (NOT (DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR))), RD003@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 1)), RN001@, ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2)) END AND ((DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 <=> COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561) OR (DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 <=> COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559))), RN002@, ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2))) THEN false ELSE ((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))) <=> )), str_concat(array(RN003@, Vérifier le nom de naissance avant le caractère , str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2))) THEN false ELSE ((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2))) THEN false ELSE ((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))) <=> )), str_concat(array(RP001@, Vérifer le prénom avant le caractère , str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))), ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2)) END AND NOT (COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703)), RS001@, ))), ALL))) <=> )) AND CASE WHEN isnull(str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702)) THEN false ELSE (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2) END) AND CASE WHEN (isnull(COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564) OR isnull(DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713)) THEN false ELSE (COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564 >= DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713) END)

Project [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887 AS COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_837B874F_9439_4F75_8914_1E97295E3979#790888 AS COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889 AS COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890 AS COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891 AS COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892 AS COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901 AS COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893 AS COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887,COL_837B874F_9439_4F75_8914_1E97295E3979#790888,COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889,COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890,COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891,COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892,COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893,COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/DATA_POPULATION_65578], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD:string,COL_837B874F_9439_4F75_8914_1E97295E3979:s...

Project [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873 AS DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699, COL_837B874F_9439_4F75_8914_1E97295E3979#791874 AS DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875 AS DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876 AS DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877 AS DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878 AS DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879 AS DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887 AS DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713]

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873,COL_837B874F_9439_4F75_8914_1E97295E3979#791874,COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875,COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876,COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877,COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878,COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879,COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/DATA_POPULATION_65578], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD:string,COL_837B874F_9439_4F75_8914_1E97295E3979:s...

Sort [THESREGLES_66145_REGLES_66146#828027 ASC NULLS FIRST], false, 0

Exchange hashpartitioning(THESREGLES_66145_REGLES_66146#828027, 10), ENSURE_REQUIREMENTS, [plan_id=113586]

Project [Catégorie#790475 AS THESREGLES_66145_CATEGORIE_66149#828024, Libellé#790469 AS THESREGLES_66145_LIBELLE_66147#828025, Priorité#790473 AS THESREGLES_66145_PRIORITE_66148#828026, Règles#790464 AS THESREGLES_66145_REGLES_66146#828027]

Filter isnotnull(Règles#790464)

WholeStageCodegen (4)

FileScan csv [Règles#790464,Libellé#790469,Priorité#790473,Catégorie#790475] Batched: false, DataFilters: [isnotnull(Règles#790464)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/3FD04C82_31D1_49CF_86B4_9E4AE0DD2..., PartitionFilters: [], PushedFilters: [IsNotNull(Règles)], ReadSchema: struct<Règles:string,Libellé:string,Priorité:string,Catégorie:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (66)
+- == Current Plan ==
   TakeOrderedAndProject (36)
   +- HashAggregate (35)
      +- Exchange (34)
         +- HashAggregate (33)
            +- Project (32)
               +- Filter (31)
                  +- Window (30)
                     +- Sort (29)
                        +- Exchange (28)
                           +- Project (27)
                              +- SortMergeJoin LeftOuter (26)
                                 :- Sort (19)
                                 :  +- ShuffleQueryStage (18)
                                 :     +- Exchange (17)
                                 :        +- * Project (16)
                                 :           +- * Filter (15)
                                 :              +- * Generate (14)
                                 :                 +- * Project (13)
                                 :                    +- * Project (12)
                                 :                       +- * Project (11)
                                 :                          +- * Project (10)
                                 :                             +- * Project (9)
                                 :                                +- * Project (8)
                                 :                                   +- CartesianProduct Inner (7)
                                 :                                      :- * Project (3)
                                 :                                      :  +- * ColumnarToRow (2)
                                 :                                      :     +- Scan parquet  (1)
                                 :                                      +- * Project (6)
                                 :                                         +- * ColumnarToRow (5)
                                 :                                            +- Scan parquet  (4)
                                 +- Sort (25)
                                    +- ShuffleQueryStage (24)
                                       +- Exchange (23)
                                          +- * Project (22)
                                             +- * Filter (21)
                                                +- Scan csv  (20)
+- == Initial Plan ==
   TakeOrderedAndProject (65)
   +- HashAggregate (64)
      +- Exchange (63)
         +- HashAggregate (62)
            +- Project (61)
               +- Filter (60)
                  +- Window (59)
                     +- Sort (58)
                        +- Exchange (57)
                           +- Project (56)
                              +- SortMergeJoin LeftOuter (55)
                                 :- Sort (50)
                                 :  +- Exchange (49)
                                 :     +- Project (48)
                                 :        +- Filter (47)
                                 :           +- Generate (46)
                                 :              +- Project (45)
                                 :                 +- Project (44)
                                 :                    +- Project (43)
                                 :                       +- Project (42)
                                 :                          +- Project (41)
                                 :                             +- Project (40)
                                 :                                +- CartesianProduct Inner (39)
                                 :                                   :- Project (37)
                                 :                                   :  +- Scan parquet  (1)
                                 :                                   +- Project (38)
                                 :                                      +- Scan parquet  (4)
                                 +- Sort (54)
                                    +- Exchange (53)
                                       +- Project (52)
                                          +- Filter (51)
                                             +- Scan csv  (20)


(1) Scan parquet 
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887, COL_837B874F_9439_4F75_8914_1E97295E3979#790888, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/DATA_POPULATION_65578]
ReadSchema: struct<COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD:string,COL_837B874F_9439_4F75_8914_1E97295E3979:string,COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52:string,COL_35D638BA_CDB3_4304_AD61_4B269A20ED47:string,COL_4A8C4FD9_928A_432E_A343_86F58F1512D8:string,COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2:string,COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307:string,COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC:int>

(2) ColumnarToRow [codegen id : 1]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887, COL_837B874F_9439_4F75_8914_1E97295E3979#790888, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901]

(3) Project [codegen id : 1]
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887 AS COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_837B874F_9439_4F75_8914_1E97295E3979#790888 AS COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889 AS COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890 AS COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891 AS COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892 AS COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901 AS COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893 AS COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887, COL_837B874F_9439_4F75_8914_1E97295E3979#790888, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901]

(4) Scan parquet 
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873, COL_837B874F_9439_4F75_8914_1E97295E3979#791874, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/DATA_POPULATION_65578]
ReadSchema: struct<COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD:string,COL_837B874F_9439_4F75_8914_1E97295E3979:string,COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52:string,COL_35D638BA_CDB3_4304_AD61_4B269A20ED47:string,COL_4A8C4FD9_928A_432E_A343_86F58F1512D8:string,COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2:string,COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307:string,COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC:int>

(5) ColumnarToRow [codegen id : 2]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873, COL_837B874F_9439_4F75_8914_1E97295E3979#791874, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887]

(6) Project [codegen id : 2]
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873 AS DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699, COL_837B874F_9439_4F75_8914_1E97295E3979#791874 AS DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875 AS DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876 AS DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877 AS DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878 AS DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879 AS DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887 AS DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873, COL_837B874F_9439_4F75_8914_1E97295E3979#791874, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887]

(7) CartesianProduct
Join type: Inner
Join condition: (((((CASE WHEN isnull(((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0))) THEN false ELSE ((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0)) END AND (str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)) <=> 1)) AND (str_if_with_rule((str_remove_accent(upper(DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705)) <=> str_remove_accent(upper(COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565))), 1, 0) <=> 1)) AND NOT (str_remove_accent(upper(str_remove_space(str_concat(array(str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4), RIGHT, 2)) <=> str_extract(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4), RIGHT, 2)) AND NOT (str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))) <=> )) AND NOT (str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> )) AND NOT (str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) <=> str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))) <=> )) AND (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> 12)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))) <=> )) AND CASE WHEN isnull(str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)))) THEN false ELSE (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <= 31) END) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))))), 1, 0))))) <=> 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0)), RD001@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 1)), RD002@, ), str_if_with_rule((((DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND NOT (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR)) OR (NOT (DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR))), RD003@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 1)), RN001@, ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2)) END AND ((DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 <=> COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561) OR (DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 <=> COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559))), RN002@, ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2))) THEN false ELSE ((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))) <=> )), str_concat(array(RN003@, Vérifier le nom de naissance avant le caractère , str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2))) THEN false ELSE ((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2))) THEN false ELSE ((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))) <=> )), str_concat(array(RP001@, Vérifer le prénom avant le caractère , str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))), ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2)) END AND NOT (COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703)), RS001@, ))), ALL))) <=> )) AND CASE WHEN isnull(str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702)) THEN false ELSE (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2) END) AND CASE WHEN (isnull(COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564) OR isnull(DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713)) THEN false ELSE (COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564 >= DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713) END)

(8) Project [codegen id : 3]
Output [15]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699 AS COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 AS COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 AS COL_EC933D6C_8084_4730_A30C_8DD484065385#794279, DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703 AS COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280, DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 AS COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)) AS COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)) AS COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)) AS COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)) AS COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)) AS COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288]
Input [16]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564, COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565, DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702, DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703, DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705, DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713]

(9) Project [codegen id : 3]
Output [20]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 AS COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 AS COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 AS COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 AS COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 AS COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276 AS COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277 AS COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_EC933D6C_8084_4730_A30C_8DD484065385#794279 AS COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280 AS COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281 AS COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284 AS COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285 AS COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286 AS COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) AS COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, str_extract(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, LEFT, 4) AS COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) AS COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 5, 7) AS COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) AS COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 8, 10) AS COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288))) AS COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922]
Input [15]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276, COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277, COL_EC933D6C_8084_4730_A30C_8DD484065385#794279, COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280, COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288]

(10) Project [codegen id : 3]
Output [23]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262))), 0, 1)), str_to_integer(str_if_with_rule((COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263 <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264), 0, 1)), str_to_integer(str_if_with_rule((COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265 <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266), 0, 1))))) AS COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_to_integer(str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) AS COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326, str_to_integer(str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) AS COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721]
Input [20]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922]

(11) Project [codegen id : 3]
Output [14]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, RIGHT, 2)) <=> str_extract(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, RIGHT, 2)) AND NOT (str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)) <=> )) AND NOT (str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> )) AND NOT (COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261 <=> COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263) <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> )) AND NOT (str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)) <=> )) AND (COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721 <=> 12)) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265) <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> )) AND NOT (str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)) <=> )) AND CASE WHEN isnull(COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326) THEN false ELSE (COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326 <= 31) END) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)))), 1, 0))))) AS COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771, dec_to_int(dec_operator(SOMME, array(COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399))) AS COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255]
Input [23]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326, COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721]

(12) Project [codegen id : 3]
Output [13]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_if_with_rule(((COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771 <=> 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0)), RD001@, ) AS COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619, str_if_with_rule(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0) AND (COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 1)), RD002@, ) AS COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620, str_if_with_rule((((COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND NOT (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR)) OR (NOT (COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR))), RD003@, ) AS COL_E989545D_EB28_4780_8678_8516E577F623#818621, str_if_with_rule(((COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 0) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 1)), RN001@, ) AS COL_CF21557A_4168_4725_901E_C283B950D1C9#818622, str_if_with_rule((CASE WHEN isnull(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2))) THEN false ELSE ((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2)) END AND ((COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390 <=> COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385) OR (COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392 <=> COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383))), RN002@, ) AS COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623, int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383), str_size(COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390))))) AS COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588, str_levenshtein(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390) AS COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216, str_extract(str_diff(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390), LEFT, 1) AS COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517]
Input [14]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771, COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255]

(13) Project [codegen id : 3]
Output [9]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382 AS COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389 AS COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619 AS COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620 AS COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, COL_E989545D_EB28_4780_8678_8516E577F623#818621 AS COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, COL_CF21557A_4168_4725_901E_C283B950D1C9#818622 AS COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623 AS COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, str_if_with_rule(((CASE WHEN isnull(((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2))) THEN false ELSE ((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2)) END AND CASE WHEN isnull(((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2))) THEN false ELSE ((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2)) END) AND NOT (str_remove_accent(upper(COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)), ) AS COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, str_if_with_rule((CASE WHEN isnull(((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2))) THEN false ELSE ((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2)) END AND NOT (COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386 <=> COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393)), RS001@, ) AS COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229]
Input [13]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619, COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620, COL_E989545D_EB28_4780_8678_8516E577F623#818621, COL_CF21557A_4168_4725_901E_C283B950D1C9#818622, COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623, COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588, COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216, COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517]

(14) Generate [codegen id : 3]
Input [9]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229]
Arguments: stack(9, RD001, COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, RD002, COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, RD003, COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, RN001, COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, RN002, COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, RN003, null, RN004, COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, RP001, null, RS001, COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229), [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670], false, [col0#825418, col1#825419]

(15) Filter [codegen id : 3]
Input [4]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, col0#825418, col1#825419]
Condition : NOT (str_remove_accent(upper(col1#825419)) <=> )

(16) Project [codegen id : 3]
Output [3]: [str_extract_by_str(col1#825419, @, LEFT) AS COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668 AS COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670 AS COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Input [4]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, col0#825418, col1#825419]

(17) Exchange
Input [3]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Arguments: hashpartitioning(COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, 10), ENSURE_REQUIREMENTS, [plan_id=113545]

(18) ShuffleQueryStage
Output [3]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Arguments: 0

(19) Sort
Input [3]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Arguments: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 ASC NULLS FIRST], false, 0

(20) Scan csv 
Output [4]: [Règles#790464, Libellé#790469, Priorité#790473, Catégorie#790475]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/3FD04C82_31D1_49CF_86B4_9E4AE0DD2CC5/current/Label-Règles.csv]
PushedFilters: [IsNotNull(Règles)]
ReadSchema: struct<Règles:string,Libellé:string,Priorité:string,Catégorie:string>

(21) Filter [codegen id : 4]
Input [4]: [Règles#790464, Libellé#790469, Priorité#790473, Catégorie#790475]
Condition : isnotnull(Règles#790464)

(22) Project [codegen id : 4]
Output [4]: [Catégorie#790475 AS THESREGLES_66145_CATEGORIE_66149#828024, Libellé#790469 AS THESREGLES_66145_LIBELLE_66147#828025, Priorité#790473 AS THESREGLES_66145_PRIORITE_66148#828026, Règles#790464 AS THESREGLES_66145_REGLES_66146#828027]
Input [4]: [Règles#790464, Libellé#790469, Priorité#790473, Catégorie#790475]

(23) Exchange
Input [4]: [THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]
Arguments: hashpartitioning(THESREGLES_66145_REGLES_66146#828027, 10), ENSURE_REQUIREMENTS, [plan_id=113586]

(24) ShuffleQueryStage
Output [4]: [THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]
Arguments: 1

(25) Sort
Input [4]: [THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]
Arguments: [THESREGLES_66145_REGLES_66146#828027 ASC NULLS FIRST], false, 0

(26) SortMergeJoin
Left keys [1]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832]
Right keys [1]: [THESREGLES_66145_REGLES_66146#828027]
Join type: LeftOuter
Join condition: None

(27) Project
Output [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, THESREGLES_66145_LIBELLE_66147#828025 AS COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, THESREGLES_66145_PRIORITE_66148#828026 AS COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, THESREGLES_66145_CATEGORIE_66149#828024 AS COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]

(28) Exchange
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: hashpartitioning(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 10), ENSURE_REQUIREMENTS, [plan_id=113599]

(29) Sort
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129 ASC NULLS FIRST, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(30) Window
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: [count(1) windowspecdefinition(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L], [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131], [1 DESC NULLS LAST]

(31) Filter
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353, COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L]
Condition : (COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L <=> 2)

(32) Project
Output [4]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 AS COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351 AS COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352 AS COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353 AS COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353, COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L]

(33) HashAggregate
Input [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Keys [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#850179L]
Results [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]

(34) Exchange
Input [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]
Arguments: hashpartitioning(COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, 10), ENSURE_REQUIREMENTS, [plan_id=113605]

(35) HashAggregate
Input [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]
Keys [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#831321L]
Results [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174 AS COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192 AS COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193 AS COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194 AS COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, count(1)#831321L AS COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]

(36) TakeOrderedAndProject
Input [5]: [COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]
Arguments: 500000, [COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L DESC NULLS LAST], [COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]

(37) Project
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887 AS COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_837B874F_9439_4F75_8914_1E97295E3979#790888 AS COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889 AS COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890 AS COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891 AS COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892 AS COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901 AS COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893 AS COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#790887, COL_837B874F_9439_4F75_8914_1E97295E3979#790888, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#790889, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#790890, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#790891, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#790892, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#790893, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#790901]

(38) Project
Output [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873 AS DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699, COL_837B874F_9439_4F75_8914_1E97295E3979#791874 AS DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875 AS DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876 AS DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877 AS DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878 AS DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879 AS DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887 AS DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713]
Input [8]: [COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791873, COL_837B874F_9439_4F75_8914_1E97295E3979#791874, COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791875, COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791876, COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791877, COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791878, COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791879, COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791887]

(39) CartesianProduct
Join type: Inner
Join condition: (((((CASE WHEN isnull(((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0))) THEN false ELSE ((dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) >= 1.0) AND (dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)))) <= 3.0)) END AND (str_to_integer(str_if_with_rule((COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 <=> DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699), 0, 1)) <=> 1)) AND (str_if_with_rule((str_remove_accent(upper(DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705)) <=> str_remove_accent(upper(COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565))), 1, 0) <=> 1)) AND NOT (str_remove_accent(upper(str_remove_space(str_concat(array(str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4), RIGHT, 2)) <=> str_extract(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4), RIGHT, 2)) AND NOT (str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))) <=> )) AND NOT (str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> )) AND NOT (str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) <=> str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))) <=> )) AND (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> 12)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7))))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> )) AND NOT (str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))) <=> )) AND CASE WHEN isnull(str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10)))) THEN false ELSE (str_to_integer(str_invers(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <= 31) END) AND NOT (str_remove_accent(upper(str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10))) <=> str_remove_accent(upper(str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10))))), 1, 0))))) <=> 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0)), RD001@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 1)), RD002@, ), str_if_with_rule((((DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND NOT (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR)) OR (NOT (DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 <=> @NR) AND (COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> @NR))), RD003@, ), str_if_with_rule(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4))) <=> str_remove_accent(upper(str_extract(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, LEFT, 4)))), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 5, 7)), 0, 1)), str_to_integer(str_if_with_rule((str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) <=> str_extract_by_index(DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, 8, 10)), 0, 1))))) <=> 0) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <=> 1)), RN001@, ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1))))) <= 2)) END AND ((DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 <=> COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561) OR (DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 <=> COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559))), RN002@, ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2))) THEN false ELSE ((str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) >= 1) AND (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561), str_size(DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))) <=> )), str_concat(array(RN003@, Vérifier le nom de naissance avant le caractère , str_extract(str_diff(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2))) THEN false ELSE ((str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) >= 1) AND (str_levenshtein(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) >= 1) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559), str_size(DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , str_extract(str_diff(COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), LEFT, 1))), ), str_if_with_rule(((CASE WHEN isnull(((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2))) THEN false ELSE ((str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) >= 1) AND (str_levenshtein(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701) <= 2)) END AND CASE WHEN isnull(((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2))) THEN false ELSE ((int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) >= 0) AND (int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560), str_size(DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701))))) <= 2)) END) AND NOT (str_remove_accent(upper(str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))) <=> )), str_concat(array(RP001@, Vérifer le prénom avant le caractère , str_extract(str_diff(COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), LEFT, 1))), ), str_if_with_rule((CASE WHEN isnull(((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2))) THEN false ELSE ((dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) >= 1) AND (dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)), str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)), str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)), str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)), str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1))))) <= 2)) END AND NOT (COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703)), RS001@, ))), ALL))) <=> )) AND CASE WHEN isnull(str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702)) THEN false ELSE (str_levenshtein(COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702) <= 2) END) AND CASE WHEN (isnull(COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564) OR isnull(DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713)) THEN false ELSE (COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564 >= DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713) END)

(40) Project
Output [15]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699 AS COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700 AS COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702 AS COL_EC933D6C_8084_4730_A30C_8DD484065385#794279, DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703 AS COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280, DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704 AS COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, str_to_integer(str_if_with_rule((COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 <=> DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703), 0, 1)) AS COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, str_to_integer(str_if_with_rule((COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 <=> DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700), 0, 1)) AS COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, str_to_integer(str_if_with_rule((COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 <=> DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702), 0, 1)) AS COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, str_to_integer(str_if_with_rule((COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560 <=> DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701), 0, 1)) AS COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, str_to_integer(str_if_with_rule((COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 <=> DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704), 0, 1)) AS COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288]
Input [16]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_2B791109_C7A8_4FFB_BAF0_F1CE0765902C#791560, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_DA0F4EF2_8D2C_4967_AABE_2CF3889225B5#791564, COL_03389300_1BD1_43D9_B2A1_53065CFAF1DE#791565, DATA_POPULATION_65578_COL_EDB04210_9ED8_4BD6_82C8_8464BF8F32CD#791699, DATA_POPULATION_65578_COL_837B874F_9439_4F75_8914_1E97295E3979#791700, DATA_POPULATION_65578_COL_EC4D3E53_5E15_49A6_8B3E_190EA41CFE52#791701, DATA_POPULATION_65578_COL_35D638BA_CDB3_4304_AD61_4B269A20ED47#791702, DATA_POPULATION_65578_COL_4A8C4FD9_928A_432E_A343_86F58F1512D8#791703, DATA_POPULATION_65578_COL_E89581AB_7ED5_4D49_83B2_E4F0BA5689C2#791704, DATA_POPULATION_65578_COL_DADE74F0_3BF0_4DB6_A9AA_A23397785307#791705, DATA_POPULATION_65578_COL_EB0163DA_0610_4529_A5C2_01A9C8621DAC#791713]

(41) Project
Output [20]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558 AS COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559 AS COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561 AS COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562 AS COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563 AS COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276 AS COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277 AS COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_EC933D6C_8084_4730_A30C_8DD484065385#794279 AS COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280 AS COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281 AS COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284 AS COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285 AS COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286 AS COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, str_extract(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, LEFT, 4) AS COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, str_extract(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, LEFT, 4) AS COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 5, 7) AS COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 5, 7) AS COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, str_extract_by_index(COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, 8, 10) AS COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, str_extract_by_index(COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, 8, 10) AS COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288))) AS COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922]
Input [15]: [COL_1378102E_5962_40BF_AED5_B06F6BED80E6#791558, COL_292A18CB_F486_4BC6_99A2_2A94F5CBF560#791559, COL_555D193D_A50D_4612_ADDF_597BF6DC9BEB#791561, COL_3BBEEA35_E661_48C3_8F21_098D5368BD44#791562, COL_744FBC3E_6F53_4D1E_A174_F1DE9F8232DA#791563, COL_AC9B7753_9740_41FB_B168_80616C1A9361#794276, COL_B759D373_A4B2_4D3E_B8F8_9EFC7438826B#794277, COL_EC933D6C_8084_4730_A30C_8DD484065385#794279, COL_82377FCD_F0EC_412F_9042_9F860CC4B886#794280, COL_784AA4D9_24D2_4F2A_AFAB_F6BCBBCC2AE4#794281, COL_21D217EA_1D69_4ED5_A0A4_D6AC196046F2#794283, COL_A5AD6F03_1165_4D2C_9478_E73EA76B7B13#794284, COL_92425C42_9863_40C3_BFB3_578EB43F8850#794285, COL_79FCFD47_99E5_43F7_9639_65CABA3431B2#794286, COL_E6AE5A8C_BA96_41A5_8413_E65C335117DB#794288]

(42) Project
Output [23]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule((str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262))), 0, 1)), str_to_integer(str_if_with_rule((COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263 <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264), 0, 1)), str_to_integer(str_if_with_rule((COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265 <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266), 0, 1))))) AS COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_to_integer(str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) AS COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326, str_to_integer(str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) AS COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721]
Input [20]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922]

(43) Project
Output [14]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, dec_to_int(dec_operator(SOMME, array(str_to_integer(str_if_with_rule(((((str_invers(str_extract(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, RIGHT, 2)) <=> str_extract(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, RIGHT, 2)) AND NOT (str_remove_accent(upper(COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)) <=> )) AND NOT (str_remove_accent(upper(COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261)) <=> )) AND NOT (COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261 <=> COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262)), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263) <=> COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> )) AND NOT (str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)) <=> )) AND (COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721 <=> 12)) AND NOT (str_remove_accent(upper(COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263)) <=> str_remove_accent(upper(COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264)))), 1, 0)), str_to_integer(str_if_with_rule((((((str_invers(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265) <=> COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> )) AND NOT (str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)) <=> )) AND CASE WHEN isnull(COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326) THEN false ELSE (COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326 <= 31) END) AND NOT (str_remove_accent(upper(COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265)) <=> str_remove_accent(upper(COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266)))), 1, 0))))) AS COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771, dec_to_int(dec_operator(SOMME, array(COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399))) AS COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255]
Input [23]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_A37AA89D_A294_4BE7_839F_76A86121D959#796397, COL_DC961926_0C38_48C7_8409_491AFEB6B1D2#796398, COL_AD8F7464_3412_4C72_8CE0_75573C602F6C#796399, COL_5CFEE2C7_2E84_4311_9125_79DE1E6BE5E7#799261, COL_53C30938_2F2E_4EF3_BC3A_8B7C8511BD55#799262, COL_DAA3E425_D108_401F_9C48_DCE50225FA0B#799263, COL_BC30D2BB_77B1_4D14_8842_3E7FFCDFB6A6#799264, COL_85EE0B93_20AA_4AF1_8900_7829A64BD3E4#799265, COL_B5E68717_B6D6_49BB_8327_ED49D55859FE#799266, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_CCFB0B2C_6D48_4BCF_8EDE_895CD117F204#801326, COL_81AE5821_6B19_4A4C_9DED_0036E35E9552#801721]

(44) Project
Output [13]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, str_if_with_rule(((COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771 <=> 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0)), RD001@, ) AS COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619, str_if_with_rule(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 0) AND (COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 1)), RD002@, ) AS COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620, str_if_with_rule((((COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND NOT (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR)) OR (NOT (COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394 <=> @NR) AND (COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387 <=> @NR))), RD003@, ) AS COL_E989545D_EB28_4780_8678_8516E577F623#818621, str_if_with_rule(((COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835 <=> 0) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <=> 1)), RN001@, ) AS COL_CF21557A_4168_4725_901E_C283B950D1C9#818622, str_if_with_rule((CASE WHEN isnull(((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2))) THEN false ELSE ((COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 >= 1) AND (COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255 <= 2)) END AND ((COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390 <=> COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385) OR (COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392 <=> COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383))), RN002@, ) AS COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623, int_abs(dec_to_int(dec_operator(DIFFERENCE, array(str_size(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383), str_size(COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390))))) AS COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588, str_levenshtein(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390) AS COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216, str_extract(str_diff(COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390), LEFT, 1) AS COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517]
Input [14]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_90D89BA8_72CA_469C_BE26_ED4CE43B74B0#796387, COL_1D5710A6_E714_4A6F_9730_2DE4D517D96A#796394, COL_D7C0F8B4_C3B6_45E2_958C_FE714869F4C3#802835, COL_334618A4_4C76_4E6F_9AE1_AC6C9B491BE4#796383, COL_E68BA945_9884_4B2C_A89B_7152FEB4B7FE#796390, COL_14631543_7D0A_4C42_A132_CDBC8EB50C90#796385, COL_26604CC5_2152_4C8C_87B7_0E30E6A256A5#796392, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_B4DD8CFC_486B_4EE7_96E5_57310CCA2F80#806771, COL_F2AC6CBB_A8C1_4E8B_8D03_04906764EB25#806255]

(45) Project
Output [9]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382 AS COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389 AS COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619 AS COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620 AS COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, COL_E989545D_EB28_4780_8678_8516E577F623#818621 AS COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, COL_CF21557A_4168_4725_901E_C283B950D1C9#818622 AS COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623 AS COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, str_if_with_rule(((CASE WHEN isnull(((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2))) THEN false ELSE ((COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 >= 1) AND (COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216 <= 2)) END AND CASE WHEN isnull(((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2))) THEN false ELSE ((COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 >= 1) AND (COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588 <= 2)) END) AND NOT (str_remove_accent(upper(COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)) <=> )), str_concat(array(RN004@, Vérifier le nom de famille avant le caractère , COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517)), ) AS COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, str_if_with_rule((CASE WHEN isnull(((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2))) THEN false ELSE ((COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 >= 1) AND (COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922 <= 2)) END AND NOT (COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386 <=> COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393)), RS001@, ) AS COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229]
Input [13]: [COL_8FAFFC16_E402_4875_870C_69EF0FDB2B20#796382, COL_0D461B1D_9B52_4A46_8214_A5552BDEA242#796389, COL_7570EE58_34FB_44F5_906B_BCB725B196CC#796386, COL_686DD3B1_DBF7_4248_84A2_59DA3D88E86E#796393, COL_F8988D87_9B48_41F9_9ED8_6F8083D07DF6#796922, COL_E138A5B1_417E_4502_BA9B_D1231E4EC638#818619, COL_8C4F9A39_EA7F_44C3_8DF6_C701BCFD88ED#818620, COL_E989545D_EB28_4780_8678_8516E577F623#818621, COL_CF21557A_4168_4725_901E_C283B950D1C9#818622, COL_4BA38A9E_5461_4D42_BAC7_183634500A45#818623, COL_372EED3C_10FD_464B_92B5_0B19C4A7D373#815588, COL_34130B26_042C_4252_BAB4_D7C814F34D99#816216, COL_E89234B2_F04F_444F_80E2_74B5C67A4CE1#817517]

(46) Generate
Input [9]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229]
Arguments: stack(9, RD001, COL_41F6AF78_5BA7_4F07_9192_5753D2E6C17F#824694, RD002, COL_4B4D0450_DE7C_4073_9395_A342497146C0#824695, RD003, COL_2062C2F5_A146_4D4C_9A72_66753514AD2D#824696, RN001, COL_64C3EEA4_70B9_4535_90B8_706F5328EC12#824697, RN002, COL_0DB01DF9_2902_46F3_B0A7_3276520858F1#824698, RN003, null, RN004, COL_718D8C65_EE30_4D81_B393_4F5CDE026898#824700, RP001, null, RS001, COL_F806DF71_0102_4F32_96E0_85F01BD55FD0#824229), [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670], false, [col0#825418, col1#825419]

(47) Filter
Input [4]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, col0#825418, col1#825419]
Condition : NOT (str_remove_accent(upper(col1#825419)) <=> )

(48) Project
Output [3]: [str_extract_by_str(col1#825419, @, LEFT) AS COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668 AS COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670 AS COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Input [4]: [COL_7DC704B7_C146_45D0_B093_5A473A8997AF#824668, COL_F4C74940_0758_445B_BE96_7A206FE10C80#824670, col0#825418, col1#825419]

(49) Exchange
Input [3]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Arguments: hashpartitioning(COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, 10), ENSURE_REQUIREMENTS, [plan_id=113436]

(50) Sort
Input [3]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131]
Arguments: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 ASC NULLS FIRST], false, 0

(51) Filter
Input [4]: [Règles#790464, Libellé#790469, Priorité#790473, Catégorie#790475]
Condition : isnotnull(Règles#790464)

(52) Project
Output [4]: [Catégorie#790475 AS THESREGLES_66145_CATEGORIE_66149#828024, Libellé#790469 AS THESREGLES_66145_LIBELLE_66147#828025, Priorité#790473 AS THESREGLES_66145_PRIORITE_66148#828026, Règles#790464 AS THESREGLES_66145_REGLES_66146#828027]
Input [4]: [Règles#790464, Libellé#790469, Priorité#790473, Catégorie#790475]

(53) Exchange
Input [4]: [THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]
Arguments: hashpartitioning(THESREGLES_66145_REGLES_66146#828027, 10), ENSURE_REQUIREMENTS, [plan_id=113437]

(54) Sort
Input [4]: [THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]
Arguments: [THESREGLES_66145_REGLES_66146#828027 ASC NULLS FIRST], false, 0

(55) SortMergeJoin
Left keys [1]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832]
Right keys [1]: [THESREGLES_66145_REGLES_66146#828027]
Join type: LeftOuter
Join condition: None

(56) Project
Output [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, THESREGLES_66145_LIBELLE_66147#828025 AS COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, THESREGLES_66145_PRIORITE_66148#828026 AS COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, THESREGLES_66145_CATEGORIE_66149#828024 AS COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, THESREGLES_66145_CATEGORIE_66149#828024, THESREGLES_66145_LIBELLE_66147#828025, THESREGLES_66145_PRIORITE_66148#828026, THESREGLES_66145_REGLES_66146#828027]

(57) Exchange
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: hashpartitioning(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 10), ENSURE_REQUIREMENTS, [plan_id=113443]

(58) Sort
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129 ASC NULLS FIRST, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(59) Window
Input [6]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353]
Arguments: [count(1) windowspecdefinition(COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L], [COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131], [1 DESC NULLS LAST]

(60) Filter
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353, COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L]
Condition : (COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L <=> 2)

(61) Project
Output [4]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832 AS COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351 AS COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352 AS COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353 AS COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Input [7]: [COL_58FE2B8E_3473_4243_9084_320967210AE2#827832, COL_7160963C_CCAC_4482_B1E5_74EF30DE75F0#825129, COL_CEBD7F98_3B92_49EC_AF99_419425CA23E4#825131, COL_5E1F2AD3_A4D5_4945_AF8A_1CE7B7294F2C#829351, COL_4DD05636_E67B_47AB_BF36_F713EBD2352B#829352, COL_9C17FFED_0BD2_497E_AA58_71F1D7AC929D#829353, COL_C8FDF99F_0ACF_4E19_8CBC_5FB7D1EFD17B#829633L]

(62) HashAggregate
Input [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Keys [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#850179L]
Results [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]

(63) Exchange
Input [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]
Arguments: hashpartitioning(COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, 10), ENSURE_REQUIREMENTS, [plan_id=113450]

(64) HashAggregate
Input [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194, count#850180L]
Keys [4]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#831321L]
Results [5]: [COL_82F4AD52_4B06_479D_B5B6_E241EC4C8368#831174 AS COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_E0DDD7E8_7B38_42B0_A224_C73A67F94FA6#831192 AS COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_30E091C7_11AC_41DC_AADF_6EC0B1225D4A#831193 AS COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_E9A15AF4_1EDF_42F7_9DEF_C3286ADF2A91#831194 AS COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, count(1)#831321L AS COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]

(65) TakeOrderedAndProject
Input [5]: [COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]
Arguments: 500000, [COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L DESC NULLS LAST], [COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]

(66) AdaptiveSparkPlan
Output [5]: [COL_C4C0C886_C08C_410C_8B8E_FCB983D198E1#831294, COL_5D2C5277_9CA8_4F82_8919_65D39B76ED57#831295, COL_1A9F6D81_145E_41D9_9B4A_0E3ACC177312#831296, COL_77BB23C8_2C1C_4404_A93A_412B6899B6B5#831297, COL_C89F6217_5728_4BEA_87AD_B01AD738E572#831323L]
Arguments: isFinalPlan=false

SQL / DataFrame Properties

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