digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 0 ms<br>number of written files: 1<br>job commit time: 16 ms<br>number of output rows: 1,470<br>number of dynamic part: 0<br>written output: 42.4 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 1.1 s";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
}
4 [labelType="html" label="<b>BatchScan excel file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx</b><br><br>number of output rows: 1,470"];
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__161422_fa7dc9c2e8b9edf52d51fcbc3c9b2d74/DP_PE1.xlsx_0444bbee8290050c1bd8f1d705b47a4c, false, Parquet, [path=file:///data/input/depot/excel/cache/DIAGNOSTIC_PE1__161422_fa7dc9c2e8b9edf52d51fcbc3c9b2d74/DP_PE1.xlsx_0444bbee8290050c1bd8f1d705b47a4c], ErrorIfExists, [Code+CIM+10, Libell%C3%A9+long, Date_effet, Date_r%C3%A9vocation, Responsable+MAJ, Source, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT]
WriteFiles
Project [Code CIM 10#2352797 AS Code+CIM+10#2352829, Libellé long#2352798 AS Libell%C3%A9+long#2352837, Date_effet#2352799, Date_révocation#2352800 AS Date_r%C3%A9vocation#2352853, Responsable MAJ#2352801 AS Responsable+MAJ#2352861, Source#2352802, file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx AS DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2352877]
WholeStageCodegen (1)
BatchScan excel file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx[Code CIM 10#2352797, Libellé long#2352798, Date_effet#2352799, Date_révocation#2352800, Responsable MAJ#2352801, Source#2352802] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx], PartitionFilters: [], ReadSchema: struct<Code CIM 10:string,Libellé long:string,Date_effet:string,Date_révocation:string,Responsabl..., PushedFilters: [] RuntimeFilters: []
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- BatchScan excel file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx (1)
(1) BatchScan excel file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx
Output [6]: [Code CIM 10#2352797, Libellé long#2352798, Date_effet#2352799, Date_révocation#2352800, Responsable MAJ#2352801, Source#2352802]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx]
ReadSchema: struct<Code CIM 10:string,Libellé long:string,Date_effet:string,Date_révocation:string,Responsable MAJ:string,Source:string>
(2) Project [codegen id : 1]
Output [7]: [Code CIM 10#2352797 AS Code+CIM+10#2352829, Libellé long#2352798 AS Libell%C3%A9+long#2352837, Date_effet#2352799, Date_révocation#2352800 AS Date_r%C3%A9vocation#2352853, Responsable MAJ#2352801 AS Responsable+MAJ#2352861, Source#2352802, file:/data/input/depot/excel/tmp/DIAGNOSTIC_PE1__161422/DP_PE1.xlsx AS DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2352877]
Input [6]: [Code CIM 10#2352797, Libellé long#2352798, Date_effet#2352799, Date_révocation#2352800, Responsable MAJ#2352801, Source#2352802]
(3) WriteFiles
Input [7]: [Code+CIM+10#2352829, Libell%C3%A9+long#2352837, Date_effet#2352799, Date_r%C3%A9vocation#2352853, Responsable+MAJ#2352861, Source#2352802, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2352877]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/DIAGNOSTIC_PE1__161422_fa7dc9c2e8b9edf52d51fcbc3c9b2d74/DP_PE1.xlsx_0444bbee8290050c1bd8f1d705b47a4c, false, Parquet, [path=file:///data/input/depot/excel/cache/DIAGNOSTIC_PE1__161422_fa7dc9c2e8b9edf52d51fcbc3c9b2d74/DP_PE1.xlsx_0444bbee8290050c1bd8f1d705b47a4c], ErrorIfExists, [Code+CIM+10, Libell%C3%A9+long, Date_effet, Date_r%C3%A9vocation, Responsable+MAJ, Source, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT]