EVAL1_SPC1 - Details for Query 138

Submitted Time: 2026/06/03 08:05:25
Duration: 0.4 s
Succeeded Jobs: 311

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

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 10 ms number of output rows: 39 number of dynamic part: 0 written output: 3.0 KiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 221 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="BatchScan excel file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx number of output rows: 39"]; 1->0; 3->1; 4->3; }

Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/LOT_3_AIRFLOW_23179_c1ee7d367834af56fc00719c3a66dcde/LotMulti.xlsx_f128ad97a9aad2ad4e7c22cc6bd3a14a, false, Parquet, [path=file:///data/input/depot/excel/cache/LOT_3_AIRFLOW_23179_c1ee7d367834af56fc00719c3a66dcde/LotMulti.xlsx_f128ad97a9aad2ad4e7c22cc6bd3a14a], ErrorIfExists, [Num%C3%A9ro+Lot, Time, Fr%C3%A9quence+%28s%29, Bioreactor+1+-+Air+flow, LOT_3_AIRFLOW_23179HEADER_COL_DETAIL_DEPOT]

WriteFiles

Project [Numéro Lot#80125 AS Num%C3%A9ro+Lot#80143, Time#80126, Fréquence (s)#80127 AS Fr%C3%A9quence+%28s%29#80155, Bioreactor 1 - Air flow#80128 AS Bioreactor+1+-+Air+flow#80161, file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx AS LOT_3_AIRFLOW_23179HEADER_COL_DETAIL_DEPOT#80167]

WholeStageCodegen (1)

BatchScan excel file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx[Numéro Lot#80125, Time#80126, Fréquence (s)#80127, Bioreactor 1 - Air flow#80128] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/Lot..., PartitionFilters: [], ReadSchema: struct<Numéro Lot:string,Time:string,Fréquence (s):string,Bioreactor 1 - Air flow:string>, PushedFilters: [] RuntimeFilters: []

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
   +- * Project (2)
      +- BatchScan excel file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx (1)


(1) BatchScan excel file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx
Output [4]: [Numéro Lot#80125, Time#80126, Fréquence (s)#80127, Bioreactor 1 - Air flow#80128]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx]
ReadSchema: struct<Numéro Lot:string,Time:string,Fréquence (s):string,Bioreactor 1 - Air flow:string>

(2) Project [codegen id : 1]
Output [5]: [Numéro Lot#80125 AS Num%C3%A9ro+Lot#80143, Time#80126, Fréquence (s)#80127 AS Fr%C3%A9quence+%28s%29#80155, Bioreactor 1 - Air flow#80128 AS Bioreactor+1+-+Air+flow#80161, file:/data/input/depot/excel/execution/LOT_3_AIRFLOW_23179/current/LotMulti.xlsx AS LOT_3_AIRFLOW_23179HEADER_COL_DETAIL_DEPOT#80167]
Input [4]: [Numéro Lot#80125, Time#80126, Fréquence (s)#80127, Bioreactor 1 - Air flow#80128]

(3) WriteFiles
Input [5]: [Num%C3%A9ro+Lot#80143, Time#80126, Fr%C3%A9quence+%28s%29#80155, Bioreactor+1+-+Air+flow#80161, LOT_3_AIRFLOW_23179HEADER_COL_DETAIL_DEPOT#80167]

(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/LOT_3_AIRFLOW_23179_c1ee7d367834af56fc00719c3a66dcde/LotMulti.xlsx_f128ad97a9aad2ad4e7c22cc6bd3a14a, false, Parquet, [path=file:///data/input/depot/excel/cache/LOT_3_AIRFLOW_23179_c1ee7d367834af56fc00719c3a66dcde/LotMulti.xlsx_f128ad97a9aad2ad4e7c22cc6bd3a14a], ErrorIfExists, [Num%C3%A9ro+Lot, Time, Fr%C3%A9quence+%28s%29, Bioreactor+1+-+Air+flow, LOT_3_AIRFLOW_23179HEADER_COL_DETAIL_DEPOT]

SQL / DataFrame Properties

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