Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#99853)), --)) THEN false ELSE Contains(str_remove_accent(upper(Proprietaire#99853)), --) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(idMandat#99854)), --)) THEN false ELSE Contains(str_remove_accent(upper(idMandat#99854)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+immeuble#99855)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+immeuble#99855)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --)) THEN false ELSE Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --)) THEN false ELSE Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --)) THEN false ELSE Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Etage#99860)), --)) THEN false ELSE Contains(str_remove_accent(upper(Etage#99860)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idLot#99861)), --)) THEN false ELSE Contains(str_remove_accent(upper(idLot#99861)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --)) THEN false ELSE Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --)) THEN false ELSE Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TypeLot#99864)), --)) THEN false ELSE Contains(str_remove_accent(upper(TypeLot#99864)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Porte#99865)), --)) THEN false ELSE Contains(str_remove_accent(upper(Porte#99865)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Surface#99866)), --)) THEN false ELSE Contains(str_remove_accent(upper(Surface#99866)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NomLocataire#99867)), --)) THEN false ELSE Contains(str_remove_accent(upper(NomLocataire#99867)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --)) THEN false ELSE Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --)) THEN false ELSE Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --)) THEN false ELSE Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idBail#99871)), --)) THEN false ELSE Contains(str_remove_accent(upper(idBail#99871)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DPE#99872)), --)) THEN false ELSE Contains(str_remove_accent(upper(DPE#99872)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GES#99873)), --)) THEN false ELSE Contains(str_remove_accent(upper(GES#99873)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+Commune#99874)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+Commune#99874)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+DPE#99875)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+DPE#99875)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+GES#99876)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+GES#99876)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --) 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(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --) END)
== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
* HashAggregate (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
HashAggregate (13)
+- Exchange (12)
+- HashAggregate (11)
+- Project (10)
+- Filter (9)
+- Scan parquet (1)
(1) Scan parquet
Output [24]: [Proprietaire#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
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#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
(3) Filter [codegen id : 1]
Input [24]: [Proprietaire#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#99853)), --)) THEN false ELSE Contains(str_remove_accent(upper(Proprietaire#99853)), --) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(idMandat#99854)), --)) THEN false ELSE Contains(str_remove_accent(upper(idMandat#99854)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+immeuble#99855)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+immeuble#99855)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --)) THEN false ELSE Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --)) THEN false ELSE Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --)) THEN false ELSE Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Etage#99860)), --)) THEN false ELSE Contains(str_remove_accent(upper(Etage#99860)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idLot#99861)), --)) THEN false ELSE Contains(str_remove_accent(upper(idLot#99861)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --)) THEN false ELSE Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --)) THEN false ELSE Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TypeLot#99864)), --)) THEN false ELSE Contains(str_remove_accent(upper(TypeLot#99864)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Porte#99865)), --)) THEN false ELSE Contains(str_remove_accent(upper(Porte#99865)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Surface#99866)), --)) THEN false ELSE Contains(str_remove_accent(upper(Surface#99866)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NomLocataire#99867)), --)) THEN false ELSE Contains(str_remove_accent(upper(NomLocataire#99867)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --)) THEN false ELSE Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --)) THEN false ELSE Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --)) THEN false ELSE Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idBail#99871)), --)) THEN false ELSE Contains(str_remove_accent(upper(idBail#99871)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DPE#99872)), --)) THEN false ELSE Contains(str_remove_accent(upper(DPE#99872)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GES#99873)), --)) THEN false ELSE Contains(str_remove_accent(upper(GES#99873)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+Commune#99874)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+Commune#99874)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+DPE#99875)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+DPE#99875)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+GES#99876)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+GES#99876)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --) 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(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --) END)
(4) Project [codegen id : 1]
Output: []
Input [24]: [Proprietaire#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#101090L]
Results [1]: [count#101091L]
(6) Exchange
Input [1]: [count#101091L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=14272]
(7) ShuffleQueryStage
Output [1]: [count#101091L]
Arguments: 0
(8) HashAggregate [codegen id : 2]
Input [1]: [count#101091L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#101087L]
Results [1]: [count(1)#101087L AS count#101088L]
(9) Filter
Input [24]: [Proprietaire#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(Proprietaire#99853)), --)) THEN false ELSE Contains(str_remove_accent(upper(Proprietaire#99853)), --) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(idMandat#99854)), --)) THEN false ELSE Contains(str_remove_accent(upper(idMandat#99854)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+immeuble#99855)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+immeuble#99855)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --)) THEN false ELSE Contains(str_remove_accent(upper(Nom+Immeuble#99856)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --)) THEN false ELSE Contains(str_remove_accent(upper(Adresse+Immeuble#99857)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --)) THEN false ELSE Contains(str_remove_accent(upper(Code+Postal+Immeuble#99858)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --)) THEN false ELSE Contains(str_remove_accent(upper(Ville+Immeuble#99859)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Etage#99860)), --)) THEN false ELSE Contains(str_remove_accent(upper(Etage#99860)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idLot#99861)), --)) THEN false ELSE Contains(str_remove_accent(upper(idLot#99861)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --)) THEN false ELSE Contains(str_remove_accent(upper(N%C2%B0+Identifiant+Fiscal#99862)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --)) THEN false ELSE Contains(str_remove_accent(upper(Numero+lot+syndic#99863)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TypeLot#99864)), --)) THEN false ELSE Contains(str_remove_accent(upper(TypeLot#99864)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Porte#99865)), --)) THEN false ELSE Contains(str_remove_accent(upper(Porte#99865)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Surface#99866)), --)) THEN false ELSE Contains(str_remove_accent(upper(Surface#99866)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NomLocataire#99867)), --)) THEN false ELSE Contains(str_remove_accent(upper(NomLocataire#99867)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --)) THEN false ELSE Contains(str_remove_accent(upper(DepotGar+%28euro%29#99868)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --)) THEN false ELSE Contains(str_remove_accent(upper(Loyer%2Fan+%28euro%29#99869)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --)) THEN false ELSE Contains(str_remove_accent(upper(Prov.+sur+charges%2Fan+%28euro%29#99870)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(idBail#99871)), --)) THEN false ELSE Contains(str_remove_accent(upper(idBail#99871)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DPE#99872)), --)) THEN false ELSE Contains(str_remove_accent(upper(DPE#99872)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GES#99873)), --)) THEN false ELSE Contains(str_remove_accent(upper(GES#99873)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+Commune#99874)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+Commune#99874)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+DPE#99875)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+DPE#99875)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Classe+GES#99876)), --)) THEN false ELSE Contains(str_remove_accent(upper(Classe+GES#99876)), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_extract(Code+Postal+Immeuble#99858, LEFT, 2))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_accent(str_transform_case(Proprietaire#99853, UPPER)), ONLY_ONE))), --) 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(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER))), --) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --)) THEN false ELSE Contains(str_remove_accent(upper(str_replace_extend(Ville+Immeuble#99859, [ST ,ST-], [SAINT-,SAINT-]))), --) END)
(10) Project
Output: []
Input [24]: [Proprietaire#99853, idMandat#99854, Code+immeuble#99855, Nom+Immeuble#99856, Adresse+Immeuble#99857, Code+Postal+Immeuble#99858, Ville+Immeuble#99859, Etage#99860, idLot#99861, N%C2%B0+Identifiant+Fiscal#99862, Numero+lot+syndic#99863, TypeLot#99864, Porte#99865, Surface#99866, NomLocataire#99867, DepotGar+%28euro%29#99868, Loyer%2Fan+%28euro%29#99869, Prov.+sur+charges%2Fan+%28euro%29#99870, idBail#99871, DPE#99872, GES#99873, Classe+Commune#99874, Classe+DPE#99875, Classe+GES#99876]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#101090L]
Results [1]: [count#101091L]
(12) Exchange
Input [1]: [count#101091L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=14252]
(13) HashAggregate
Input [1]: [count#101091L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#101087L]
Results [1]: [count(1)#101087L AS count#101088L]
(14) AdaptiveSparkPlan
Output [1]: [count#101088L]
Arguments: isFinalPlan=true