SP1 - Details for Query 22

Submitted Time: 2026/07/24 10:12:30
Duration: 0.7 s
Succeeded Jobs: 30

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

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 15 ms number of written files: 1 job commit time: 24 ms number of output rows: 1 number of dynamic part: 0 written output: 2.1 KiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 304 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="BatchScan excel file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besan\u00E7on 310126.xlsx number of output rows: 1"]; 1->0; 3->1; 4->3; }

Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_2d3ba16657291a5e771124b1739e97ce, false, Parquet, [path=file:///data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_2d3ba16657291a5e771124b1739e97ce], ErrorIfExists, [Libell%C3%A9, Finess, Type+etab, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT]

WriteFiles

Project [Libellé#2472 AS Libell%C3%A9#2486, Finess#2473, Type etab#2474 AS Type+etab#2496, file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx AS 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#2501]

WholeStageCodegen (1)

BatchScan excel file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx[Libellé#2472, Finess#2473, Type etab#2474] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init..., PartitionFilters: [], ReadSchema: struct<Libellé:string,Finess:string,Type etab:string>, PushedFilters: [] RuntimeFilters: []

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
   +- * Project (2)
      +- BatchScan excel file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx (1)


(1) BatchScan excel file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx
Output [3]: [Libellé#2472, Finess#2473, Type etab#2474]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx]
ReadSchema: struct<Libellé:string,Finess:string,Type etab:string>

(2) Project [codegen id : 1]
Output [4]: [Libellé#2472 AS Libell%C3%A9#2486, Finess#2473, Type etab#2474 AS Type+etab#2496, file:/data/input/depot/excel/tmp/09_INFORMATION__187906/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx AS 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#2501]
Input [3]: [Libellé#2472, Finess#2473, Type etab#2474]

(3) WriteFiles
Input [4]: [Libell%C3%A9#2486, Finess#2473, Type+etab#2496, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#2501]

(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_2d3ba16657291a5e771124b1739e97ce, false, Parquet, [path=file:///data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_2d3ba16657291a5e771124b1739e97ce], ErrorIfExists, [Libell%C3%A9, Finess, Type+etab, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT]

SQL / DataFrame Properties

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