SP1 - Details for Query 11283

Submitted Time: 2026/01/24 15:02:53
Duration: 0.2 s
Succeeded Jobs: 16744

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

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 2 ms number of written files: 1 job commit time: 11 ms number of output rows: 24 number of dynamic part: 0 written output: 3.1 KiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 131 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="BatchScan excel file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx number of output rows: 24"]; 1->0; 3->1; 4->3; }

Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_161435_3bd91559ea9fa05b0cc54dc64e2d2c25/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_25627045fa09349062229bff6b20a5ea, false, Parquet, [path=file:///data/input/depot/excel/cache/LISTE_UF_SUN_SU_161435_3bd91559ea9fa05b0cc54dc64e2d2c25/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_25627045fa09349062229bff6b20a5ea], ErrorIfExists, [Sp%C3%A9cialit%C3%A9+etab, Code+Etab, Codes+officiels, Sp%C3%A9cialit%C3%A9+urgentiste+UF, LISTE_UF_SUN_SU_161435HEADER_COL_DETAIL_DEPOT]

WriteFiles

Project [Spécialité etab#2312020 AS Sp%C3%A9cialit%C3%A9+etab#2312038, Code Etab#2312021 AS Code+Etab#2312044, Codes officiels#2312022 AS Codes+officiels#2312050, Spécialité urgentiste UF#2312023 AS Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312056, file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx AS LISTE_UF_SUN_SU_161435HEADER_COL_DETAIL_DEPOT#2312062]

WholeStageCodegen (1)

BatchScan excel file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx[Spécialité etab#2312020, Code Etab#2312021, Codes officiels#2312022, Spécialité urgentiste UF#2312023] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init..., PartitionFilters: [], ReadSchema: struct<Spécialité etab:string,Code Etab:string,Codes officiels:string,Spécialité urgentiste UF:st..., PushedFilters: [] RuntimeFilters: []

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
   +- * Project (2)
      +- BatchScan excel file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx (1)


(1) BatchScan excel file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx
Output [4]: [Spécialité etab#2312020, Code Etab#2312021, Codes officiels#2312022, Spécialité urgentiste UF#2312023]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx]
ReadSchema: struct<Spécialité etab:string,Code Etab:string,Codes officiels:string,Spécialité urgentiste UF:string>

(2) Project [codegen id : 1]
Output [5]: [Spécialité etab#2312020 AS Sp%C3%A9cialit%C3%A9+etab#2312038, Code Etab#2312021 AS Code+Etab#2312044, Codes officiels#2312022 AS Codes+officiels#2312050, Spécialité urgentiste UF#2312023 AS Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312056, file:/data/input/depot/excel/tmp/LISTE_UF_SUN_SU_161435/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx AS LISTE_UF_SUN_SU_161435HEADER_COL_DETAIL_DEPOT#2312062]
Input [4]: [Spécialité etab#2312020, Code Etab#2312021, Codes officiels#2312022, Spécialité urgentiste UF#2312023]

(3) WriteFiles
Input [5]: [Sp%C3%A9cialit%C3%A9+etab#2312038, Code+Etab#2312044, Codes+officiels#2312050, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312056, LISTE_UF_SUN_SU_161435HEADER_COL_DETAIL_DEPOT#2312062]

(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_161435_3bd91559ea9fa05b0cc54dc64e2d2c25/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_25627045fa09349062229bff6b20a5ea, false, Parquet, [path=file:///data/input/depot/excel/cache/LISTE_UF_SUN_SU_161435_3bd91559ea9fa05b0cc54dc64e2d2c25/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_25627045fa09349062229bff6b20a5ea], ErrorIfExists, [Sp%C3%A9cialit%C3%A9+etab, Code+Etab, Codes+officiels, Sp%C3%A9cialit%C3%A9+urgentiste+UF, LISTE_UF_SUN_SU_161435HEADER_COL_DETAIL_DEPOT]

SQL / DataFrame Properties

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