SP1 - Details for Query 233

Submitted Time: 2026/06/25 15:48:10
Duration: 0.2 s
Succeeded Jobs: 296

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: 74 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 4 [labelType="html" label="Scan parquet number of files read: 1 scan time: 43 ms metadata time: 0 ms size of files read: 148.0 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; }

CollectLimit 1500

Project [Proprietaire#75090 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#76407, idMandat#75091 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#76408, Code+immeuble#75092 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#76409, Nom+Immeuble#75093 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#76410, Adresse+Immeuble#75094 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#76411, Code+Postal+Immeuble#75095 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#76412, Ville+Immeuble#75096 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#76413, Etage#75097 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#76414, idLot#75098 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#76415, N%C2%B0+Identifiant+Fiscal#75099 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#76416, Numero+lot+syndic#75100 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#76417, TypeLot#75101 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#76418, Porte#75102 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#76419, Surface#75103 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#76420, NomLocataire#75104 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#76421, DepotGar+%28euro%29#75105 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#76422, Loyer%2Fan+%28euro%29#75106 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#76423, Prov.+sur+charges%2Fan+%28euro%29#75107 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#76424, idBail#75108 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#76425, DPE#75109 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#76426, GES#75110 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#76427, Classe+Commune#75111 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#76428, Classe+DPE#75112 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#76429, Classe+GES#75113 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#76430, ... 3 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [Proprietaire#75090,idMandat#75091,Code+immeuble#75092,Nom+Immeuble#75093,Adresse+Immeuble#75094,Code+Postal+Immeuble#75095,Ville+Immeuble#75096,Etage#75097,idLot#75098,N%C2%B0+Identifiant+Fiscal#75099,Numero+lot+syndic#75100,TypeLot#75101,Porte#75102,Surface#75103,NomLocataire#75104,DepotGar+%28euro%29#75105,Loyer%2Fan+%28euro%29#75106,Prov.+sur+charges%2Fan+%28euro%29#75107,idBail#75108,DPE#75109,GES#75110,Classe+Commune#75111,Classe+DPE#75112,Classe+GES#75113] 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...

Details

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


(1) Scan parquet 
Output [24]: [Proprietaire#75090, idMandat#75091, Code+immeuble#75092, Nom+Immeuble#75093, Adresse+Immeuble#75094, Code+Postal+Immeuble#75095, Ville+Immeuble#75096, Etage#75097, idLot#75098, N%C2%B0+Identifiant+Fiscal#75099, Numero+lot+syndic#75100, TypeLot#75101, Porte#75102, Surface#75103, NomLocataire#75104, DepotGar+%28euro%29#75105, Loyer%2Fan+%28euro%29#75106, Prov.+sur+charges%2Fan+%28euro%29#75107, idBail#75108, DPE#75109, GES#75110, Classe+Commune#75111, Classe+DPE#75112, Classe+GES#75113]
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#75090, idMandat#75091, Code+immeuble#75092, Nom+Immeuble#75093, Adresse+Immeuble#75094, Code+Postal+Immeuble#75095, Ville+Immeuble#75096, Etage#75097, idLot#75098, N%C2%B0+Identifiant+Fiscal#75099, Numero+lot+syndic#75100, TypeLot#75101, Porte#75102, Surface#75103, NomLocataire#75104, DepotGar+%28euro%29#75105, Loyer%2Fan+%28euro%29#75106, Prov.+sur+charges%2Fan+%28euro%29#75107, idBail#75108, DPE#75109, GES#75110, Classe+Commune#75111, Classe+DPE#75112, Classe+GES#75113]

(3) Project [codegen id : 1]
Output [27]: [Proprietaire#75090 AS COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#76407, idMandat#75091 AS COL_EC7474ED_A0A6_401C_BA97_20D63A467807#76408, Code+immeuble#75092 AS COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#76409, Nom+Immeuble#75093 AS COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#76410, Adresse+Immeuble#75094 AS COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#76411, Code+Postal+Immeuble#75095 AS COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#76412, Ville+Immeuble#75096 AS COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#76413, Etage#75097 AS COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#76414, idLot#75098 AS COL_D4E1F01A_72C8_4621_905A_881FB0249F81#76415, N%C2%B0+Identifiant+Fiscal#75099 AS COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#76416, Numero+lot+syndic#75100 AS COL_871E0000_AA32_4679_83B0_C8AA49007BCF#76417, TypeLot#75101 AS COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#76418, Porte#75102 AS COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#76419, Surface#75103 AS COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#76420, NomLocataire#75104 AS COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#76421, DepotGar+%28euro%29#75105 AS COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#76422, Loyer%2Fan+%28euro%29#75106 AS COL_0DB61D05_5348_40DB_8F16_C7916849A669#76423, Prov.+sur+charges%2Fan+%28euro%29#75107 AS COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#76424, idBail#75108 AS COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#76425, DPE#75109 AS COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#76426, GES#75110 AS COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#76427, Classe+Commune#75111 AS COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#76428, Classe+DPE#75112 AS COL_33CEA792_75B9_44A1_896B_B422BD28B923#76429, Classe+GES#75113 AS COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#76430, str_extract(Code+Postal+Immeuble#75095, LEFT, 2) AS COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#76431, str_remove_space(str_remove_accent(str_transform_case(Proprietaire#75090, UPPER)), ONLY_ONE) AS COL_730C7D9D_95B5_4388_983E_C4F260C553BD#76432, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(str_replace_extend(Ville+Immeuble#75096, [ST ,ST-], [SAINT ,SAINT-]), ONLY_ONE), [ST , ], [SAINT ,-])), UPPER) AS COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#76433]
Input [24]: [Proprietaire#75090, idMandat#75091, Code+immeuble#75092, Nom+Immeuble#75093, Adresse+Immeuble#75094, Code+Postal+Immeuble#75095, Ville+Immeuble#75096, Etage#75097, idLot#75098, N%C2%B0+Identifiant+Fiscal#75099, Numero+lot+syndic#75100, TypeLot#75101, Porte#75102, Surface#75103, NomLocataire#75104, DepotGar+%28euro%29#75105, Loyer%2Fan+%28euro%29#75106, Prov.+sur+charges%2Fan+%28euro%29#75107, idBail#75108, DPE#75109, GES#75110, Classe+Commune#75111, Classe+DPE#75112, Classe+GES#75113]

(4) CollectLimit
Input [27]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#76407, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#76408, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#76409, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#76410, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#76411, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#76412, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#76413, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#76414, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#76415, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#76416, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#76417, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#76418, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#76419, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#76420, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#76421, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#76422, COL_0DB61D05_5348_40DB_8F16_C7916849A669#76423, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#76424, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#76425, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#76426, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#76427, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#76428, COL_33CEA792_75B9_44A1_896B_B422BD28B923#76429, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#76430, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#76431, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#76432, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#76433]
Arguments: 1500

SQL / DataFrame Properties

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