digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 45 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1,455<br>number of input batches: 1"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 8 ms<br>metadata time: 0 ms<br>size of files read: 148.0 KiB<br>number of output rows: 1,455"];
2->0;
3->2;
4->3;
5->4;
}
6
CollectLimit 1500
Project [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, COL_A06CD743_975B_480F_890C_78685E530CD1#85880, COL_814180A7_65B9_4C68_A945_79F72A870824#85881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, ... 4 more fields]
Project [Proprietaire#84868 AS COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, idMandat#84869 AS COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, Code+immeuble#84870 AS COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, Nom+Immeuble#84871 AS COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, Adresse+Immeuble#84872 AS COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, Code+Postal+Immeuble#84873 AS COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, Ville+Immeuble#84874 AS COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, Etage#84875 AS COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, idLot#84876 AS COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, N%C2%B0+Identifiant+Fiscal#84877 AS COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, Numero+lot+syndic#84878 AS COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, TypeLot#84879 AS COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, Porte#84880 AS COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, Surface#84881 AS COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, NomLocataire#84882 AS COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, DepotGar+%28euro%29#84883 AS COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, Loyer%2Fan+%28euro%29#84884 AS COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, Prov.+sur+charges%2Fan+%28euro%29#84885 AS COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, idBail#84886 AS COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, DPE#84887 AS COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, GES#84888 AS COL_A06CD743_975B_480F_890C_78685E530CD1#85880, Classe+Commune#84889 AS COL_814180A7_65B9_4C68_A945_79F72A870824#85881, Classe+DPE#84890 AS COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, Classe+GES#84891 AS COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, ... 3 more fields]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [Proprietaire#84868,idMandat#84869,Code+immeuble#84870,Nom+Immeuble#84871,Adresse+Immeuble#84872,Code+Postal+Immeuble#84873,Ville+Immeuble#84874,Etage#84875,idLot#84876,N%C2%B0+Identifiant+Fiscal#84877,Numero+lot+syndic#84878,TypeLot#84879,Porte#84880,Surface#84881,NomLocataire#84882,DepotGar+%28euro%29#84883,Loyer%2Fan+%28euro%29#84884,Prov.+sur+charges%2Fan+%28euro%29#84885,idBail#84886,DPE#84887,GES#84888,Classe+Commune#84889,Classe+DPE#84890,Classe+GES#84891] Batched: true, DataFilters: [], 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...
== Physical Plan ==
CollectLimit (5)
+- * Project (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [24]: [Proprietaire#84868, idMandat#84869, Code+immeuble#84870, Nom+Immeuble#84871, Adresse+Immeuble#84872, Code+Postal+Immeuble#84873, Ville+Immeuble#84874, Etage#84875, idLot#84876, N%C2%B0+Identifiant+Fiscal#84877, Numero+lot+syndic#84878, TypeLot#84879, Porte#84880, Surface#84881, NomLocataire#84882, DepotGar+%28euro%29#84883, Loyer%2Fan+%28euro%29#84884, Prov.+sur+charges%2Fan+%28euro%29#84885, idBail#84886, DPE#84887, GES#84888, Classe+Commune#84889, Classe+DPE#84890, Classe+GES#84891]
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#84868, idMandat#84869, Code+immeuble#84870, Nom+Immeuble#84871, Adresse+Immeuble#84872, Code+Postal+Immeuble#84873, Ville+Immeuble#84874, Etage#84875, idLot#84876, N%C2%B0+Identifiant+Fiscal#84877, Numero+lot+syndic#84878, TypeLot#84879, Porte#84880, Surface#84881, NomLocataire#84882, DepotGar+%28euro%29#84883, Loyer%2Fan+%28euro%29#84884, Prov.+sur+charges%2Fan+%28euro%29#84885, idBail#84886, DPE#84887, GES#84888, Classe+Commune#84889, Classe+DPE#84890, Classe+GES#84891]
(3) Project [codegen id : 1]
Output [27]: [Proprietaire#84868 AS COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, idMandat#84869 AS COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, Code+immeuble#84870 AS COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, Nom+Immeuble#84871 AS COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, Adresse+Immeuble#84872 AS COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, Code+Postal+Immeuble#84873 AS COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, Ville+Immeuble#84874 AS COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, Etage#84875 AS COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, idLot#84876 AS COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, N%C2%B0+Identifiant+Fiscal#84877 AS COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, Numero+lot+syndic#84878 AS COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, TypeLot#84879 AS COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, Porte#84880 AS COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, Surface#84881 AS COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, NomLocataire#84882 AS COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, DepotGar+%28euro%29#84883 AS COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, Loyer%2Fan+%28euro%29#84884 AS COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, Prov.+sur+charges%2Fan+%28euro%29#84885 AS COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, idBail#84886 AS COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, DPE#84887 AS COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, GES#84888 AS COL_A06CD743_975B_480F_890C_78685E530CD1#85880, Classe+Commune#84889 AS COL_814180A7_65B9_4C68_A945_79F72A870824#85881, Classe+DPE#84890 AS COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, Classe+GES#84891 AS COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, str_extract(Code+Postal+Immeuble#84873, LEFT, 2) AS COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#85908, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#84868, UPPER)), ONLY_ONE) AS COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#85934, str_replace_extend(Ville+Immeuble#84874, [ST ,ST-], [SAINT ,SAINT-]) AS COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#85961]
Input [24]: [Proprietaire#84868, idMandat#84869, Code+immeuble#84870, Nom+Immeuble#84871, Adresse+Immeuble#84872, Code+Postal+Immeuble#84873, Ville+Immeuble#84874, Etage#84875, idLot#84876, N%C2%B0+Identifiant+Fiscal#84877, Numero+lot+syndic#84878, TypeLot#84879, Porte#84880, Surface#84881, NomLocataire#84882, DepotGar+%28euro%29#84883, Loyer%2Fan+%28euro%29#84884, Prov.+sur+charges%2Fan+%28euro%29#84885, idBail#84886, DPE#84887, GES#84888, Classe+Commune#84889, Classe+DPE#84890, Classe+GES#84891]
(4) Project [codegen id : 1]
Output [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, COL_A06CD743_975B_480F_890C_78685E530CD1#85880, COL_814180A7_65B9_4C68_A945_79F72A870824#85881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#85908, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#85934, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#85961, ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_EB3E9294_C63E_4108_AB19_81F98873297C#86044, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#85961]
Input [27]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, COL_A06CD743_975B_480F_890C_78685E530CD1#85880, COL_814180A7_65B9_4C68_A945_79F72A870824#85881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#85908, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#85934, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#85961]
(5) CollectLimit
Input [28]: [COL_4EBCB649_BD59_44D4_93D8_0190857315F0#85860, COL_17C5ACD3_88E6_41EC_8D3D_F0B640AAF06D#85861, COL_3C6CF7C7_B28A_471F_8594_D61CC5EE8982#85862, COL_5650E892_33D9_479C_80EA_2B2525AC4A45#85863, COL_B8529A3D_A48A_452B_9F16_AB1A4BAC139E#85864, COL_A43814C6_7077_46AF_835B_D0B18EDC70A4#85865, COL_17C6E0D1_E0FE_458D_ADA6_8A3FD0CD3BD8#85866, COL_FD8D65C6_F2A5_4B28_B017_EB5FA0BC7D01#85867, COL_9163F93A_A5AE_45D6_8B1F_2EF92CA842A7#85868, COL_89DC6301_086A_4E9C_8672_8F2751FE3B89#85869, COL_F187B9B8_0063_41CE_9385_F751840CD2EB#85870, COL_7355068D_CDF5_4BA6_85EA_51C5C86F6E4D#85871, COL_27EA5CFC_8F1D_4585_BB08_72464BAA54EE#85872, COL_B697D958_0150_4D9A_9824_47CA5DE6D555#85873, COL_D9B18DD3_50F3_420E_95E6_B409033BFCE3#85874, COL_437E7927_9755_4EE7_B335_1FE4CA5F9327#85875, COL_2292659F_7091_49C8_ABBD_97FCDEADA803#85876, COL_9AFCAB8D_3D04_48AE_9F50_6B01764CB67A#85877, COL_2DC72776_0A20_4BB9_AC11_FE4F0EF53FC6#85878, COL_D6895B92_8213_46E8_95DE_5711D209346E#85879, COL_A06CD743_975B_480F_890C_78685E530CD1#85880, COL_814180A7_65B9_4C68_A945_79F72A870824#85881, COL_6126101C_76C5_4C25_A5F2_987862B98C80#85882, COL_32583C88_3290_4A7F_A097_95297001B6D6#85883, COL_59A12E4B_B97F_44F7_B81C_7E4C33291E86#85908, COL_AFF6BAB0_FA4D_4135_915A_352B6CB0AC5B#85934, COL_EB3E9294_C63E_4108_AB19_81F98873297C#86044, COL_91CCDC8B_39E5_4964_B896_E001F6DD512A#85961]
Arguments: 1500