== Physical Plan ==
AdaptiveSparkPlan (64)
+- == Final Plan ==
CollectLimit (39)
+- * Project (38)
+- * Filter (37)
+- * SortMergeJoin LeftOuter (36)
:- * Sort (23)
: +- AQEShuffleRead (22)
: +- ShuffleQueryStage (21), Statistics(sizeInBytes=1166.6 KiB, rowCount=1.46E+3)
: +- Exchange (20)
: +- * Project (19)
: +- * Project (18)
: +- * SortMergeJoin LeftOuter (17)
: :- * Sort (7)
: : +- AQEShuffleRead (6)
: : +- ShuffleQueryStage (5), Statistics(sizeInBytes=720.5 KiB, rowCount=1.46E+3)
: : +- Exchange (4)
: : +- * Project (3)
: : +- * ColumnarToRow (2)
: : +- Scan parquet (1)
: +- * Sort (16)
: +- AQEShuffleRead (15)
: +- ShuffleQueryStage (14), Statistics(sizeInBytes=210.0 KiB, rowCount=1.10E+3)
: +- Exchange (13)
: +- * Project (12)
: +- * Project (11)
: +- * Filter (10)
: +- * ColumnarToRow (9)
: +- Scan parquet (8)
+- * Sort (35)
+- AQEShuffleRead (34)
+- ShuffleQueryStage (33), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
+- Exchange (32)
+- * HashAggregate (31)
+- AQEShuffleRead (30)
+- ShuffleQueryStage (29), Statistics(sizeInBytes=97.0 KiB, rowCount=1.00E+3)
+- Exchange (28)
+- * HashAggregate (27)
+- * Project (26)
+- * Filter (25)
+- Scan csv (24)
+- == Initial Plan ==
CollectLimit (63)
+- Project (62)
+- Filter (61)
+- SortMergeJoin LeftOuter (60)
:- Sort (52)
: +- Exchange (51)
: +- Project (50)
: +- Project (49)
: +- SortMergeJoin LeftOuter (48)
: :- Sort (42)
: : +- Exchange (41)
: : +- Project (40)
: : +- Scan parquet (1)
: +- Sort (47)
: +- Exchange (46)
: +- Project (45)
: +- Project (44)
: +- Filter (43)
: +- Scan parquet (8)
+- Sort (59)
+- Exchange (58)
+- HashAggregate (57)
+- Exchange (56)
+- HashAggregate (55)
+- Project (54)
+- Filter (53)
+- Scan csv (24)
(1) Scan parquet
Output [24]: [Proprietaire#80218, idMandat#80219, Code+immeuble#80220, Nom+Immeuble#80221, Adresse+Immeuble#80222, Code+Postal+Immeuble#80223, Ville+Immeuble#80224, Etage#80225, idLot#80226, N%C2%B0+Identifiant+Fiscal#80227, Numero+lot+syndic#80228, TypeLot#80229, Porte#80230, Surface#80231, NomLocataire#80232, DepotGar+%28euro%29#80233, Loyer%2Fan+%28euro%29#80234, Prov.+sur+charges%2Fan+%28euro%29#80235, idBail#80236, DPE#80237, GES#80238, Classe+Commune#80239, Classe+DPE#80240, Classe+GES#80241]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/C475E2AA_35EA_48B3_8BCD_DEA3CE02A605_b3d3c08a1f8d703e76a5dcfb9ccd2460/Patrimoine_au_20-4-2026_corrige_Laneco.xlsx_d2ddcf90463fc652b910349ac81c7390]
ReadSchema: struct<Proprietaire:string,idMandat:string,Code+immeuble:string,Nom+Immeuble:string,Adresse+Immeuble:string,Code+Postal+Immeuble:string,Ville+Immeuble:string,Etage:string,idLot:string,N%C2%B0+Identifiant+Fiscal:string,Numero+lot+syndic:string,TypeLot:string,Porte:string,Surface:string,NomLocataire:string,DepotGar+%28euro%29:string,Loyer%2Fan+%28euro%29:string,Prov.+sur+charges%2Fan+%28euro%29:string,idBail:string,DPE:string,GES:string,Classe+Commune:string,Classe+DPE:string,Classe+GES:string>
(2) ColumnarToRow [codegen id : 1]
Input [24]: [Proprietaire#80218, idMandat#80219, Code+immeuble#80220, Nom+Immeuble#80221, Adresse+Immeuble#80222, Code+Postal+Immeuble#80223, Ville+Immeuble#80224, Etage#80225, idLot#80226, N%C2%B0+Identifiant+Fiscal#80227, Numero+lot+syndic#80228, TypeLot#80229, Porte#80230, Surface#80231, NomLocataire#80232, DepotGar+%28euro%29#80233, Loyer%2Fan+%28euro%29#80234, Prov.+sur+charges%2Fan+%28euro%29#80235, idBail#80236, DPE#80237, GES#80238, Classe+Commune#80239, Classe+DPE#80240, Classe+GES#80241]
(3) Project [codegen id : 1]
Output [27]: [Proprietaire#80218 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, idMandat#80219 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, Code+immeuble#80220 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, Nom+Immeuble#80221 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, Adresse+Immeuble#80222 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, Code+Postal+Immeuble#80223 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, Ville+Immeuble#80224 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, Etage#80225 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, idLot#80226 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, N%C2%B0+Identifiant+Fiscal#80227 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, Numero+lot+syndic#80228 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, TypeLot#80229 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, Porte#80230 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, Surface#80231 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, NomLocataire#80232 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, DepotGar+%28euro%29#80233 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, Loyer%2Fan+%28euro%29#80234 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, Prov.+sur+charges%2Fan+%28euro%29#80235 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, idBail#80236 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, DPE#80237 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, GES#80238 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, Classe+Commune#80239 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, Classe+DPE#80240 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, Classe+GES#80241 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, str_extract(Code+Postal+Immeuble#80223, LEFT, 2) AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#80218, UPPER)), ONLY_ONE) AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#80224, [ST ,ST-], [SAINT ,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [24]: [Proprietaire#80218, idMandat#80219, Code+immeuble#80220, Nom+Immeuble#80221, Adresse+Immeuble#80222, Code+Postal+Immeuble#80223, Ville+Immeuble#80224, Etage#80225, idLot#80226, N%C2%B0+Identifiant+Fiscal#80227, Numero+lot+syndic#80228, TypeLot#80229, Porte#80230, Surface#80231, NomLocataire#80232, DepotGar+%28euro%29#80233, Loyer%2Fan+%28euro%29#80234, Prov.+sur+charges%2Fan+%28euro%29#80235, idBail#80236, DPE#80237, GES#80238, Classe+Commune#80239, Classe+DPE#80240, Classe+GES#80241]
(4) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, 10), ENSURE_REQUIREMENTS, [plan_id=13214]
(5) ShuffleQueryStage
Output [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: 0
(6) AQEShuffleRead
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: coalesced
(7) Sort [codegen id : 4]
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507 ASC NULLS FIRST], false, 0
(8) Scan parquet
Output [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/1210D38A_30A1_417E_AC30_A633AB773A43_79471ac0595e0f84c440113d58d8281c/PROPRIETAIRES_Laneco_Base.xls_afce3e2f319a0b3bd204c24dc83c5faa]
PushedFilters: [IsNotNull(`Id+Mandat`)]
ReadSchema: struct<Portefeuille:string,Civilit%C3%A9:string,Nom:string,Id+Mandat:string,N%C2%B0+Registre:string,Taux+Honoraire:string>
(9) ColumnarToRow [codegen id : 2]
Input [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
(10) Filter [codegen id : 2]
Input [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
Condition : isnotnull(Id+Mandat#82046)
(11) Project [codegen id : 2]
Output [9]: [Portefeuille#82043 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, Civilit%C3%A9#82044 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Nom#82045 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, Id+Mandat#82046 AS COL_84669589_3EDF_4867_8128_B2F334719709#82274, N%C2%B0+Registre#82047 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, Taux+Honoraire#82048 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#82048, - 0)) THEN false ELSE Contains(Taux+Honoraire#82048, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#82044, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#82044, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#82044, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#82044, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#82044, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#82044, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#82044, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#82044, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, str_remove_space(str_remove_accent(str_transform_case(Nom#82045, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300]
Input [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
(12) Project [codegen id : 2]
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, COL_84669589_3EDF_4867_8128_B2F334719709#82274 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300]
(13) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, 10), ENSURE_REQUIREMENTS, [plan_id=13235]
(14) ShuffleQueryStage
Output [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: 1
(15) AQEShuffleRead
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: coalesced
(16) Sort [codegen id : 5]
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573 ASC NULLS FIRST], false, 0
(17) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573]
Join type: LeftOuter
Join condition: None
(18) Project [codegen id : 6]
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
(19) Project [codegen id : 6]
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898), )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507), ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512), ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898]
(20) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, 10), ENSURE_REQUIREMENTS, [plan_id=13413]
(21) ShuffleQueryStage
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: 3
(22) AQEShuffleRead
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: coalesced
(23) Sort [codegen id : 8]
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188 ASC NULLS FIRST], false, 0
(24) Scan csv
Output [3]: [Adresse-Source#81441, longitude#81443, latitude#81444]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/359356B1_1158_424C_96CE_4656C0BF7CAB/current/Adresses_geocodees_(1).csv]
PushedFilters: [IsNotNull(longitude)]
ReadSchema: struct<Adresse-Source:string,longitude:string,latitude:string>
(25) Filter [codegen id : 3]
Input [3]: [Adresse-Source#81441, longitude#81443, latitude#81444]
Condition : (isnotnull(longitude#81443) AND isnotnull(str_remove_space(Adresse-Source#81441, ONLY_ONE)))
(26) Project [codegen id : 3]
Output [3]: [str_remove_space(Adresse-Source#81441, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, longitude#81443 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, latitude#81444 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Input [3]: [Adresse-Source#81441, longitude#81443, latitude#81444]
(27) HashAggregate [codegen id : 3]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
(28) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953, 10), ENSURE_REQUIREMENTS, [plan_id=13272]
(29) ShuffleQueryStage
Output [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Arguments: 2
(30) AQEShuffleRead
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Arguments: coalesced
(31) HashAggregate [codegen id : 7]
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
(32) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, 10), ENSURE_REQUIREMENTS, [plan_id=13469]
(33) ShuffleQueryStage
Output [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: 4
(34) AQEShuffleRead
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: coalesced
(35) Sort [codegen id : 9]
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235 ASC NULLS FIRST], false, 0
(36) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235]
Join type: LeftOuter
Join condition: None
(37) Filter [codegen id : 10]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506)), MAIS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532)), MAIS) END)
(38) Project [codegen id : 10]
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236 AS COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#83418, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237 AS COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#83419, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
(39) CollectLimit
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#83418, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#83419, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: 1500
(40) Project
Output [27]: [Proprietaire#80218 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, idMandat#80219 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, Code+immeuble#80220 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, Nom+Immeuble#80221 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, Adresse+Immeuble#80222 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, Code+Postal+Immeuble#80223 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, Ville+Immeuble#80224 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, Etage#80225 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, idLot#80226 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, N%C2%B0+Identifiant+Fiscal#80227 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, Numero+lot+syndic#80228 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, TypeLot#80229 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, Porte#80230 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, Surface#80231 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, NomLocataire#80232 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, DepotGar+%28euro%29#80233 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, Loyer%2Fan+%28euro%29#80234 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, Prov.+sur+charges%2Fan+%28euro%29#80235 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, idBail#80236 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, DPE#80237 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, GES#80238 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, Classe+Commune#80239 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, Classe+DPE#80240 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, Classe+GES#80241 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, str_extract(Code+Postal+Immeuble#80223, LEFT, 2) AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#80218, UPPER)), ONLY_ONE) AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#80224, [ST ,ST-], [SAINT ,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [24]: [Proprietaire#80218, idMandat#80219, Code+immeuble#80220, Nom+Immeuble#80221, Adresse+Immeuble#80222, Code+Postal+Immeuble#80223, Ville+Immeuble#80224, Etage#80225, idLot#80226, N%C2%B0+Identifiant+Fiscal#80227, Numero+lot+syndic#80228, TypeLot#80229, Porte#80230, Surface#80231, NomLocataire#80232, DepotGar+%28euro%29#80233, Loyer%2Fan+%28euro%29#80234, Prov.+sur+charges%2Fan+%28euro%29#80235, idBail#80236, DPE#80237, GES#80238, Classe+Commune#80239, Classe+DPE#80240, Classe+GES#80241]
(41) Exchange
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: hashpartitioning(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, 10), ENSURE_REQUIREMENTS, [plan_id=13160]
(42) Sort
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507 ASC NULLS FIRST], false, 0
(43) Filter
Input [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
Condition : isnotnull(Id+Mandat#82046)
(44) Project
Output [9]: [Portefeuille#82043 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, Civilit%C3%A9#82044 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Nom#82045 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, Id+Mandat#82046 AS COL_84669589_3EDF_4867_8128_B2F334719709#82274, N%C2%B0+Registre#82047 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, Taux+Honoraire#82048 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, str_if_with_rule(CASE WHEN isnull(Contains(Taux+Honoraire#82048, - 0)) THEN false ELSE Contains(Taux+Honoraire#82048, - 0) END, Absence Taux, ) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(Civilit%C3%A9#82044, Madame, equal, [Madame], [], true, MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Monsieur, equal, [MONSIEUR], [], true, MR, , null), RANKING_STRING(Civilit%C3%A9#82044, M et Mme, equal, [M ET MME], [], true, M_ET_MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Succession, equal, [Succession], [], true, SUCCESSION, , null), RANKING_STRING(Civilit%C3%A9#82044, Ind., equal, [IND.], [], true, IND., , null), RANKING_STRING(Civilit%C3%A9#82044, Consorts, equal, [CONSORTS], [], true, CONSORT, , null), RANKING_STRING(Civilit%C3%A9#82044, SCI, equal, [SCI], [], true, SCI, , null), RANKING_STRING(Civilit%C3%A9#82044, SARL, equal, [SARL], [], true, SARL, , null), RANKING_STRING(Civilit%C3%A9#82044, Indivision, equal, [INDIVISION], [], true, INDIVISION, , null), RANKING_STRING(Civilit%C3%A9#82044, M ou Mme, equal, [M OU MME], [], true, M_OU_MME, , null), RANKING_STRING(Civilit%C3%A9#82044, Messieurs, equal, [MESSIEURS], [], true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, str_remove_space(str_remove_accent(str_transform_case(Nom#82045, UPPER)), ONLY_ONE) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300]
Input [6]: [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048]
(45) Project
Output [10]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271 AS PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272 AS PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273 AS PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, COL_84669589_3EDF_4867_8128_B2F334719709#82274 AS PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275 AS PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276 AS PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283 AS PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291 AS PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300 AS PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300), ) AS PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Input [9]: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300]
(46) Exchange
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: hashpartitioning(PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, 10), ENSURE_REQUIREMENTS, [plan_id=13161]
(47) Sort
Input [10]: [PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
Arguments: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573 ASC NULLS FIRST], false, 0
(48) SortMergeJoin
Left keys [1]: [COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507]
Right keys [1]: [PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573]
Join type: LeftOuter
Join condition: None
(49) Project
Output [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570 AS COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571 AS COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572 AS COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573 AS COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574 AS COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575 AS COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576 AS COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577 AS COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578 AS COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579 AS COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579)) THEN false ELSE StartsWith(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579) END, 1, 0) AS COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, str_diff(PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531) AS COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898]
Input [37]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, PROPRIETAIRES_L_405142_COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82570, PROPRIETAIRES_L_405142_COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82571, PROPRIETAIRES_L_405142_COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82572, PROPRIETAIRES_L_405142_COL_84669589_3EDF_4867_8128_B2F334719709#82573, PROPRIETAIRES_L_405142_COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82574, PROPRIETAIRES_L_405142_COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82575, PROPRIETAIRES_L_405142_COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82576, PROPRIETAIRES_L_405142_COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82577, PROPRIETAIRES_L_405142_COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82578, PROPRIETAIRES_L_405142_COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82579]
(50) Project
Output [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, str_if_with_rule((COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898 <=> ), Matching Total, str_join(array(Différence sur, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898), )) AS COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, str_if_with_rule(isnull(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813), str_join(array(Absence de Propriétaire pour le Mandat , COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507), ), ) AS COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, str_remove_space(str_join(array(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512), ), ONLY_ONE) AS COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [39]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898]
(51) Exchange
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: hashpartitioning(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, 10), ENSURE_REQUIREMENTS, [plan_id=13173]
(52) Sort
Input [42]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188 ASC NULLS FIRST], false, 0
(53) Filter
Input [3]: [Adresse-Source#81441, longitude#81443, latitude#81444]
Condition : (isnotnull(longitude#81443) AND isnotnull(str_remove_space(Adresse-Source#81441, ONLY_ONE)))
(54) Project
Output [3]: [str_remove_space(Adresse-Source#81441, ONLY_ONE) AS COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, longitude#81443 AS COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, latitude#81444 AS COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Input [3]: [Adresse-Source#81441, longitude#81443, latitude#81444]
(55) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
(56) Exchange
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Arguments: hashpartitioning(COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953, 10), ENSURE_REQUIREMENTS, [plan_id=13167]
(57) HashAggregate
Input [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Keys [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_D8B94028_68BB_44EE_8594_3D4C85313BF6#81950 AS GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, COL_68C7380E_A06B_4E73_B822_4A6D7405F431#81952 AS GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, COL_BEE0BDD5_CFA3_4EBE_B374_E38C94FA85FC#81953 AS GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
(58) Exchange
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: hashpartitioning(GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, 10), ENSURE_REQUIREMENTS, [plan_id=13174]
(59) Sort
Input [3]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Arguments: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235 ASC NULLS FIRST], false, 0
(60) SortMergeJoin
Left keys [1]: [COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188]
Right keys [1]: [GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235]
Join type: LeftOuter
Join condition: None
(61) Filter
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506)), MAIS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237)), MAIS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532)), MAIS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532)), MAIS) END)
(62) Project
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236 AS COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#83418, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237 AS COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#83419, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Input [45]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532, GEOCODAGE_ADRES_405357_COL_A3E44F2E_A7EB_4429_938D_3141121BC654#83235, GEOCODAGE_ADRES_405357_COL_6C3B3822_9A93_4208_AA86_A8C490BB075B#83236, GEOCODAGE_ADRES_405357_COL_7CCAED06_3D4A_401F_B221_D9D3E412AE75#83237]
(63) CollectLimit
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#83418, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#83419, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: 1500
(64) AdaptiveSparkPlan
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#82506, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#82507, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#82508, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#82509, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#82510, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#82511, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#82512, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#82530, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#82513, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#82514, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#82515, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#82516, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#82517, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#82518, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#82519, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#82520, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#82521, COL_0DB61D05_5348_40DB_8F16_C7916849A669#82522, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#82523, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#82524, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#82525, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#82526, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#82527, COL_33CEA792_75B9_44A1_896B_B422BD28B923#82528, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#82529, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#82810, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#82811, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#82812, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#82813, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#82814, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#82815, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#82816, COL_924860D6_14C4_4F33_B84C_E428E89E2817#82817, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#82818, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#82819, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#82531, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#82859, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#82898, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#83186, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#83187, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#83188, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#83418, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#83419, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#82532]
Arguments: isFinalPlan=true