SP1 - Details for Query 483

Submitted Time: 2026/06/25 16:33:12
Duration: 0.2 s
Succeeded Jobs: 665

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 117 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 1"]; 5 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 6 [labelType="html" label="Scan parquet number of files read: 1 scan time: 5 ms metadata time: 0 ms size of files read: 148.0 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; 5->4; 6->5; }

CollectLimit 1500

Project [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, COL_A06CD743_975B_480F_890C_78685E530CD1#213023, COL_814180A7_65B9_4C68_A945_79F72A870824#213024, COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, ... 4 more fields]

Project [Proprietaire#212011 AS COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, idMandat#212012 AS COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, Code+immeuble#212013 AS COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, Nom+Immeuble#212014 AS COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, Adresse+Immeuble#212015 AS COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, Code+Postal+Immeuble#212016 AS COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, Ville+Immeuble#212017 AS COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, Etage#212018 AS COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, idLot#212019 AS COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, N%C2%B0+Identifiant+Fiscal#212020 AS COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, Numero+lot+syndic#212021 AS COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, TypeLot#212022 AS COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, Porte#212023 AS COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, Surface#212024 AS COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, NomLocataire#212025 AS COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, DepotGar+%28euro%29#212026 AS COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, Loyer%2Fan+%28euro%29#212027 AS COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, Prov.+sur+charges%2Fan+%28euro%29#212028 AS COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, idBail#212029 AS COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, DPE#212030 AS COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, GES#212031 AS COL_A06CD743_975B_480F_890C_78685E530CD1#213023, Classe+Commune#212032 AS COL_814180A7_65B9_4C68_A945_79F72A870824#213024, Classe+DPE#212033 AS COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, Classe+GES#212034 AS COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, ... 3 more fields]

Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#212011)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Proprietaire#212011)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(idMandat#212012)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idMandat#212012)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+immeuble#212013)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Code+immeuble#212013)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom+Immeuble#212014)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Nom+Immeuble#212014)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Adresse+Immeuble#212015)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Adresse+Immeuble#212015)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+Postal+Immeuble#212016)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Code+Postal+Immeuble#212016)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Ville+Immeuble#212017)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Ville+Immeuble#212017)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Etage#212018)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Etage#212018)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idLot#212019)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idLot#212019)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#212020)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#212020)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Numero+lot+syndic#212021)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Numero+lot+syndic#212021)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TypeLot#212022)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(TypeLot#212022)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Porte#212023)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Porte#212023)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Surface#212024)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Surface#212024)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NomLocataire#212025)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(NomLocataire#212025)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DepotGar+%28euro%29#212026)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(DepotGar+%28euro%29#212026)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#212027)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#212027)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#212028)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#212028)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idBail#212029)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idBail#212029)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DPE#212030)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(DPE#212030)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GES#212031)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(GES#212031)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+Commune#212032)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+Commune#212032)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+DPE#212033)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+DPE#212033)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+GES#212034)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+GES#212034)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#212016, LEFT, 2))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#212016, LEFT, 2))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#212011, UPPER)), ONLY_ONE))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#212011, UPPER)), ONLY_ONE))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]), [- ,MAISOSNS], [-,MAISONS]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]), [- ,MAISOSNS], [-,MAISONS]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]))), MAISOSNS) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [Proprietaire#212011,idMandat#212012,Code+immeuble#212013,Nom+Immeuble#212014,Adresse+Immeuble#212015,Code+Postal+Immeuble#212016,Ville+Immeuble#212017,Etage#212018,idLot#212019,N%C2%B0+Identifiant+Fiscal#212020,Numero+lot+syndic#212021,TypeLot#212022,Porte#212023,Surface#212024,NomLocataire#212025,DepotGar+%28euro%29#212026,Loyer%2Fan+%28euro%29#212027,Prov.+sur+charges%2Fan+%28euro%29#212028,idBail#212029,DPE#212030,GES#212031,Classe+Commune#212032,Classe+DPE#212033,Classe+GES#212034] Batched: true, DataFilters: [(((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#212011..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/C475E2AA_35EA_48B3_8BCD_DEA3CE02A60..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Proprietaire:string,idMandat:string,Code+immeuble:string,Nom+Immeuble:string,Adresse+Immeu...

Details

== Physical Plan ==
CollectLimit (6)
+- * Project (5)
   +- * Project (4)
      +- * Filter (3)
         +- * ColumnarToRow (2)
            +- Scan parquet  (1)


(1) Scan parquet 
Output [24]: [Proprietaire#212011, idMandat#212012, Code+immeuble#212013, Nom+Immeuble#212014, Adresse+Immeuble#212015, Code+Postal+Immeuble#212016, Ville+Immeuble#212017, Etage#212018, idLot#212019, N%C2%B0+Identifiant+Fiscal#212020, Numero+lot+syndic#212021, TypeLot#212022, Porte#212023, Surface#212024, NomLocataire#212025, DepotGar+%28euro%29#212026, Loyer%2Fan+%28euro%29#212027, Prov.+sur+charges%2Fan+%28euro%29#212028, idBail#212029, DPE#212030, GES#212031, Classe+Commune#212032, Classe+DPE#212033, Classe+GES#212034]
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#212011, idMandat#212012, Code+immeuble#212013, Nom+Immeuble#212014, Adresse+Immeuble#212015, Code+Postal+Immeuble#212016, Ville+Immeuble#212017, Etage#212018, idLot#212019, N%C2%B0+Identifiant+Fiscal#212020, Numero+lot+syndic#212021, TypeLot#212022, Porte#212023, Surface#212024, NomLocataire#212025, DepotGar+%28euro%29#212026, Loyer%2Fan+%28euro%29#212027, Prov.+sur+charges%2Fan+%28euro%29#212028, idBail#212029, DPE#212030, GES#212031, Classe+Commune#212032, Classe+DPE#212033, Classe+GES#212034]

(3) Filter [codegen id : 1]
Input [24]: [Proprietaire#212011, idMandat#212012, Code+immeuble#212013, Nom+Immeuble#212014, Adresse+Immeuble#212015, Code+Postal+Immeuble#212016, Ville+Immeuble#212017, Etage#212018, idLot#212019, N%C2%B0+Identifiant+Fiscal#212020, Numero+lot+syndic#212021, TypeLot#212022, Porte#212023, Surface#212024, NomLocataire#212025, DepotGar+%28euro%29#212026, Loyer%2Fan+%28euro%29#212027, Prov.+sur+charges%2Fan+%28euro%29#212028, idBail#212029, DPE#212030, GES#212031, Classe+Commune#212032, Classe+DPE#212033, Classe+GES#212034]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#212011)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Proprietaire#212011)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(idMandat#212012)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idMandat#212012)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+immeuble#212013)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Code+immeuble#212013)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom+Immeuble#212014)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Nom+Immeuble#212014)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Adresse+Immeuble#212015)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Adresse+Immeuble#212015)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+Postal+Immeuble#212016)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Code+Postal+Immeuble#212016)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Ville+Immeuble#212017)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Ville+Immeuble#212017)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Etage#212018)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Etage#212018)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idLot#212019)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idLot#212019)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#212020)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#212020)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Numero+lot+syndic#212021)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Numero+lot+syndic#212021)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TypeLot#212022)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(TypeLot#212022)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Porte#212023)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Porte#212023)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Surface#212024)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Surface#212024)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NomLocataire#212025)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(NomLocataire#212025)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DepotGar+%28euro%29#212026)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(DepotGar+%28euro%29#212026)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#212027)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#212027)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#212028)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#212028)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idBail#212029)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(idBail#212029)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DPE#212030)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(DPE#212030)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GES#212031)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(GES#212031)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+Commune#212032)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+Commune#212032)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+DPE#212033)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+DPE#212033)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+GES#212034)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(Classe+GES#212034)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#212016, LEFT, 2))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#212016, LEFT, 2))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#212011, UPPER)), ONLY_ONE))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#212011, UPPER)), ONLY_ONE))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]), [- ,MAISOSNS], [-,MAISONS]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]), [- ,MAISOSNS], [-,MAISONS]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]))), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]))), MAISOSNS) END)

(4) Project [codegen id : 1]
Output [27]: [Proprietaire#212011 AS COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, idMandat#212012 AS COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, Code+immeuble#212013 AS COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, Nom+Immeuble#212014 AS COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, Adresse+Immeuble#212015 AS COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, Code+Postal+Immeuble#212016 AS COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, Ville+Immeuble#212017 AS COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, Etage#212018 AS COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, idLot#212019 AS COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, N%C2%B0+Identifiant+Fiscal#212020 AS COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, Numero+lot+syndic#212021 AS COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, TypeLot#212022 AS COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, Porte#212023 AS COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, Surface#212024 AS COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, NomLocataire#212025 AS COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, DepotGar+%28euro%29#212026 AS COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, Loyer%2Fan+%28euro%29#212027 AS COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, Prov.+sur+charges%2Fan+%28euro%29#212028 AS COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, idBail#212029 AS COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, DPE#212030 AS COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, GES#212031 AS COL_A06CD743_975B_480F_890C_78685E530CD1#213023, Classe+Commune#212032 AS COL_814180A7_65B9_4C68_A945_79F72A870824#213024, Classe+DPE#212033 AS COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, Classe+GES#212034 AS COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, str_extract(Code+Postal+Immeuble#212016, LEFT, 2) AS COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#213051, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#212011, UPPER)), ONLY_ONE) AS COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#213077, str_replace_extend(Ville+Immeuble#212017, [ST ,ST-], [SAINT-,SAINT-]) AS COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#213104]
Input [24]: [Proprietaire#212011, idMandat#212012, Code+immeuble#212013, Nom+Immeuble#212014, Adresse+Immeuble#212015, Code+Postal+Immeuble#212016, Ville+Immeuble#212017, Etage#212018, idLot#212019, N%C2%B0+Identifiant+Fiscal#212020, Numero+lot+syndic#212021, TypeLot#212022, Porte#212023, Surface#212024, NomLocataire#212025, DepotGar+%28euro%29#212026, Loyer%2Fan+%28euro%29#212027, Prov.+sur+charges%2Fan+%28euro%29#212028, idBail#212029, DPE#212030, GES#212031, Classe+Commune#212032, Classe+DPE#212033, Classe+GES#212034]

(5) Project [codegen id : 1]
Output [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, COL_A06CD743_975B_480F_890C_78685E530CD1#213023, COL_814180A7_65B9_4C68_A945_79F72A870824#213024, COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#213051, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#213077, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#213104, [- ,MAISOSNS], [-,MAISONS]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_EB3E9294_C63E_4108_AB19_81F98873297C#213187, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#213104]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, COL_A06CD743_975B_480F_890C_78685E530CD1#213023, COL_814180A7_65B9_4C68_A945_79F72A870824#213024, COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#213051, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#213077, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#213104]

(6) CollectLimit
Input [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#213003, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#213004, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#213005, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#213006, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#213007, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#213008, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#213009, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#213010, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#213011, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#213012, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#213013, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#213014, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#213015, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#213016, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#213017, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#213018, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#213019, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#213020, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#213021, COL_D6895B92_8213_46E8_95DE_5711D209346E#213022, COL_A06CD743_975B_480F_890C_78685E530CD1#213023, COL_814180A7_65B9_4C68_A945_79F72A870824#213024, COL_6126101C_76C5_4C25_A5F2_987862B98C80#213025, COL_32583C88_3290_4A7F_A097_95297001B6D6#213026, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#213051, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#213077, COL_EB3E9294_C63E_4108_AB19_81F98873297C#213187, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#213104]
Arguments: 1500

SQL / DataFrame Properties

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